[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 993 > < TAKE 7 >
7 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Raje, Tommy, E,17767 | 4101.76 | 0.00 | 0.00 | 1000.44 | 3101.32 |
Goel, Kate,21783 | 49.97 | 0.00 | 0.00 | 49.97 | 0.00 |
Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
Luo, Bonnie,19337 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
Jai, Michele, E,21225 | 4732.86 | 0.00 | 2181.56 | 0.00 | 2551.30 |
Ma, Alvin,15099 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
Roberts, Katelyn,18348 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
Generated 2024-09-21 02:50:17.430 UTC