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

4 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Parker, Thomas,2739984.460.000.000.0084.46
Chen, Ernest, W,1785329.980.000.000.0029.98
Diaz, Marvin,2794229.480.000.0029.480.00
Hughes, Alexandra,204409.990.000.000.009.99

Generated 2025-12-24 05:57:48.870 UTC