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

3 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hall, Wyatt,2382713.980.000.000.0013.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Bennett, Jennifer, G,13708123.940.000.000.00123.94

Generated 2025-12-21 02:43:18.673 UTC