[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 |
---|---|---|---|---|
2022 | 107583.18 | 29822.86 | 77760.32 | 0.00 |
2023 | 1972777.86 | 256001.53 | 271340.59 | 1445435.74 |
2024 | 394174.34 | 70274.06 | 16502.55 | 307397.73 |
_SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2024-04-30 07:42:41.016 UTC