[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 343 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Gilbert,22554 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 0.00 | 4737.02 |
| Gill, Adrienne,14953 | 202.46 | 0.00 | 0.00 | 0.00 | 202.46 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Stone, Stephanie, S,19060 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| Clark, Devin,25512 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raje, Maurice,14821 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Gutierrez, Roberto,11355 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
Generated 2025-12-24 06:06:40.956 UTC