[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Sharma, Barbara, D,22421 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Russell, Emma, I,21512 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chen, Jeffery, C,16827 | 7205.36 | 0.00 | 0.00 | 2443.35 | 4762.01 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Rana, Tabitha, Y,16601 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Pal, Kristin, E,26956 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Li, Curtis, E,13692 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Sanz, Philip, J,17807 | 81.24 | 0.00 | 0.00 | 0.00 | 81.24 |
| Townsend, Trinity, L,12367 | 160.45 | 0.00 | 0.00 | 0.00 | 160.45 |
| Wu, Rosa,16461 | 3287.32 | 0.00 | 0.00 | 2443.35 | 843.97 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Dominguez, Naomi, B,14720 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Baker, Katherine,19334 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Washington, Kelly, M,28748 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Yuan, Bridget,26211 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 0.00 | 2533.97 | 0.00 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Kristine,16446 | 3093.03 | 0.00 | 0.00 | 2181.56 | 911.47 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Li, Suzanne,21508 | 3152.95 | 0.00 | 0.00 | 782.99 | 2369.96 |
| Ross, Ryan,16428 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Suarez, Michele, C,12526 | 5229.38 | 0.00 | 0.00 | 2049.10 | 3180.28 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Fernandez, Kari,13788 | 200.81 | 0.00 | 0.00 | 0.00 | 200.81 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Guo, Stacey,24207 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 2071.42 | 3553.83 |
| Lin, Cara,29411 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
| Mitchell, Jose, F,24568 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Wang, Dawn, L,27152 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Diaz, Erik, S,11565 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Powell, Gavin, M,28530 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Brown, Nicole,11334 | 8154.02 | 0.00 | 3399.99 | 2334.97 | 2419.06 |
| Romero, Robyn, C,27802 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Coleman, Austin, V,14865 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Sharma, Grant, R,23966 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mehta, George, L,20566 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Shan, Kathryn, K,28916 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Moreno, Lee,25632 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Ms., Smith, Mary, J.,28437 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Henderson, Julian, J,15691 | 8341.29 | 0.00 | 3578.27 | 0.00 | 4763.02 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Serrano, Jimmy, L,17632 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Shawn,19328 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Serrano, Jonathon, F,23954 | 1178.45 | 0.00 | 0.00 | 0.00 | 1178.45 |
| Lopez, Harold,26913 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 0.00 | 107.97 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Torres, Orlando, H,27896 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Cai, Lacey, L,12733 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Gonzales, Emma, P,15681 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Ms., Sheperdigian, Janet,24541 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Henderson, Faith,14545 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gomez, Melody,25805 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Prasad, Cindy, C,26914 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Serrano, Walter, G,12299 | 4977.36 | 0.00 | 0.00 | 2071.42 | 2905.94 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 0.00 | 152.94 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Blanco, Max,26360 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Coleman, Trevor, C,25313 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Kelly, Olivia, L,12391 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Rai, Cedric,22838 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 0.00 | 4715.34 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2049.10 | 3120.26 |
| Sandoval, Giraldo, Hierro,22634 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Serrano, Kari,26905 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Xie, Carl, R,18136 | 6904.60 | 0.00 | 0.00 | 2181.56 | 4723.04 |
| Martinez, Dalton, M,28413 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Ashe, Melvin,26817 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ramos, Tabitha,20147 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Reed, Cole,12603 | 117.45 | 0.00 | 0.00 | 0.00 | 117.45 |
| Raman, Rebekah, E,22454 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Samant, Mandar,12873 | 5676.24 | 0.00 | 0.00 | 2071.42 | 3604.82 |
| Phillips, Gabriel, R,29443 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Suri, Martin,16589 | 7343.69 | 0.00 | 0.00 | 2443.35 | 4900.34 |
| Chen, Wesley, J,29427 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Gutierrez, Craig,19049 | 4838.30 | 0.00 | 0.00 | 2443.35 | 2394.95 |
| Hu, Sandra, N,27817 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Ruiz, Juan,28746 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Navarro, Randall, A,18620 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Gao, Sandra,12594 | 37.98 | 0.00 | 0.00 | 0.00 | 37.98 |
| Sai, Roy, J,16038 | 84.25 | 0.00 | 0.00 | 0.00 | 84.25 |
Generated 2026-01-04 08:56:46.082 UTC