[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount
5 items
DimReseller.FirstOrderYearId | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2012 | 24889956.23 | 11287953.63 | 10903013.05 | 2698989.55 |
2010 | 8691012.89 | 3533504.91 | 5157507.98 | 0.00 |
2013 | 11857574.94 | 1123450.19 | 825059.89 | 9909064.86 |
2011 | 35012052.05 | 17338274.28 | 17673777.77 | 0.00 |
_SUM | 80450596.11 | 33283183.01 | 34559358.69 | 12608054.41 |
Generated 2025-04-03 04:57:03.056 UTC