[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'EUR' > PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
4 items
| OrderDate.Year()Id | _SUM | Mountain | Road | Touring |
|---|---|---|---|---|
| 2024 | 924433.47 | 141026.21 | 139220.35 | 644186.91 |
| 2023 | 71668.30 | 10514.54 | 61153.76 | 0.00 |
| 2025 | 1478433.61 | 204557.70 | 165229.35 | 1108646.56 |
| _SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2025-10-31 01:17:32.353 UTC