[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 461 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hayes, Oscar,26527 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 100.46 | 34.98 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 235.15 | 98.97 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Rogers, Sara,19874 | 4544.45 | 0.00 | 3374.99 | 0.00 | 1169.46 |
Generated 2025-11-06 11:29:44.329 UTC