[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 | 1362282.95 | 209006.36 | 164298.01 | 988978.58 |
| 2025 | 1031955.22 | 127948.64 | 140151.69 | 763854.89 |
| 2023 | 80297.21 | 19143.45 | 61153.76 | 0.00 |
| _SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2025-08-06 01:05:42.686 UTC