[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 965 > < TAKE 6 >
6 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Subram, Francisco, A,21897 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 2071.42 | 0.00 | 4757.96 |
Becker, Kate,16447 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
Sanders, Alexandra,25911 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
Ortega, Dwayne, C,24615 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
Jones, Anthony, L,13461 | 4476.55 | 0.00 | 2181.56 | 0.00 | 2294.99 |
Generated 2024-09-21 16:58:08.903 UTC