[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
20211.8M765K532K534K
20205.6M2.2M2.4M961K
20195.0M2.1M2.9M0
20182.0M904K1.1M0
_SUM14.4M6.0M6.8M1.5M

Generated 2021-06-19 17:32:54.296 UTC