[ROOT] dt FactResellerSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount
3 items
DimReseller.FirstOrderYearId | _SUM | Mountain | Road | Touring |
---|---|---|---|---|
2012 | 227360.14 | 0.00 | 0.00 | 227360.14 |
2013 | 1366974.71 | 172119.73 | 3288.92 | 1191566.06 |
_SUM | 1594334.85 | 172119.73 | 3288.92 | 1418926.20 |
Generated 2025-04-05 00:02:00.688 UTC