[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
5 items
OrderDate.Year()Id | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2024 | 3102377.29 | 1257833.06 | 892961.04 | 951583.19 |
2023 | 5428443.79 | 2258682.62 | 2626403.54 | 543357.63 |
2022 | 4592407.95 | 1916426.96 | 2675980.99 | 0.00 |
2021 | 1254696.68 | 604229.47 | 650467.21 | 0.00 |
_SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2024-09-08 00:23:16.969 UTC