[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 | 471783.26 | 263611.33 | 208171.93 | 0.00 |
| 2025 | 2010289.92 | 626024.80 | 617197.76 | 767067.36 |
| 2024 | 1796935.71 | 767149.30 | 740396.50 | 289389.91 |
| _SUM | 4279008.89 | 1656785.43 | 1565766.19 | 1056457.27 |
Generated 2025-11-15 07:23:33.682 UTC