[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 94 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Cox, Nathaniel, A,19661 | 2521.27 | 0.00 | 0.00 | 0.00 | 2521.27 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gutierrez, Linda, D,28575 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Li, Jordan,17026 | 261.39 | 0.00 | 0.00 | 0.00 | 261.39 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 0.00 | 159.22 |
Generated 2025-12-21 20:32:53.963 UTC