[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Sai, Roy, J,16038 | 84.25 | 0.00 | 0.00 | 0.00 | 84.25 |
| Shan, Aaron,20730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Luo, Chad, R,21040 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 0.00 | 2975.02 | 0.00 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Faith,14545 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Malhotra, Evelyn,12853 | 4354.08 | 0.00 | 0.00 | 2049.10 | 2304.98 |
| Kapoor, Jermaine, A,29368 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ms., Sims, Anne, R.,26869 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Lopez, Martin, E,21864 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Shen, Jaime,13765 | 7152.09 | 0.00 | 3578.27 | 0.00 | 3573.82 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 0.00 | 2533.97 | 0.00 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Diaz, Austin, M,12550 | 86.75 | 0.00 | 0.00 | 0.00 | 86.75 |
| Chander, Warren, A,17965 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Gutierrez, Lori,24065 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Tang, Kenneth,28477 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Luo, Arturo,22461 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Diaz, Deanna, D,17720 | 2790.53 | 0.00 | 0.00 | 2181.56 | 608.97 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Romero, Nelson,25728 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Gao, Colleen,15108 | 210.54 | 0.00 | 0.00 | 0.00 | 210.54 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Torres, Nelson, F,25804 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Carl,12743 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| James, Jade, M,26400 | 132.98 | 0.00 | 0.00 | 0.00 | 132.98 |
| Perez, Bruce, R,16935 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Mr., Sazanovich, Vadim,14847 | 6725.57 | 0.00 | 3578.27 | 0.00 | 3147.30 |
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Smith, Jasmine,28891 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Raji, Tara,12385 | 5118.75 | 0.00 | 0.00 | 2071.42 | 3047.33 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Walker, Sydney, A,19047 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Raman, Bryant, S,19048 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Campbell, Andrea,25689 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Perry, Jose, M,12729 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Chapman, Bob, W,21134 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Rana, Geoffrey,28745 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| She, Donna, D,19346 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Rubio, Jill,13838 | 140.55 | 0.00 | 0.00 | 0.00 | 140.55 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
Generated 2025-12-23 12:02:21.692 UTC