[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 3 >
3 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Carter, Jason,11724 | 210.09 | 0.00 | 0.00 | 113.86 | 96.23 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 401.27 | 274.37 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 2329.99 | 2438.06 |
Generated 2026-07-22 22:19:39.833 UTC