[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 |
|---|---|---|---|---|---|
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Lu, Erica,27009 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Ramos, Linda,23598 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Scott, Mackenzie, L,25676 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Lopez, Harold,26913 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Malhotra, Meagan, L,27827 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Chandra, Roy, R,24583 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Vance, Gerald, M,27841 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Lal, Bonnie, A,29445 | 182.78 | 0.00 | 0.00 | 0.00 | 182.78 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Zhang, Jake,22616 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| He, Clarence,16591 | 137.96 | 0.00 | 0.00 | 0.00 | 137.96 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 128.46 | 0.00 |
| Sara, Bruce,22311 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Martinez, Michele, L,19247 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Tang, Jaclyn, K,21060 | 2508.47 | 0.00 | 0.00 | 782.99 | 1725.48 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Ruiz, Nelson,23638 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Diaz, Erik, S,11565 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Richardson, Megan, M,15662 | 5253.07 | 0.00 | 3578.27 | 0.00 | 1674.80 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Lu, Bianca,13252 | 6820.46 | 0.00 | 0.00 | 2071.42 | 4749.04 |
| Cox, Isaiah, E,13584 | 8361.29 | 3578.27 | 0.00 | 0.00 | 4783.02 |
| Romero, Jerome,11337 | 8162.00 | 3374.99 | 0.00 | 2388.96 | 2398.05 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lopez, Michele, C,21509 | 3117.96 | 0.00 | 0.00 | 782.99 | 2334.97 |
| Kelly, Carlos, C,28561 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lopez, Martin, E,21864 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Munoz, Walter,21056 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Weadock, Kelly, J,20909 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Diaz, Deanna, D,17720 | 2790.53 | 0.00 | 0.00 | 2181.56 | 608.97 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Jai, Darrell, T,20951 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Bethany, C,17903 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 0.00 | 2071.42 | 4757.96 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rubio, Jill,13838 | 140.55 | 0.00 | 0.00 | 0.00 | 140.55 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 782.99 | 1764.96 | 0.00 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Goel, Tracy, J,18178 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 2350.96 | 1438.80 |
| Suarez, Max, A,14809 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Zeng, Sandra,25608 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Shan, Karla,19493 | 3515.37 | 0.00 | 0.00 | 3515.37 | 0.00 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Alonso, Briana,21830 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Kovar, Shane, L,12294 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Li, Curtis, E,13692 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Alvarez, Raquel, G,17808 | 159.94 | 0.00 | 0.00 | 64.97 | 94.97 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Rubio, Micheal, K,12622 | 5135.41 | 0.00 | 0.00 | 2049.10 | 3086.31 |
| Subram, Bobby, J,29373 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Ms., Sheperdigian, Janet,24541 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Srini, Francisco, H,12602 | 45.26 | 0.00 | 0.00 | 8.99 | 36.27 |
| Sanchez, Emmanuel, F,21856 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Rivera, Bryan,18160 | 6914.59 | 0.00 | 0.00 | 2181.56 | 4733.03 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 7.28 | 24.27 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Schmidt, Michele, M,21545 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Andersen, Tamara, B,29392 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Lopez, Andre,11434 | 70.46 | 0.00 | 0.00 | 0.00 | 70.46 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Raje, Omar, R,12309 | 102.26 | 0.00 | 0.00 | 0.00 | 102.26 |
| Henderson, Marissa,13816 | 260.83 | 0.00 | 0.00 | 0.00 | 260.83 |
| Mehta, Ivan, S,26390 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 2354.98 | 1228.83 |
| Navarro, Walter, S,17841 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 583.97 | 0.00 |
| Patel, Ebony,25531 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Lee, Jacob,13551 | 5622.92 | 0.00 | 0.00 | 2049.10 | 3573.82 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| She, Carl, A,12317 | 6823.42 | 0.00 | 0.00 | 6823.42 | 0.00 |
| Deng, Jerry,22813 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Rubio, Gary, M,20150 | 3264.02 | 0.00 | 699.10 | 0.00 | 2564.92 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Chandra, Deanna,18141 | 6972.86 | 0.00 | 0.00 | 2181.56 | 4791.30 |
| Zhao, Amy, C,26416 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Goel, Terrence, M,19389 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Tang, Gregory,24048 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Wu, Kelli, T,15621 | 5977.74 | 0.00 | 3578.27 | 0.00 | 2399.47 |
| Chander, Colin, P,12847 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Perez, Holly, E,12376 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Barnes, Vanessa,13810 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 42.97 | 14.98 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2822.76 | 2338.97 |
| Andersen, Katrina,19032 | 6938.58 | 0.00 | 0.00 | 2181.56 | 4757.02 |
| Rai, Alicia, M,28914 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Rana, Carolyn,21829 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raman, Cynthia, P,27786 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ashe, Bruce,12264 | 5662.90 | 0.00 | 0.00 | 3292.94 | 2369.96 |
| Munoz, Kristine,16446 | 3093.03 | 0.00 | 2181.56 | 0.00 | 911.47 |
| Gutierrez, Kathleen,17786 | 89.46 | 0.00 | 0.00 | 39.98 | 49.48 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hall, Destiny, G,25615 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Sanchez, Ruben, S,13688 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Lopez, Cindy, L,27137 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
Generated 2025-11-03 08:11:59.989 UTC