[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 63 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Romero, Alberto,11586 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Cai, Colleen, J,15088 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Kapoor, Carolyn, M,16459 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Jenkins, Caleb,14184 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Wu, Dawn, T,11493 | 6958.80 | 0.00 | 3399.99 | 0.00 | 3558.81 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
| Hernandez, Jonathon, F,15699 | 6969.57 | 0.00 | 2181.56 | 0.00 | 4788.01 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 0.00 | 4757.02 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Xu, Laura, D,16287 | 4538.84 | 0.00 | 0.00 | 2181.56 | 2357.28 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Lal, Omar, S,19193 | 1609.40 | 0.00 | 0.00 | 1000.44 | 608.96 |
| Alonso, Eddie, L,16420 | 2959.00 | 0.00 | 0.00 | 2181.56 | 777.44 |
| Ruiz, Erika, J,19192 | 1682.41 | 0.00 | 0.00 | 1000.44 | 681.97 |
| Sanz, Ebony, I,20711 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ruiz, Ricky,20718 | 3283.43 | 0.00 | 0.00 | 782.99 | 2500.44 |
| Sun, Willie,19278 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 0.00 | 2443.35 | 799.48 |
| Ruiz, Juan,28746 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Xu, Eugene, A,14208 | 117.43 | 0.00 | 0.00 | 58.47 | 58.96 |
| Moreno, Francis, A,26962 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Dominguez, Jésus,17087 | 75.21 | 0.00 | 0.00 | 0.00 | 75.21 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 0.00 | 2071.42 | 4757.96 |
| Jones, Brianna,25546 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Garcia, Carla,14172 | 75.74 | 0.00 | 0.00 | 0.00 | 75.74 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 2071.42 | 3553.83 |
| Butler, Eduardo, G,13533 | 137.94 | 0.00 | 0.00 | 0.00 | 137.94 |
| Sun, Vincent, F,16585 | 7192.39 | 0.00 | 0.00 | 2443.35 | 4749.04 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Rodriguez, Jessica,21669 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Kapoor, Marco,19512 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| 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 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Carlson, Derrick, R,28436 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Hu, Curtis, G,27880 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Jones, Andrew, C,16594 | 7231.37 | 0.00 | 0.00 | 2443.35 | 4788.02 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Gutierrez, Craig,19049 | 4838.30 | 0.00 | 0.00 | 2443.35 | 2394.95 |
Generated 2025-12-23 14:10:13.865 UTC