[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 375 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suri, Summer,26219 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Rogers, Melissa, J,28415 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Shen, Kara, C,23628 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Jimenez, Diana, M,17776 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Rai, Colin, W,24573 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 3295.26 | 2329.99 |
| Washington, Julia, R,20875 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gao, Sandra,12594 | 37.98 | 0.00 | 0.00 | 0.00 | 37.98 |
| Gutierrez, Kellie, K,17966 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Ms., Song, Lolan,19073 | 4760.32 | 0.00 | 0.00 | 2443.35 | 2316.97 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Smith, Jasmine,28891 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Goel, Warren, A,13678 | 5933.25 | 3578.27 | 0.00 | 0.00 | 2354.98 |
| Sai, Roy, J,16038 | 84.25 | 0.00 | 0.00 | 0.00 | 84.25 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Black, Nina, L,17968 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Schmidt, Meredith,25499 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 130.56 | 195.27 |
| Ruiz, Kendra,25598 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Suarez, Victor, N,24071 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Howard, Timothy,26356 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Parker, Wyatt,25325 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Cox, Cole, M,25315 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Cai, Rosa,22618 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ms., Li, Amy, J,12592 | 51.96 | 0.00 | 0.00 | 0.00 | 51.96 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Anderson, Benjamin,20809 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Jenkins, Spencer, S,14862 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Huang, Martha, E,26408 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Xie, Brad, D,19302 | 1577.39 | 0.00 | 0.00 | 1000.44 | 576.95 |
| Suarez, Reginald,18177 | 7043.56 | 0.00 | 0.00 | 2181.56 | 4862.00 |
| She, Warren,21824 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Bailey, Garrett,19055 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Sai, Marco,24840 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Perez, Regina, S,19031 | 7226.38 | 0.00 | 0.00 | 2443.35 | 4783.03 |
| Sharma, Willie, W,22427 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Rivera, Bryan,18160 | 6914.59 | 0.00 | 0.00 | 2181.56 | 4733.03 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Shan, Jon,24151 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Patel, Patricia,20569 | 3114.06 | 0.00 | 699.10 | 0.00 | 2414.96 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Browning, Casey,16449 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Lopez, Ronald,17855 | 189.96 | 0.00 | 0.00 | 0.00 | 189.96 |
| Blanco, Francis, J,25750 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 3331.92 | 2388.45 |
| Ye, Ernest, A,22558 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Prasad, Frederick,17810 | 87.94 | 0.00 | 0.00 | 73.96 | 13.98 |
| Ye, Omar,21020 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Kovar, Shane, L,12294 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| Lopez, Cindy, L,27137 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Arun, Donald, B,16933 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Anand, Nichole,12508 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Long, Miguel,24853 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 28.99 | 49.99 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Chandra, Deanna,18141 | 6972.86 | 0.00 | 0.00 | 2181.56 | 4791.30 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Guo, Wesley,16470 | 3021.04 | 0.00 | 2181.56 | 0.00 | 839.48 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Hernandez, Renee, C,17803 | 2761.02 | 0.00 | 0.00 | 2181.56 | 579.46 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Tang, Casey,15046 | 5943.25 | 0.00 | 3578.27 | 0.00 | 2364.98 |
| Coleman, Gabriel, B,17706 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Rana, Tabitha, Y,16601 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Moreno, Albert,12402 | 5218.40 | 0.00 | 0.00 | 2049.10 | 3169.30 |
| Gao, Claudia,13690 | 7162.08 | 3578.27 | 0.00 | 0.00 | 3583.81 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Suri, Tammy,24031 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 2443.35 | 0.00 | 799.48 |
| Hu, Sandra, N,27817 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Andersen, Dale, B,14992 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Rodriguez, Gerald,12216 | 6955.41 | 0.00 | 2071.42 | 0.00 | 4883.99 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Subram, Levi,15619 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Diaz, Blake, E,18135 | 6921.58 | 0.00 | 0.00 | 2181.56 | 4740.02 |
| Luo, Cassie,16452 | 3071.01 | 0.00 | 2181.56 | 0.00 | 889.45 |
| Suarez, Sheila,28884 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| He, Cedric, W,25298 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mehta, Douglas,19258 | 1574.42 | 0.00 | 1000.44 | 0.00 | 573.98 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Lal, Cassie,12626 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Barnes, Vanessa,13810 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Sai, Stanley,13675 | 215.23 | 0.00 | 0.00 | 0.00 | 215.23 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Gutierrez, Daisy,21541 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Xu, Brendan, L,14937 | 6652.89 | 0.00 | 3578.27 | 0.00 | 3074.62 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Andersen, April, C,20973 | 193.98 | 0.00 | 0.00 | 0.00 | 193.98 |
| Wang, Lisa, J,17205 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
Generated 2025-11-03 08:42:50.671 UTC