[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount
5 items
| DimReseller.FirstOrderYearId | _SUM | Mountain | Road | Touring |
|---|---|---|---|---|
| 2013 | 5797078.98 | 376268.67 | 335009.75 | 5085800.56 |
| 2012 | 18406788.19 | 8010123.67 | 8597568.43 | 1799096.09 |
| 2011 | 27354942.08 | 13950259.41 | 13404682.67 | 0.00 |
| 2010 | 6165982.03 | 2724355.54 | 3441626.49 | 0.00 |
| _SUM | 57724791.28 | 25061007.29 | 25778887.34 | 6884896.65 |
Generated 2025-04-05 03:33:19.917 UTC