[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 41 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chander, Lindsey,26949 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Zhou, Curtis,25505 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gutierrez, Raquel, H,28697 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Chander, Mario,12590 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Jenkins, Blake,28907 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Alonso, Francis, J,21738 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 0.00 | 70.24 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Kapoor, George, L,13676 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Coleman, Christian,25798 | 2452.34 | 0.00 | 0.00 | 0.00 | 2452.34 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Carlson, Melinda,20921 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Morris, Savannah,13585 | 8368.29 | 3578.27 | 0.00 | 0.00 | 4790.02 |
| Fernandez, Roy, S,15444 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Zeng, Randy, A,11341 | 8192.00 | 0.00 | 3399.99 | 2338.97 | 2453.04 |
Generated 2026-01-04 08:52:24.885 UTC