[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 281 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yang, Ryan,28723 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Miller, Emily, R,11333 | 8163.31 | 3399.99 | 0.00 | 2344.26 | 2419.06 |
| Kumar, Clayton,13841 | 6624.60 | 3578.27 | 0.00 | 751.34 | 2294.99 |
| Walker, Sydney, A,19047 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| She, Drew,25453 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Patel, Emmanuel,14427 | 8451.26 | 0.00 | 3578.27 | 0.00 | 4872.99 |
| Malhotra, Jay,14159 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Phillips, Nathan,25537 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
Generated 2025-11-06 09:48:20.771 UTC