[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
4 items
OrderDate.Year()Id | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2023 | 535116.13 | 263611.33 | 271504.80 | 0.00 |
2024 | 1849696.91 | 806979.27 | 720876.15 | 321841.49 |
2025 | 1894195.85 | 586194.83 | 573385.24 | 734615.78 |
_SUM | 4279008.89 | 1656785.43 | 1565766.19 | 1056457.27 |
Generated 2025-10-13 17:40:33.153 UTC