[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 | 71668.30 | 10514.54 | 61153.76 | 0.00 |
2024 | 924433.47 | 141026.21 | 139220.35 | 644186.91 |
2025 | 1478433.61 | 204557.70 | 165229.35 | 1108646.56 |
_SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2025-10-18 11:04:47.008 UTC