[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Malhotra, Evelyn,12853 | 4354.08 | 0.00 | 0.00 | 2049.10 | 2304.98 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
| Malhotra, Frederick,17951 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Gutierrez, Jimmy, M,11494 | 6973.81 | 0.00 | 3399.99 | 0.00 | 3573.82 |
| Yang, Bianca, E,28732 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Schmidt, Mayra,17884 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Evans, Hunter,25493 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Subram, Cesar, L,11475 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Rodriguez, Noah, J,22325 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2025-12-24 05:49:41.925 UTC