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

3 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Edwards, Connor,16950211.010.000.000.00211.01
Long, Kaitlyn,233964891.610.003578.270.001313.34
Campbell, Wyatt, C,27602782.990.000.00782.990.00

Generated 2025-12-21 17:45:28.288 UTC