[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 45 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Malhotra, Allen, A,15102 | 97.35 | 0.00 | 0.00 | 0.00 | 97.35 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| He, Alisha, R,18026 | 2988.32 | 0.00 | 0.00 | 2181.56 | 806.76 |
| Gutierrez, Daisy,21541 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Malhotra, Ivan, E,11558 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Griffin, Spencer,13784 | 7138.10 | 0.00 | 3578.27 | 0.00 | 3559.83 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Xie, Edwin, E,28879 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Chander, Sheena, L,16308 | 4551.52 | 0.00 | 2181.56 | 0.00 | 2369.96 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Malhotra, Ebony,11589 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Raymond, P,28755 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Ruiz, Stacy,16823 | 7242.35 | 0.00 | 0.00 | 2443.35 | 4799.00 |
| Wang, Aimee,21011 | 2527.96 | 0.00 | 0.00 | 782.99 | 1744.97 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Sharma, Barbara, D,22421 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rai, Barbara, J,22451 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Tang, Gilbert, D,21533 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Sanchez, Pamela,20879 | 3284.30 | 0.00 | 0.00 | 782.99 | 2501.31 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Romero, Alberto,11586 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
Generated 2025-12-21 20:49:22.104 UTC