[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'EUR' > PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount SELECT *.TMB() AS * ORDER BY DimReseller.FirstOrderYearId DESC > TITLE SalesAmount of reseller sales done in EUR by Reseller's first order year
4 items
DimReseller.FirstOrderYearId | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2013 | 1.6M | 297K | 71K | 1.3M |
2012 | 706K | 59K | 147K | 500K |
2011 | 148K | 0 | 148K | 0 |
_SUM | 2.5M | 356K | 366K | 1.8M |
Generated 2024-09-08 02:11:36.390 UTC