[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 250 SHUFFLE SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Xie, Brad, D,19302 | 1577.39 | 0.00 | 0.00 | 1000.44 | 576.95 |
| Lal, Wayne, C,16829 | 7185.37 | 0.00 | 0.00 | 2443.35 | 4742.02 |
| Gonzales, Isabella, R,14815 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rana, Carolyn,21829 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| She, Deborah,25576 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Romero, Jerome,11337 | 8162.00 | 0.00 | 3374.99 | 2388.96 | 2398.05 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Jenkins, Devin,22383 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhou, Glenn, A,12326 | 63.98 | 0.00 | 0.00 | 0.00 | 63.98 |
| Wu, Rafael,12745 | 5199.72 | 0.00 | 0.00 | 2071.42 | 3128.30 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 0.00 | 31.55 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Lopez, Courtney,20839 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Perez, Regina, S,19031 | 7226.38 | 0.00 | 0.00 | 2443.35 | 4783.03 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Nara, Omar, J,13535 | 59.20 | 0.00 | 0.00 | 0.00 | 59.20 |
| Moreno, Francis, A,26962 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Chavez, Colleen, H,20049 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Perez, Dominic, A,23940 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Chapman, Bob, W,21134 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hill, Nathan,12615 | 5663.23 | 0.00 | 0.00 | 2071.42 | 3591.81 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Rana, Tabitha, Y,16601 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Navarro, Micheal,23625 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Romero, Armando, A,12596 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Brown, Samuel, M,26999 | 57.98 | 0.00 | 0.00 | 0.00 | 57.98 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Gonzales, Katherine, R,13408 | 6792.12 | 0.00 | 0.00 | 2049.10 | 4743.02 |
| Black, Shawn, A,19499 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Luo, Alisha,24534 | 2533.93 | 0.00 | 0.00 | 0.00 | 2533.93 |
| Zeng, Martha, J,17844 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Tang, Kenneth,28477 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Yuan, Alison, K,24574 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Sharma, Nichole, M,14692 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Luo, Dale, M,22613 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Madan, Cindy, R,12259 | 86.75 | 0.00 | 0.00 | 0.00 | 86.75 |
| Li, Jorge, V,20133 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Blanco, Jaime,22528 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Jiménez, Javier, M,22687 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Guo, Brittney, B,22456 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Wu, Heather, M,19261 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Sanchez, Christina, S,14546 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Ye, Rosa, C,19940 | 3440.43 | 0.00 | 0.00 | 1000.44 | 2439.99 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Mitchell, Fernando,17981 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Suri, Henry,21683 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Nath, Nichole, K,12392 | 75.47 | 0.00 | 0.00 | 25.48 | 49.99 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Rana, Cynthia, L,28397 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Perez, Clifford, R,15690 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Deanna, D,17720 | 2790.53 | 0.00 | 0.00 | 2181.56 | 608.97 |
| Moreno, Paula, W,13554 | 5641.25 | 0.00 | 0.00 | 2071.42 | 3569.83 |
| Ruiz, Jill, P,14423 | 141.91 | 0.00 | 0.00 | 0.00 | 141.91 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Martin, Sheila,15635 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wu, Kelli, T,15621 | 5977.74 | 0.00 | 3578.27 | 0.00 | 2399.47 |
| Nicholls, Jay, K,17813 | 3020.30 | 0.00 | 0.00 | 2443.35 | 576.95 |
| Simmons, Wyatt, V,22604 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Alvarez, Deanna, K,24720 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Yang, Ryan,28723 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Luo, Chad, R,21040 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Lal, Jerry, L,27822 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Hernandez, Kristi, L,22635 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Reed, Taylor,23983 | 1195.47 | 0.00 | 0.00 | 0.00 | 1195.47 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Dominguez, Jésus,17087 | 75.21 | 0.00 | 0.00 | 0.00 | 75.21 |
| Russell, Jason, A,27949 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Sara, Evelyn,16045 | 3802.37 | 0.00 | 2181.56 | 0.00 | 1620.81 |
| Alvarez, Ebony, M,28428 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Raman, Bruce,20886 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Goel, Katrina,21682 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Kim, Carmen,25502 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ramos, Orlando,24154 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Moreno, Lee,25632 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Gomez, Jay,26232 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Kelly, Brianna, C,16945 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Torres, Nelson, F,25804 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
| Martinez, George, L,20570 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
Generated 2025-12-24 07:17:29.601 UTC