[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 | 6552076.33 | 4190970.76 | 2361105.57 | 0.00 |
| 2023 | 18399378.02 | 8725790.95 | 9673587.07 | 0.00 |
| 2024 | 22181502.96 | 8518654.75 | 10026662.11 | 3636186.10 |
| 2025 | 10591833.97 | 3625590.83 | 3717532.59 | 3248710.55 |
| _SUM | 57724791.28 | 25061007.29 | 25778887.34 | 6884896.65 |
Generated 2025-08-07 13:46:04.514 UTC