[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 875 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gutierrez, Kellie, K,17966 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Jimenez, Renee,14778 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Rai, Kelsey, L,19437 | 3480.38 | 0.00 | 0.00 | 3480.38 | 0.00 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Hernandez, Renee, C,17803 | 2761.02 | 0.00 | 0.00 | 2181.56 | 579.46 |
| Jimenez, Frank,21067 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Vazquez, Lee,14843 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 782.99 | 1723.96 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
| Navarro, Walter, S,17841 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Bryant, Alexandra,12598 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Nath, Leonard, L,12637 | 6845.12 | 0.00 | 0.00 | 2049.10 | 4796.02 |
Generated 2025-12-24 06:25:12.010 UTC