[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 | 1480998.78 | 209006.36 | 208142.36 | 1063850.06 |
| 2025 | 908437.05 | 127948.64 | 91505.00 | 688983.41 |
| 2023 | 85099.55 | 19143.45 | 65956.10 | 0.00 |
| _SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2025-07-23 06:50:24.934 UTC