[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SKIP 1750
140 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Black, Shawn, A,19499 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Sara, Cory, A,21105 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Jimenez, Robyn, M,12861 | 4394.06 | 0.00 | 0.00 | 2049.10 | 2344.96 |
| Jenkins, Adam, M,18633 | 2793.50 | 0.00 | 0.00 | 2181.56 | 611.94 |
| Ms., Song, Lolan,19073 | 4760.32 | 0.00 | 0.00 | 2443.35 | 2316.97 |
| Subram, Jermaine,28731 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Subram, Cesar, L,11475 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 33.98 | 14.98 |
| Smith, Jasmine,28891 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Schmidt, Dana, S,25641 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Anderson, Devin, A,22822 | 2475.95 | 0.00 | 0.00 | 2475.95 | 0.00 |
| Rana, Roy, M,22667 | 1170.48 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Russell, Jason, A,27949 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alexander, Riley,22799 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Martin, Carolyn, M,12652 | 182.94 | 0.00 | 0.00 | 0.00 | 182.94 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Li, Darryl, T,24549 | 2514.93 | 0.00 | 0.00 | 0.00 | 2514.93 |
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Gill, Craig, R,29379 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Fernandez, Roy, S,15444 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Suri, Francisco,22828 | 2451.30 | 0.00 | 0.00 | 2451.30 | 0.00 |
| Martin, Michele, J,27819 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Anderson, Benjamin,20809 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Jenkins, Spencer, S,14862 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Huang, Martha, E,26408 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Zeng, Sandra,25608 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Sharma, Willie, W,22427 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Shan, Jon,24151 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Jimenez, Joe,19071 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Ortega, Kendra,25592 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Zhou, Alejandro, A,12304 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Nath, Nichole, K,12392 | 75.47 | 0.00 | 0.00 | 75.47 | 0.00 |
| Sai, Dominique,28908 | 33.43 | 0.00 | 0.00 | 33.43 | 0.00 |
| Gonzales, Emma, P,15681 | 105.56 | 0.00 | 0.00 | 33.98 | 71.58 |
| He, Claudia, F,24093 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Lal, Tasha, A,28408 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Ma, Damien,15612 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| 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 |
| Raman, Cynthia, P,27786 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| 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 |
| Gill, Krista,12664 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 39.98 | 36.96 |
| 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 |
| 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 |
| Vance, Erick,28742 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| 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 |
| 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 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Brooks, Christina, W,22496 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Martin, Victor, L,26885 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lopez, Edward, L,26931 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| 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 |
| Carlson, Desiree, V,14864 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| She, Terry, R,25454 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.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 |
| 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 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Torres, Julio,22460 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| 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 |
| 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 |
| 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 |
| Rai, Kelvin, M,26833 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Pal, Karl, S,19187 | 147.28 | 0.00 | 0.00 | 0.00 | 147.28 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| 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 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| 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 |
| Martinez, Carla,24852 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Carlson, Darren, D,29478 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Shan, Christine, R,26895 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Sanchez, Ruben, S,13688 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Kumar, Peter,26915 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Malhotra, Frederick,17951 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Yuan, Clarence, D,24047 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Vazquez, Melinda, C,22553 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Zhao, Amy, C,26416 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| _SUM | 3388349.72 | 143986.63 | 556578.31 | 928189.07 | 1759595.71 |
Generated 2025-11-03 22:24:28.853 UTC