[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zheng, Leah, R,12627 | 110.94 | 0.00 | 0.00 | 0.00 | 110.94 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Rubio, Jerome, L,14792 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 0.00 | 2049.10 | 4754.82 |
| Jimenez, Frank,21067 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Jai, Casey, C,22560 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Mrs., West, Alyssa,23219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Taylor, Grace,24073 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| Perez, Michele, K,13772 | 5928.25 | 0.00 | 3578.27 | 0.00 | 2349.98 |
| Andersen, Nichole,12653 | 6860.09 | 0.00 | 0.00 | 2049.10 | 4810.99 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 0.00 | 4714.05 |
| Baker, Caleb, F,23968 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wilson, Jacob, H,15078 | 6675.60 | 0.00 | 3578.27 | 0.00 | 3097.33 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Arun, Donald, B,16933 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Nara, Casey, E,17812 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Raji, Tracy,22439 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Lopez, Dominique, S,15077 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Yang, Bianca, E,28732 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Fernandez, Kari,13788 | 200.81 | 0.00 | 0.00 | 0.00 | 200.81 |
| Chandra, Marie, A,25775 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Torres, Orlando, H,27896 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hu, Vincent, F,28372 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Sai, Gerald, L,27894 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Black, Willie,18172 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Chander, Mario,12590 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Guo, Alvin, R,28878 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Griffin, Jeremiah,18158 | 6869.61 | 0.00 | 0.00 | 2181.56 | 4688.05 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Perez, Clifford, R,15690 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Natalie, M,20900 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Deng, Dale,28399 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| She, Drew,25453 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Martinez, Richard, J,14986 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 2071.42 | 2868.97 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Mehta, Whitney, T,24197 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Madan, Edgar, M,27131 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Schmidt, Theresa,21854 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 0.00 | 114.55 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| Phillips, Nathan,25537 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 0.00 | 107.97 |
| Andersen, Clayton,15631 | 5122.39 | 0.00 | 3578.27 | 0.00 | 1544.12 |
| Navarro, Beth,13534 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Torres, Marvin, J,27885 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Hu, Louis,16187 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Jimenez, Michele,13547 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Ramos, Felicia,11557 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Richardson, Megan, M,15662 | 5253.07 | 0.00 | 3578.27 | 0.00 | 1674.80 |
| Gray, Natalie, L,14165 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Ramos, Julio,12551 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Patel, Heidi, R,23225 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Gutierrez, Jimmy, M,11494 | 6973.81 | 0.00 | 3399.99 | 2329.98 | 1243.84 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Kapoor, Johnathan,20576 | 3147.96 | 0.00 | 782.99 | 0.00 | 2364.97 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 0.00 | 3151.30 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Shen, Julie,22505 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| She, Raul,19497 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Zhang, Franklin, L,12597 | 53.21 | 0.00 | 0.00 | 0.00 | 53.21 |
| Goel, Kara,16465 | 3271.79 | 0.00 | 0.00 | 2443.35 | 828.44 |
| Gill, Craig, R,29379 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Sara, Evelyn,16045 | 3802.37 | 0.00 | 2181.56 | 0.00 | 1620.81 |
| Fernandez, Roy, S,15444 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Srini, Whitney,11560 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Malhotra, Raymond, T,13251 | 6844.42 | 0.00 | 0.00 | 2049.10 | 4795.32 |
| Wang, Barbara, M,15652 | 5160.08 | 0.00 | 3578.27 | 0.00 | 1581.81 |
| King, Jack, H,17702 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 2181.56 | 0.00 | 1570.82 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Beck, Carl, M,16311 | 2988.32 | 0.00 | 2181.56 | 806.76 | 0.00 |
| Patel, Bruce,27165 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Carlson, Jerome, J,21817 | 791.47 | 0.00 | 0.00 | 0.00 | 791.47 |
Generated 2025-12-22 00:39:07.210 UTC