[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   SHUFFLE   <  SKIP 41  >   <  TAKE 3  >   

3 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Howard, Alyssa, A,11513863.950.000.000.00863.95
Baker, Sean, T,247782858.490.002181.560.00676.93
Diaz, Richard, A,2668264.470.000.000.0064.47

Generated 2025-12-21 13:16:02.060 UTC