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

4 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Ramos, Larry,1844621.490.000.000.0021.49
Kumar, Chad,110958158.010.003374.992363.962419.06
Romero, Wendy, H,113724965.810.003374.990.001590.82
Smith, Thomas,1706853.990.000.000.0053.99

Generated 2025-12-22 06:42:43.040 UTC