[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 965 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Moreno, Philip, E,27004 | 1264.84 | 0.00 | 0.00 | 0.00 | 1264.84 |
| Ruiz, Robyn, I,13894 | 4810.29 | 0.00 | 0.00 | 2443.35 | 2366.94 |
| Vazquez, Kathleen, M,12500 | 4475.38 | 0.00 | 0.00 | 2071.42 | 2403.96 |
| Ross, Marissa,27092 | 4519.46 | 0.00 | 0.00 | 2071.42 | 2448.04 |
| Morris, Hailey,15558 | 1362.96 | 0.00 | 0.00 | 1362.96 | 0.00 |
| Cooper, Alexa,14381 | 3330.42 | 0.00 | 0.00 | 1000.44 | 2329.98 |
Generated 2024-11-11 07:03:58.413 UTC