[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 |
|---|---|---|---|---|
| 2023 | 3943747.67 | 1667413.50 | 2276334.17 | 0.00 |
| 2025 | 4614922.15 | 1874962.10 | 1389341.04 | 1350619.01 |
| 2024 | 5386913.91 | 2293410.90 | 2949181.20 | 144321.81 |
| 2022 | 432341.98 | 201385.61 | 230956.37 | 0.00 |
| _SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2025-12-07 18:08:54.364 UTC