[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1750 > < TAKE 250 >
140 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Roberts, Dalton,26387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xie, Brad, D,19302 | 1577.39 | 0.00 | 0.00 | 1000.44 | 576.95 |
| Holt, Katie,27946 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Howard, Grace, J,20864 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Carlson, Tyrone, S,22662 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Kendra,18044 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Patel, Dominic,29366 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Ebony, M,28428 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ramos, Linda,23598 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Nara, Kara, E,24566 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Victor, L,26885 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Nara, Louis, J,26901 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Lopez, Edward, L,26931 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wu, Heather, M,19261 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Howard, Carlos,27891 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Deng, Jerry,22813 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Prasad, Regina, A,24192 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Romero, Robyn, C,27802 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Raman, Lydia,26868 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 29.48 | 4.99 |
| Arun, Donald, B,16933 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Raje, Jerry, E,21848 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Raji, Barbara,24019 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Sun, Alejandro, B,23923 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| Jenkins, Blake,28907 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Shen, Casey, D,12503 | 84.46 | 0.00 | 0.00 | 25.48 | 58.98 |
| Rai, Kelvin, M,26833 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Raman, Douglas,24545 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Bell, Haley, A,29437 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 33.98 | 80.57 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Richardson, Julia, N,27331 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Suri, Regina,27800 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Xie, Tommy, J,29425 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Pal, Cedric,23235 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Zhou, Cara,11350 | 38.47 | 0.00 | 0.00 | 38.47 | 0.00 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gao, Sandra,12594 | 37.98 | 0.00 | 0.00 | 0.00 | 37.98 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 25.48 | 0.00 |
| Patel, Heidi, R,23225 | 1184.46 | 0.00 | 0.00 | 1184.46 | 0.00 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 47.97 | 0.00 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 1188.46 | 0.00 |
| Garcia, Francisco,25701 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Butler, Natalie,26401 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Fernandez, Dominic,23630 | 2481.82 | 0.00 | 0.00 | 2481.82 | 0.00 |
| Schmidt, Meredith,25499 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 130.56 | 195.27 |
| Ruiz, Kendra,25598 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Cox, Cole, M,25315 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Cai, Rosa,22618 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Bhat, Drew,14820 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Chow, Jamie,27815 | 110.46 | 0.00 | 0.00 | 110.46 | 0.00 |
| Howard, Angel, A,23223 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Blanco, Joe,25675 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Kapoor, Sergio, E,19392 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Fernandez, Stanley, R,24064 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 123.99 | 0.00 |
| She, Warren,21824 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Bailey, Garrett,19055 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Sai, Marco,24840 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Tang, Russell,18632 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Gomez, Kristi,26911 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Suri, Brenda, D,22643 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 28.99 | 49.99 |
| Rana, Andre,27904 | 156.76 | 0.00 | 0.00 | 156.76 | 0.00 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Rodriguez, Jay, M,28411 | 134.95 | 0.00 | 0.00 | 134.95 | 0.00 |
| Hernandez, Mason, C,27782 | 47.97 | 0.00 | 0.00 | 47.97 | 0.00 |
| Sun, Omar, D,25783 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Raman, Ebony,19348 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Vance, Joe, L,28877 | 12.98 | 0.00 | 0.00 | 12.98 | 0.00 |
| Hu, Sandra, N,27817 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Suarez, Sheila,28884 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Barnes, Vanessa,13810 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Sai, Tabitha,25741 | 567.76 | 0.00 | 0.00 | 567.76 | 0.00 |
| King, Wyatt,22671 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Torres, Victor,18030 | 64.97 | 0.00 | 0.00 | 64.97 | 0.00 |
| Dominguez, Teresa, C,20963 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Patterson, Melanie,28898 | 69.46 | 0.00 | 0.00 | 69.46 | 0.00 |
| Sanz, Joanna, L,25732 | 638.95 | 0.00 | 0.00 | 638.95 | 0.00 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 123.47 | 0.00 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Xu, Gilbert,22554 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Rodriguez, Dominic, E,28525 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Long, Kelly, G,25545 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Brooks, Haley, S,17193 | 134.96 | 0.00 | 0.00 | 74.98 | 59.98 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 87.97 | 0.00 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Xu, Marshall, K,25747 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Russell, Christian, S,22826 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 42.28 | 27.96 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Malhotra, Michele, A,26896 | 12.98 | 0.00 | 0.00 | 12.98 | 0.00 |
| Sanchez, Christina, S,14546 | 28.99 | 0.00 | 0.00 | 28.99 | 0.00 |
| Deng, Corey,28921 | 184.48 | 0.00 | 0.00 | 184.48 | 0.00 |
| Beck, Bradley, L,22388 | 68.49 | 0.00 | 0.00 | 68.49 | 0.00 |
| Malhotra, Roy, P,23220 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Ramos, Janet, B,20596 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Mr., Shridhar, Shish,25761 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| _SUM | 3388349.72 | 143986.63 | 556578.31 | 928189.07 | 1759595.71 |
Generated 2025-11-03 08:34:05.419 UTC