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