[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Cox, Nathaniel, A,19661 | 2521.27 | 0.00 | 0.00 | 0.00 | 2521.27 |
| 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 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 572.88 | 436.36 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 751.34 | 2304.98 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 790.61 | 515.05 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
Generated 2026-07-22 18:47:16.128 UTC