[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
5 items
| OrderDate.Year()Id | _SUM | Mountain | Road | Touring |
|---|---|---|---|---|
| 2025 | 5627529.64 | 2242316.26 | 2515892.99 | 869320.39 |
| 2024 | 4919709.80 | 2139317.64 | 2780392.16 | 0.00 |
| 2026 | 2153546.78 | 849777.62 | 678148.73 | 625620.43 |
| 2023 | 1677139.49 | 805760.59 | 871378.90 | 0.00 |
| _SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2026-07-19 19:00:44.835 UTC