[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount
4 items
DimReseller.FirstOrderYearId | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2013 | 1347773.37 | 130711.30 | 286493.65 | 930568.42 |
2011 | 405212.89 | 0.00 | 405212.89 | 0.00 |
2012 | 2526022.63 | 1526074.13 | 874059.65 | 125888.85 |
_SUM | 4279008.89 | 1656785.43 | 1565766.19 | 1056457.27 |
Generated 2025-03-27 23:36:52.857 UTC