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

3 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Smith, Zachary, W,2378358.980.000.000.0058.98
Bryant, Dakota, L,176132401.950.000.000.002401.95
Wright, Kyle,2371626.970.000.000.0026.97

Generated 2025-12-22 00:08:42.503 UTC