[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
20215.2M2.0M1.7M1.5M
20205.5M2.3M3.1M10.7K
20193.6M1.7M2.0M0
2018115K38.9K77K0
_SUM14.4M6.0M6.8M1.5M

Generated 2022-01-19 15:58:01.475 UTC