[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 986 > < TAKE 3 >
3 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Vazquez, Marie,21899 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
Flores, Alexia, D,14896 | 1588.57 | 0.00 | 699.10 | 0.00 | 889.47 |
Generated 2024-11-10 23:59:30.780 UTC