[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 |
|---|---|---|---|---|
| 2023 | 42438.45 | 0.00 | 42438.45 | 0.00 |
| 2025 | 2153022.16 | 315952.13 | 219445.60 | 1617624.43 |
| 2024 | 279074.77 | 40146.32 | 103719.41 | 135209.04 |
| _SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2026-01-06 23:29:29.224 UTC