[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount
5 items
| DimReseller.FirstOrderYearId | _SUM | Mountain | Road | Touring |
|---|---|---|---|---|
| 2013 | 1724839.91 | 147467.37 | 129048.35 | 1448324.19 |
| 2010 | 2525030.86 | 809149.37 | 1715881.49 | 0.00 |
| 2011 | 7104342.24 | 3388014.87 | 3716327.37 | 0.00 |
| 2012 | 3023712.70 | 1692540.50 | 1284555.57 | 46616.63 |
| _SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2024-05-06 13:17:47.243 UTC