[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Howard, Timothy,26356 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Subram, Ebony, K,26216 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Sanders, Richard, D,21511 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Martinez, Brandy, L,12865 | 114.23 | 0.00 | 0.00 | 0.00 | 114.23 |
| Alvarez, Kristi,12303 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zhou, Claudia, M,11247 | 7131.51 | 3374.99 | 0.00 | 2340.23 | 1416.29 |
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Sara, Levi, S,12540 | 75.47 | 0.00 | 0.00 | 25.48 | 49.99 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Diaz, Alexandria,19926 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhou, Colin,17962 | 2777.52 | 0.00 | 0.00 | 2181.56 | 595.96 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Andersen, April, C,20973 | 193.98 | 0.00 | 0.00 | 0.00 | 193.98 |
| Rai, Cedric,22838 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Rodriguez, Chelsea,12525 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ms., Li, Amy, J,12592 | 51.96 | 0.00 | 0.00 | 0.00 | 51.96 |
| Garcia, Ryan, J,15692 | 8392.30 | 0.00 | 3578.27 | 0.00 | 4814.03 |
| Sanz, Randall, D,22539 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Shan, Christine, R,26895 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Serrano, Frank,23232 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gomez, Kristine, E,18627 | 3027.32 | 0.00 | 0.00 | 2443.35 | 583.97 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Ramos, Cheryl, A,25682 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ramos, Daisy,14552 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Sun, Heather,28729 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Prasad, Frederick,17810 | 87.94 | 0.00 | 0.00 | 73.96 | 13.98 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Wang, Christy,19498 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Raman, Tammy,12126 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Lal, Cassie,12626 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Rogers, Cody, F,26892 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Liu, Shannon, D,11250 | 7116.25 | 3399.99 | 0.00 | 2339.97 | 1376.29 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Lal, Nichole, P,25753 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Griffin, Ashley,24865 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Kumar, Raul, B,12857 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gutierrez, Lori,24065 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Diaz, Jimmy, D,25474 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Alvarez, Lance, J,16190 | 79.25 | 0.00 | 0.00 | 7.28 | 71.97 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Chander, Lindsey,26949 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Schmidt, Meredith,25499 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Becker, Karla, M,12730 | 64.90 | 0.00 | 0.00 | 0.00 | 64.90 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Shan, Carly,18631 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Black, Willie,18172 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lal, Alvin,24058 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Smith, Tabitha,14787 | 163.45 | 0.00 | 0.00 | 0.00 | 163.45 |
| Alonso, Francis, J,21738 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Perez, Levi,26830 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Weadock, Kelly, J,20909 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| She, Drew,25453 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Chande, Christy,26214 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Andersen, Kathryn,21865 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| She, Omar, K,15448 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Phillips, Nathan,25537 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 6799.45 | 0.00 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 3578.27 | 0.00 | 0.00 | 3593.31 |
| Sanchez, Darren,12502 | 110.46 | 0.00 | 0.00 | 60.47 | 49.99 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Zhao, Eugene,12328 | 6792.11 | 0.00 | 0.00 | 6792.11 | 0.00 |
| Alvarez, Danny,13820 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 |
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| Diaz, Krista,28913 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sanchez, Pamela,20879 | 3284.30 | 0.00 | 0.00 | 782.99 | 2501.31 |
| Zheng, Lisa, R,13846 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Diaz, Erik, S,11565 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Ashe, Francisco, W,12335 | 6912.60 | 0.00 | 0.00 | 6912.60 | 0.00 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Ann, S,12315 | 6803.13 | 0.00 | 0.00 | 6803.13 | 0.00 |
| Malhotra, Jay,14159 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Serrano, Jimmy, L,17632 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Rodriguez, Noah, J,22325 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sanchez, Jesse, M,12623 | 5630.21 | 0.00 | 0.00 | 2049.10 | 3581.11 |
| Suri, Michele,18007 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Pal, Lindsey, A,21071 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Malhotra, Ruth, D,16321 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Perez, Francisco, M,17835 | 69.96 | 0.00 | 0.00 | 0.00 | 69.96 |
| Beck, Clayton,11579 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Navarro, Gary, E,13561 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Brown, Nicole,11334 | 8154.02 | 3399.99 | 0.00 | 2334.97 | 2419.06 |
| Washington, Anna,14817 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 2350.96 | 1438.80 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Zhang, Cedric, D,26966 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Serrano, Michele, R,19483 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Jenkins, Devin,22383 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Cai, Rosa,22618 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Xu, Ronnie,17892 | 2787.51 | 0.00 | 0.00 | 2181.56 | 605.95 |
| Anand, Nichole,12508 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Suarez, Max, A,14809 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Zhou, Martha, M,14804 | 138.96 | 0.00 | 0.00 | 0.00 | 138.96 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| McDonald, George,11394 | 8161.97 | 0.00 | 3399.99 | 2342.92 | 2419.06 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Butler, Eduardo, G,13533 | 137.94 | 0.00 | 0.00 | 0.00 | 137.94 |
Generated 2025-11-04 09:25:28.481 UTC