[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 959 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Lopez, Marco,11429 | 10468.38 | 0.00 | 0.00 | 4401.40 | 6066.98 |
| Gutierrez, Janet, M,18231 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Liu, Marshall,25737 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 2181.56 | 0.00 | 2577.91 |
| Chandra, Tammy,12474 | 5928.25 | 0.00 | 3578.27 | 0.00 | 2349.98 |
Generated 2024-09-21 19:29:11.449 UTC