[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 |
|---|---|---|---|---|
| 2022 | 7101413.25 | 4493094.51 | 2608318.74 | 0.00 |
| 2023 | 18865500.12 | 8870649.46 | 9994850.66 | 0.00 |
| 2024 | 22324404.64 | 8448252.60 | 9869430.64 | 4006721.40 |
| 2025 | 9433473.27 | 3249010.72 | 3306287.30 | 2878175.25 |
| _SUM | 57724791.28 | 25061007.29 | 25778887.34 | 6884896.65 |
Generated 2025-07-26 13:38:43.773 UTC