[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 | 2901825.66 | 1332215.73 | 1569609.93 | 0.00 |
| 2023 | 5349656.10 | 2202994.98 | 3146661.12 | 0.00 |
| 2025 | 585196.93 | 247445.39 | 97232.41 | 240519.13 |
| 2024 | 5541247.02 | 2254516.01 | 2032309.32 | 1254421.69 |
| _SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2025-03-14 02:53:38.222 UTC