[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  >   TITLE SalesAmount of reseller sales done in CAD by Reseller's ProductLine   

SalesAmount of reseller sales done in CAD by Reseller's ProductLine

5 items

OrderDate.Year()Id_SUMMountainRoadTouring
20221.4M573K419K374K
20215.7M2.2M2.3M1.1M
20205.1M2.1M2.9M0
20192.3M1.1M1.2M0
_SUM14.4M6.0M6.8M1.5M

Generated 2022-05-20 10:00:58.660 UTC