[ROOT]  dt  FactResellerSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount   SELECT *.TMB() AS *   ORDER BY OrderDate.Year()Id DESC  >   

5 items

OrderDate.Year()Id_SUMMountainRoadTouring
20213.1M1.3M893K952K
20205.4M2.3M2.6M543K
20194.6M1.9M2.7M0
20181.3M604K650K0
_SUM14.4M6.0M6.8M1.5M

Generated 2021-09-18 03:36:05.576 UTC