[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1248 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Foster, Nathan,20954 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Patterson, Mya, A,18953 | 777.44 | 0.00 | 0.00 | 0.00 | 777.44 | 0.00 |
| Wright, Caleb,15843 | 3142.97 | 0.00 | 0.00 | 782.99 | 2359.98 | 0.00 |
| Morris, Bryan, D,25162 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Alonso, Lawrence, S,12323 | 7258.63 | 0.00 | 0.00 | 0.00 | 7258.63 | 0.00 |
| Ortega, Kathleen, G,12225 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 | 0.00 |
| Zhao, Brent,22500 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 | 0.00 |
| Anderson, Ian, M,28860 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 | 0.00 |
| Diaz, Dakota,15967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Harris, Fernando, R,17876 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 | 0.00 |
| Madan, Levi,15446 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 | 0.00 |
| Carlson, Jimmy,12642 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 | 0.00 |
| Chen, Jorge, T,20442 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 | 0.00 |
| Patterson, Jason,20385 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 | 0.00 |
| Henderson, Kayla,26611 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 | 0.00 |
Generated 2026-01-04 05:26:30.704 UTC