[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Morris, Savannah,13585 | 8368.29 | 3578.27 | 0.00 | 0.00 | 4790.02 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Chavez, Colleen, H,20049 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Xie, Mario,13687 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Watson, Jan, K,13680 | 5948.24 | 3578.27 | 0.00 | 0.00 | 2369.97 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 3578.27 | 0.00 | 0.00 | 3593.31 |
| Zhou, Claudia, M,11247 | 7131.51 | 3374.99 | 0.00 | 2340.23 | 1416.29 |
| Bailey, Ariana, J,13691 | 5976.74 | 3578.27 | 0.00 | 0.00 | 2398.47 |
| Shen, Jaime,13765 | 7152.09 | 3578.27 | 0.00 | 0.00 | 3573.82 |
| Liu, Shannon, D,11250 | 7116.25 | 3399.99 | 0.00 | 2339.97 | 1376.29 |
| Tang, Kurt, G,13847 | 5888.24 | 3578.27 | 0.00 | 0.00 | 2309.97 |
| Nara, Shawn, C,13845 | 5917.24 | 3578.27 | 0.00 | 0.00 | 2338.97 |
| Martin, Mallory, J,13794 | 7212.06 | 0.00 | 3578.27 | 0.00 | 3633.79 |
| Zheng, Lisa, R,13846 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Patel, Emmanuel,14427 | 8451.26 | 0.00 | 3578.27 | 0.00 | 4872.99 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 777.34 | 2309.97 |
| Xu, Willie, J,14157 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Chander, Christine, L,17839 | 34.97 | 0.00 | 0.00 | 0.00 | 34.97 |
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Liu, Eugene,14712 | 6660.59 | 0.00 | 3578.27 | 0.00 | 3082.32 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Shan, Casey, C,17782 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Washington, Kelly, M,28748 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| Moreno, Derrick, C,18625 | 2753.82 | 0.00 | 0.00 | 2181.56 | 572.26 |
| Rodriguez, Marie, L,17960 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Sanchez, Emmanuel, F,21856 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Hill, Nathan,12615 | 5663.23 | 0.00 | 0.00 | 2071.42 | 3591.81 |
| Zeng, Margaret, M,16191 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Vazquez, Michele,16934 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Prasad, Veronica, J,24199 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ramos, Daisy,14552 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Serrano, Frank,23232 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Torres, Devin, A,23752 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Chandra, Regina, M,15057 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Roberts, Gabrielle, E,29432 | 1307.31 | 0.00 | 0.00 | 0.00 | 1307.31 |
| Moyer, Felicia, C,28880 | 637.96 | 0.00 | 0.00 | 0.00 | 637.96 |
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Jimenez, Janet, P,17112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Dominguez, Naomi, B,14720 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Edwards, Edward,14700 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Butler, Eduardo, G,13533 | 137.94 | 0.00 | 0.00 | 0.00 | 137.94 |
| Nath, Lindsay,21841 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Li, Curtis, E,13692 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Romero, Kristine, W,16306 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| McDonald, George,11394 | 8161.97 | 0.00 | 3399.99 | 2342.92 | 2419.06 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Zhao, Edwin,14991 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Vazquez, Meghan, W,15047 | 6669.57 | 0.00 | 3578.27 | 0.00 | 3091.30 |
| Deng, Misty,14861 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Chande, Kelsey, K,14846 | 6744.57 | 0.00 | 3578.27 | 0.00 | 3166.30 |
| Tang, Gregory,24048 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Martin, Ross,16201 | 3058.01 | 0.00 | 2181.56 | 0.00 | 876.45 |
| Rai, Kristin, C,12569 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 2350.96 | 1438.80 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Torres, Katelyn, L,20804 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Vance, Ebony,20724 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Kelly, Richard,17991 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Hughes, Adam,24546 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Andersen, Keith,11612 | 6795.12 | 0.00 | 2049.10 | 0.00 | 4746.02 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Hayes, Marcus, A,15657 | 5251.34 | 0.00 | 3578.27 | 0.00 | 1673.07 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Alonso, Micheal, W,19307 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Hu, Vincent, F,28372 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Gonzales, Jessica, A,15610 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Chander, Mario,12590 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Jai, Grant,24200 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Jones, Brianna,25546 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 4391.41 | 548.98 |
| Zeng, Valerie,17977 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Baker, Seth,21520 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Shen, Julie,22505 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Xu, Omar, A,22596 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Goel, Kara,16465 | 3271.79 | 0.00 | 2443.35 | 0.00 | 828.44 |
| Coleman, Trevor, C,25313 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Jiménez, Derrick, B,17890 | 2753.52 | 0.00 | 0.00 | 2181.56 | 571.96 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Cai, Colleen, J,15088 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 2322.28 | 2393.06 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 889.45 | 777.34 |
| Wu, Dawn, T,11493 | 6958.80 | 0.00 | 3399.99 | 2329.98 | 1228.83 |
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Richardson, Megan, M,15662 | 5253.07 | 0.00 | 3578.27 | 0.00 | 1674.80 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Romero, Sheila,20577 | 3080.27 | 0.00 | 782.99 | 0.00 | 2297.28 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Mehta, Ruth,15702 | 6917.54 | 0.00 | 2181.56 | 0.00 | 4735.98 |
| Fernandez, Chelsea, J,19905 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-11-04 03:35:04.370 UTC