[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Terry, H,26850 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Goel, Johnny, J,22569 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Richardson, Julia, N,27331 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Ye, Dawn,25488 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gill, Craig, R,29379 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Yuan, Shawn, P,27762 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 4.99 | 85.48 |
| Lopez, Edward, L,26931 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Moreno, Gary, E,21544 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Fernandez, Roy, S,15444 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Lopez, Marie,16192 | 101.45 | 0.00 | 0.00 | 29.48 | 71.97 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Kumar, Corey,15354 | 8297.29 | 0.00 | 3578.27 | 0.00 | 4719.02 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Garcia, Ryan, J,15692 | 8392.30 | 0.00 | 3578.27 | 0.00 | 4814.03 |
| Martin, Ross,16201 | 3058.01 | 0.00 | 2181.56 | 0.00 | 876.45 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Zhang, Margaret, G,16058 | 38.25 | 0.00 | 0.00 | 0.00 | 38.25 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Jimenez, Joe,19071 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Martin, Billy, B,26849 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Deng, Ricardo,21111 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 33.98 | 80.57 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
| Baker, Mackenzie,16563 | 62.95 | 0.00 | 0.00 | 13.98 | 48.97 |
| Xu, Laura, D,16287 | 4538.84 | 0.00 | 2181.56 | 0.00 | 2357.28 |
| Deng, Dale,28399 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sharma, Latoya,19260 | 1592.71 | 0.00 | 1000.44 | 0.00 | 592.27 |
| Chande, Priscilla,29358 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 782.99 | 0.00 | 2638.94 |
| Chander, Kelli,26934 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Lopez, Holly,26876 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 2181.56 | 793.46 | 0.00 |
| Sanz, Latasha,29384 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Guo, Wesley,16470 | 3021.04 | 0.00 | 2181.56 | 0.00 | 839.48 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 2443.35 | 0.00 | 799.48 |
| Gutierrez, Alberto, R,15461 | 88.96 | 0.00 | 0.00 | 83.97 | 4.99 |
| Xu, Derek, M,20824 | 2512.96 | 0.00 | 782.99 | 1729.97 | 0.00 |
| Romero, Melinda,12260 | 241.76 | 0.00 | 0.00 | 182.78 | 58.98 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Moreno, Kari, S,15052 | 44.57 | 0.00 | 0.00 | 7.28 | 37.29 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 67.46 | 0.00 |
| Lal, Tasha, A,28408 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Zeng, Brent, S,21110 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Chandra, Roy, R,24583 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Ye, Darryl,17790 | 3039.31 | 0.00 | 0.00 | 2443.35 | 595.96 |
| Chen, Jessie,24069 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Sara, Bruce,22311 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Chander, Lindsey,26949 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Shan, Casey, C,17782 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Mehta, Ronald, F,17649 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Rodriguez, Cindy,26379 | 1783.96 | 0.00 | 0.00 | 0.00 | 1783.96 |
| Rivera, Garrett,22642 | 1198.97 | 0.00 | 0.00 | 1198.97 | 0.00 |
| Prasad, Virginia,17933 | 3103.31 | 0.00 | 0.00 | 2443.35 | 659.96 |
| Sanz, Krista,27806 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Sharma, Wayne, E,19175 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Rana, Kristina,27847 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 782.99 | 1764.96 | 0.00 |
| Gomez, Kristi,26911 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Carlson, Erika,16444 | 3271.82 | 0.00 | 2443.35 | 828.47 | 0.00 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Sai, Veronica,16509 | 3258.79 | 0.00 | 2443.35 | 0.00 | 815.44 |
| Blanco, Jessie, R,23608 | 2510.94 | 0.00 | 0.00 | 2510.94 | 0.00 |
| Becker, Kate,16447 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Rana, Andre,27904 | 156.76 | 0.00 | 0.00 | 156.76 | 0.00 |
| Navarro, Lance, C,20850 | 2556.94 | 0.00 | 0.00 | 2556.94 | 0.00 |
| Garcia, Abigail,14531 | 190.54 | 0.00 | 0.00 | 190.54 | 0.00 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 583.97 | 0.00 |
| Zhang, Colleen, L,16562 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Perez, Dominic, A,23940 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Robinson, Jasmine,26886 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Subram, Bobby, J,29373 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| He, Clarence,16591 | 137.96 | 0.00 | 0.00 | 0.00 | 137.96 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Martinez, Carla,24852 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Townsend, Michelle, P,12864 | 86.24 | 0.00 | 0.00 | 36.27 | 49.97 |
| Suarez, Ross, C,27940 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Gutierrez, Casey,12519 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 607.96 | 0.00 |
| Zeng, Martha, J,17844 | 196.26 | 0.00 | 0.00 | 7.28 | 188.98 |
| Sun, Omar, D,25783 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 7.28 | 24.27 |
| Shan, Willie,17098 | 2768.53 | 0.00 | 0.00 | 2768.53 | 0.00 |
| Saunders, Cynthia,24537 | 2511.32 | 0.00 | 0.00 | 2511.32 | 0.00 |
| Raje, Karl,19362 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Wagner, Deb, R,24030 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Schmidt, Kristina,12318 | 6808.15 | 0.00 | 0.00 | 6808.15 | 0.00 |
| Davis, Ashley,26407 | 126.28 | 0.00 | 0.00 | 126.28 | 0.00 |
| Serrano, Erika,12394 | 5635.91 | 0.00 | 0.00 | 2049.10 | 3586.81 |
| Scott, Kyle, D,11419 | 231.75 | 0.00 | 0.00 | 182.78 | 48.97 |
| Anand, Karla,17185 | 6954.57 | 0.00 | 0.00 | 2181.56 | 4773.01 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Xu, Karen, E,17115 | 3008.02 | 0.00 | 0.00 | 2181.56 | 826.46 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Wang, Christy,19498 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Sanz, Kendra,17753 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| King, Adam, M,16932 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
Generated 2025-11-02 11:23:16.567 UTC