[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 |
|---|---|---|---|---|
| 2024 | 5651305.01 | 2250221.12 | 2546191.23 | 854892.66 |
| 2022 | 1513359.61 | 750227.02 | 763132.59 | 0.00 |
| 2025 | 2390261.11 | 974480.93 | 775732.02 | 640048.16 |
| 2023 | 4822999.98 | 2062243.04 | 2760756.94 | 0.00 |
| _SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2025-08-05 14:15:19.038 UTC