[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 | 80686.69 | 0.00 | 80686.69 | 0.00 |
| 2024 | 1478290.06 | 797257.22 | 649931.40 | 31101.44 |
| 2025 | 2720032.14 | 859528.21 | 835148.10 | 1025355.83 |
| _SUM | 4279008.89 | 1656785.43 | 1565766.19 | 1056457.27 |
Generated 2026-01-09 21:09:41.264 UTC