[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 | 52952.99 | 10514.54 | 42438.45 | 0.00 |
| 2025 | 1807916.71 | 248836.16 | 211879.84 | 1347200.71 |
| 2024 | 613665.68 | 96747.75 | 111285.17 | 405632.76 |
| _SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2025-12-08 16:08:18.296 UTC