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

3 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Sánchez, Angela, C,176551750.980.000.000.001750.98
Edwards, Hunter,2422067.930.000.000.0067.93
Robinson, Zachary, L,137092332.280.000.000.002332.28

Generated 2025-12-21 16:11:29.087 UTC