[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 |
|---|---|---|---|---|
| 2022 | 115360.89 | 38850.66 | 76510.23 | 0.00 |
| 2024 | 5478100.78 | 2345835.55 | 3121578.52 | 10686.71 |
| 2025 | 5181902.40 | 2000319.45 | 1697328.84 | 1484254.11 |
| 2023 | 3602561.64 | 1652166.45 | 1950395.19 | 0.00 |
| _SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2026-01-08 17:32:28.731 UTC