[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
5 items
| OrderDate.Year()Id | _SUM | Mountain | Road | Touring |
|---|---|---|---|---|
| 2024 | 24748858.21 | 11486697.19 | 13262161.02 | 0.00 |
| 2026 | 14375512.41 | 4632824.01 | 4441004.15 | 5301684.25 |
| 2025 | 32547672.75 | 11864806.71 | 13376495.88 | 7306370.16 |
| 2023 | 8778552.74 | 5298855.10 | 3479697.64 | 0.00 |
| _SUM | 80450596.11 | 33283183.01 | 34559358.69 | 12608054.41 |
Generated 2026-07-20 15:24:50.804 UTC