[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 33 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 0.00 | 4822.00 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 0.00 | 152.94 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Chen, Jeffery, C,16827 | 7205.36 | 0.00 | 0.00 | 2443.35 | 4762.01 |
| Hernandez, Jonathon, F,15699 | 6969.57 | 0.00 | 2181.56 | 0.00 | 4788.01 |
| Rubio, Gary, M,20150 | 3264.02 | 0.00 | 699.10 | 0.00 | 2564.92 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Diaz, Alexandria,19926 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Serrano, Frank,23232 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Navarro, Shannon, R,15106 | 8421.28 | 0.00 | 3578.27 | 0.00 | 4843.01 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Nath, Lindsay,21841 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 0.00 | 4761.03 |
| Ward, Alex, I,14542 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Vazquez, Lee,14843 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Chen, Alejandro,14947 | 6658.58 | 0.00 | 3578.27 | 0.00 | 3080.31 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Chandra, Regina, M,15057 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Martin, Ross,16201 | 3058.01 | 0.00 | 2181.56 | 0.00 | 876.45 |
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Diaz, Larry, T,13664 | 210.25 | 0.00 | 0.00 | 0.00 | 210.25 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Butler, Eduardo, G,13533 | 137.94 | 0.00 | 0.00 | 0.00 | 137.94 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Kapoor, Marco,19512 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Patel, Patricia,20569 | 3114.06 | 0.00 | 699.10 | 0.00 | 2414.96 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rana, Heidi, M,22475 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Cai, Lacey, L,12733 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Mehta, Ruth,15702 | 6917.54 | 0.00 | 2181.56 | 0.00 | 4735.98 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Liu, Jorge, J,20592 | 3113.22 | 0.00 | 782.99 | 0.00 | 2330.23 |
| Henderson, Faith,14545 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Deng, Dale,28399 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Xie, Colleen, C,12133 | 5830.68 | 0.00 | 0.00 | 2071.42 | 3759.26 |
| Sharma, Latoya,19260 | 1592.71 | 0.00 | 0.00 | 1000.44 | 592.27 |
| Navarro, Joy,16410 | 3242.77 | 0.00 | 0.00 | 2443.35 | 799.42 |
| Mehta, Douglas,19258 | 1574.42 | 0.00 | 0.00 | 1000.44 | 573.98 |
| Ruiz, Erika, J,19192 | 1682.41 | 0.00 | 0.00 | 1000.44 | 681.97 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Romero, Juan, A,16324 | 3282.81 | 0.00 | 0.00 | 2443.35 | 839.46 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Carlson, Derrick, R,28436 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Sun, Willie,19278 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
| Xu, Omar, A,22596 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Ramos, Alberto,12239 | 6901.42 | 0.00 | 0.00 | 2071.42 | 4830.00 |
| Martinez, George, L,20570 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 0.00 | 782.99 | 1764.96 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 0.00 | 2071.42 | 4757.96 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2071.42 | 3090.31 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Long, Maria,16036 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Ashe, Bruce,12264 | 5662.90 | 0.00 | 0.00 | 3292.94 | 2369.96 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Jones, Chloe,20838 | 2541.94 | 0.00 | 0.00 | 782.99 | 1758.95 |
| Roberts, Gabriella, J,16553 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Gao, Lacey, C,16531 | 3291.80 | 0.00 | 0.00 | 2443.35 | 848.45 |
| Chander, Casey, C,16554 | 2990.52 | 0.00 | 0.00 | 2181.56 | 808.96 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Lal, Wayne, C,16829 | 7185.37 | 0.00 | 0.00 | 2443.35 | 4742.02 |
| Ruiz, Stacy,16823 | 7242.35 | 0.00 | 0.00 | 2443.35 | 4799.00 |
| Romero, Gerald, K,19322 | 1565.43 | 0.00 | 0.00 | 1000.44 | 564.99 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Vazquez, Theodore, T,16831 | 7206.37 | 0.00 | 0.00 | 2443.35 | 4763.02 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Yuan, Omar, C,12380 | 5570.22 | 0.00 | 0.00 | 2049.10 | 3521.12 |
| Raje, Karl,19362 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Luo, Bonnie,19337 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
| Hernandez, Joanna,19360 | 3511.76 | 0.00 | 0.00 | 3511.76 | 0.00 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Chen, Tamara,12382 | 5606.26 | 0.00 | 0.00 | 2071.42 | 3534.84 |
| Sara, Henry, L,20892 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Raman, Bruce,20886 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Adams, Rebecca, F,17644 | 3017.33 | 0.00 | 0.00 | 3017.33 | 0.00 |
| Ye, Kristen, D,12486 | 5652.40 | 0.00 | 0.00 | 2049.10 | 3603.30 |
| Wagner, Clayton, L,20922 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Raje, Bridget, A,19433 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Sanchez, Brian, F,20931 | 3273.17 | 0.00 | 0.00 | 782.99 | 2490.18 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Jiménez, Arthur, K,20982 | 2546.96 | 0.00 | 0.00 | 2546.96 | 0.00 |
| Nelson, Luke, E,21027 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Zhou, Colin,17962 | 2777.52 | 0.00 | 0.00 | 2181.56 | 595.96 |
Generated 2026-01-04 05:48:28.692 UTC