[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 |
---|---|---|---|---|
2024 | 734641.30 | 224620.76 | 224303.18 | 285717.36 |
2023 | 2428703.00 | 834333.88 | 823629.21 | 770739.91 |
2022 | 1115664.59 | 597830.79 | 517833.80 | 0.00 |
_SUM | 4279008.89 | 1656785.43 | 1565766.19 | 1056457.27 |
Generated 2024-05-17 19:20:45.905 UTC