[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'EUR' > PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount
4 items
DimReseller.FirstOrderYearId | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2013 | 1620907.97 | 296883.12 | 71219.22 | 1252805.63 |
2011 | 147554.84 | 0.00 | 147554.84 | 0.00 |
2012 | 706072.57 | 59215.33 | 146829.40 | 500027.84 |
_SUM | 2474535.38 | 356098.45 | 365603.46 | 1752833.47 |
Generated 2025-03-23 21:40:59.041 UTC