[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 525 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Morris, Richard,20070 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cook, Bryce,28640 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lal, Luke, L,11019 | 698.23 | 0.00 | 0.00 | 0.00 | 698.23 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 0.00 | 140.17 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 0.00 | 1390.55 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 0.00 | 111.79 |
Generated 2026-01-04 05:45:44.428 UTC