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

3 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Long, Chloe,167841735.980.000.000.001735.98
Patterson, Natalie,16123629.970.000.000.00629.97
Srini, Ruben,18078200.940.000.000.00200.94

Generated 2025-12-22 03:13:19.570 UTC