[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 |
|---|---|---|---|---|
| 2024 | 21480801.07 | 8625233.22 | 10961606.72 | 1893961.13 |
| 2022 | 2555651.18 | 1780334.48 | 775316.70 | 0.00 |
| 2023 | 17148154.26 | 8886293.43 | 8261860.83 | 0.00 |
| 2025 | 16540184.77 | 5769146.16 | 5780103.09 | 4990935.52 |
| _SUM | 57724791.28 | 25061007.29 | 25778887.34 | 6884896.65 |
Generated 2025-11-15 10:35:44.703 UTC