[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 |
|---|---|---|---|---|
| 2023 | 22932483.62 | 11338777.11 | 11593706.51 | 0.00 |
| 2025 | 23032167.74 | 7506543.19 | 7104743.19 | 8420881.36 |
| 2024 | 30447589.57 | 11886836.40 | 14373580.12 | 4187173.05 |
| 2022 | 4038355.18 | 2551026.31 | 1487328.87 | 0.00 |
| _SUM | 80450596.11 | 33283183.01 | 34559358.69 | 12608054.41 |
Generated 2025-10-13 22:33:07.002 UTC