[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhou, Cara,11350 | 38.47 | 0.00 | 0.00 | 38.47 | 0.00 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 7.28 | 98.96 |
| Ye, Omar,21020 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Hernandez, Ruben, C,21036 | 2547.95 | 0.00 | 0.00 | 782.99 | 1764.96 |
| Hernandez, Renee, C,17803 | 2761.02 | 0.00 | 0.00 | 2181.56 | 579.46 |
| Sun, Vincent, F,16585 | 7192.39 | 0.00 | 0.00 | 2443.35 | 4749.04 |
| Prasad, Rebekah, A,15919 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Blanco, Mathew, B,12595 | 40.27 | 0.00 | 0.00 | 31.28 | 8.99 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Lopez, Dominique, S,15077 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Patel, Heidi, R,23225 | 1184.46 | 0.00 | 0.00 | 1184.46 | 0.00 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 39.98 | 43.46 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Yuan, Cedric,15449 | 49.56 | 0.00 | 0.00 | 0.00 | 49.56 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Blanco, Meghan,17961 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Chander, Nichole, H,28451 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Ye, Dawn,25488 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 2443.35 | 0.00 | 799.48 |
| Sai, Veronica,16509 | 3258.79 | 0.00 | 2443.35 | 0.00 | 815.44 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Luo, Cassie,16452 | 3071.01 | 0.00 | 2181.56 | 0.00 | 889.45 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Garcia, Francisco,25701 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Gutierrez, Gina, A,21092 | 2511.26 | 0.00 | 0.00 | 2511.26 | 0.00 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 1149.47 | 0.00 |
| Gill, Jill, J,26870 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Fernandez, Stanley, R,24064 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Xu, Katie, R,14799 | 162.95 | 0.00 | 0.00 | 92.96 | 69.99 |
| Sanz, Krista,27806 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 123.99 | 0.00 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 4.99 | 85.48 |
| Gao, Colleen,15108 | 210.54 | 0.00 | 0.00 | 0.00 | 210.54 |
| Lopez, Edward, L,26931 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Martinez, Molly, S,13603 | 133.94 | 0.00 | 0.00 | 83.97 | 49.97 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Ramos, Felicia,11557 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Chander, Jenny, A,19917 | 3369.41 | 0.00 | 0.00 | 1000.44 | 2368.97 |
| Travers, Micheal,26397 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nelson, Haley,27185 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Sanders, Jessica,17650 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Li, Leah,12871 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Serrano, Walter, G,12299 | 4977.36 | 0.00 | 0.00 | 4428.38 | 548.98 |
| Srini, Francisco, H,12602 | 45.26 | 0.00 | 0.00 | 8.99 | 36.27 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Blanco, Jessie, R,23608 | 2510.94 | 0.00 | 0.00 | 2510.94 | 0.00 |
| Alvarez, Raquel, G,17808 | 159.94 | 0.00 | 0.00 | 64.97 | 94.97 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 8.99 | 36.27 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 2354.98 | 2413.06 |
| Rana, Andre,27904 | 156.76 | 0.00 | 0.00 | 156.76 | 0.00 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 583.97 | 0.00 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 2558.46 | 0.00 |
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Madan, Harold, A,23938 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Raman, Lydia,26868 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nara, Drew, A,26944 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ashe, Tasha, W,24881 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Ward, Mackenzie, D,21130 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Jerry, E,21848 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Wu, Rosa,16461 | 3287.32 | 0.00 | 2443.35 | 0.00 | 843.97 |
| Ye, Eugene, E,11609 | 6872.11 | 0.00 | 2049.10 | 2369.97 | 2453.04 |
| Reed, Jesse, E,22429 | 1777.95 | 0.00 | 0.00 | 0.00 | 1777.95 |
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Zhou, Alejandro, A,12304 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Gonzalez, Allen,25572 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Shen, Derek, T,22586 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 782.99 | 0.00 | 2638.94 |
| Gomez, Joe, E,16574 | 44.97 | 0.00 | 0.00 | 4.99 | 39.98 |
| Munoz, Rodney,12836 | 68.46 | 0.00 | 0.00 | 0.00 | 68.46 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Hayes, Marcus, A,15657 | 5251.34 | 0.00 | 3578.27 | 0.00 | 1673.07 |
| Raje, Damien, S,25784 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Srini, Molly, L,27790 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Raman, Cynthia, P,27786 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Jai, Kate,14706 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Cai, Lacey, L,12733 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Zhou, Glenn, A,12326 | 63.98 | 0.00 | 0.00 | 0.00 | 63.98 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Subram, Gerald,21517 | 3172.97 | 0.00 | 0.00 | 782.99 | 2389.98 |
| Yuan, Bonnie, H,15048 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| He, Alisha, R,18026 | 2988.32 | 0.00 | 0.00 | 2181.56 | 806.76 |
| Navarro, Beth,13534 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Arun, Emmanuel, R,28463 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Raje, Tony,24212 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Liu, Mandy,17888 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Martin, Audrey,13791 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Srini, Whitney,11560 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Ruiz, Kendra,25598 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Rana, Lydia,29395 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ramos, Jamie, L,27852 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 33.98 | 123.98 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 2398.47 | 1249.84 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Martin, Alexander, K,16402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Ruiz, Briana,20906 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Blue, Oscar, L,27008 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
Generated 2025-11-04 04:42:24.338 UTC