[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 |
|---|---|---|---|---|
| 2025 | 1196530.77 | 353779.92 | 363597.11 | 479153.74 |
| 2024 | 2203929.38 | 845418.87 | 781206.98 | 577303.53 |
| 2023 | 878548.74 | 457586.64 | 420962.10 | 0.00 |
| _SUM | 4279008.89 | 1656785.43 | 1565766.19 | 1056457.27 |
Generated 2025-07-23 14:25:46.645 UTC