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

3 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Martin, Katherine, J,2027339.980.000.000.0039.98
Hall, Amber,20106131.950.000.000.00131.95
Long, Jordyn,1733847.250.000.000.0047.25

Generated 2025-12-21 07:11:26.499 UTC