[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Goel, Latoya, C,11239 | 7511.55 | 3374.99 | 0.00 | 2353.95 | 1782.61 |
| Navarro, Armando,19942 | 3034.07 | 699.10 | 0.00 | 0.00 | 2334.97 |
| Srini, Virginia,20048 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Xie, Mario,13687 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Coleman, Alexis, M,11244 | 7175.75 | 0.00 | 3399.99 | 2354.99 | 1420.77 |
| Watson, Jan, K,13680 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Hernandez, Anne, B,11240 | 7586.23 | 0.00 | 3399.99 | 2369.96 | 1816.28 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Ruiz, Theodore,20052 | 3214.03 | 0.00 | 699.10 | 0.00 | 2514.93 |
| Wright, Logan, M,13783 | 5955.23 | 0.00 | 3578.27 | 0.00 | 2376.96 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Xu, Willie, J,14157 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Rubio, Gary, M,20150 | 3264.02 | 0.00 | 699.10 | 0.00 | 2564.92 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| Ramos, Anne, R,11351 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Vazquez, Lee,14843 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 0.00 | 4714.05 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Raji, Franklin,11400 | 6967.78 | 0.00 | 3374.99 | 2318.96 | 1273.83 |
| Tang, Casey,15046 | 5943.25 | 0.00 | 3578.27 | 0.00 | 2364.98 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Yuan, Bonnie, H,15048 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Kapoor, Carolyn, M,16459 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Jenkins, Caleb,14184 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Ramos, Pedro, P,29416 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Raji, Mario,28695 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Shan, Casey, C,17782 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Subram, Ebony, K,26216 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Rodriguez, Cindy,26379 | 1783.96 | 0.00 | 0.00 | 0.00 | 1783.96 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ruiz, Juan,28746 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Cai, Colleen, J,15088 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| Wu, Dawn, T,11493 | 6958.80 | 0.00 | 3399.99 | 0.00 | 3558.81 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
| Hernandez, Jonathon, F,15699 | 6969.57 | 0.00 | 2181.56 | 0.00 | 4788.01 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 0.00 | 4757.02 |
| Xu, Eugene, A,14208 | 117.43 | 0.00 | 0.00 | 58.47 | 58.96 |
| Moreno, Francis, A,26962 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Dominguez, Jésus,17087 | 75.21 | 0.00 | 0.00 | 0.00 | 75.21 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Xu, Laura, D,16287 | 4538.84 | 0.00 | 0.00 | 2181.56 | 2357.28 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Lal, Omar, S,19193 | 1609.40 | 0.00 | 0.00 | 1000.44 | 608.96 |
| Alonso, Eddie, L,16420 | 2959.00 | 0.00 | 0.00 | 2181.56 | 777.44 |
| Ruiz, Erika, J,19192 | 1682.41 | 0.00 | 0.00 | 1000.44 | 681.97 |
| Sanz, Ebony, I,20711 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Ruiz, Ricky,20718 | 3283.43 | 0.00 | 0.00 | 782.99 | 2500.44 |
| Sun, Willie,19278 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 0.00 | 2443.35 | 799.48 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Rodriguez, Jessica,21669 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 0.00 | 2071.42 | 4757.96 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 2071.42 | 3553.83 |
| Sun, Vincent, F,16585 | 7192.39 | 0.00 | 0.00 | 2443.35 | 4749.04 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Roberts, Gabriella, J,16553 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Jones, Andrew, C,16594 | 7231.37 | 0.00 | 0.00 | 2443.35 | 4788.02 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 2049.10 | 3671.27 |
| Rogers, Cody, F,26892 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Shan, Willie,17098 | 2768.53 | 0.00 | 0.00 | 2768.53 | 0.00 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Anand, Karla,17185 | 6954.57 | 0.00 | 0.00 | 2181.56 | 4773.01 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Cox, Zoe, A,17755 | 2768.53 | 0.00 | 0.00 | 2181.56 | 586.97 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Hill, Nathan,12615 | 5663.23 | 0.00 | 0.00 | 2071.42 | 3591.81 |
| Ye, Darryl,17790 | 3039.31 | 0.00 | 0.00 | 2443.35 | 595.96 |
| Rubio, Micheal, K,12622 | 5135.41 | 0.00 | 0.00 | 2049.10 | 3086.31 |
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Sharma, Alicia, L,19440 | 3492.76 | 0.00 | 0.00 | 1000.44 | 2492.32 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 2071.42 | 4716.34 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Jiménez, Arthur, K,20982 | 2546.96 | 0.00 | 0.00 | 2546.96 | 0.00 |
Generated 2025-12-23 12:12:24.227 UTC