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

2 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Chandra, Allen,2932753.990.000.000.0053.99
Anand, Brendan, L,1984721.980.000.000.0021.98

Generated 2026-01-04 05:20:19.206 UTC