[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
5 items
OrderDate.Year()Id | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2021 | 9845507.22 | 6130997.40 | 3714509.82 | 0.00 |
2022 | 19074283.93 | 8475819.62 | 10598464.31 | 0.00 |
2023 | 21328919.00 | 7967861.82 | 8896440.69 | 4464616.49 |
2024 | 7476081.13 | 2486328.45 | 2569472.52 | 2420280.16 |
_SUM | 57724791.28 | 25061007.29 | 25778887.34 | 6884896.65 |
Generated 2024-06-01 16:18:35.592 UTC