[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 | 739389.17 | 140882.21 | 115440.87 | 483066.09 |
| 2023 | 52952.99 | 10514.54 | 42438.45 | 0.00 |
| 2025 | 1682193.22 | 204701.70 | 207724.14 | 1269767.38 |
| _SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2025-11-11 02:36:10.240 UTC