[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 | 263422.69 | 112270.93 | 151151.76 | 0.00 |
| 2025 | 2506541.45 | 807132.17 | 794935.78 | 904473.50 |
| 2024 | 1509044.75 | 737382.33 | 619678.65 | 151983.77 |
| _SUM | 4279008.89 | 1656785.43 | 1565766.19 | 1056457.27 |
Generated 2025-12-09 05:55:04.577 UTC