[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1122 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Patel, Stefanie,27967 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Pal, Corey,25774 | 2537.32 | 0.00 | 0.00 | 0.00 | 2537.32 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Green, Luke, R,28392 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Xu, Omar, R,19279 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Xie, Tommy, J,29425 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Raje, Damien, S,25784 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Pal, Cedric,23235 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Jai, Kate,14706 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Zhou, Cara,11350 | 38.47 | 0.00 | 0.00 | 38.47 | 0.00 |
| Shan, Nichole, K,19461 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Zhao, Sandra, S,22503 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 0.00 | 106.24 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Deng, Ricardo,21111 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ramos, Linda,23598 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Jimenez, Joe,19071 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Sharma, Cassie, A,26978 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Martin, Billy, B,26849 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Navarro, Hector,23907 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Wang, Lisa, J,17205 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Romero, Melinda,12260 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Rai, Barbara, J,22451 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Ma, Damien,15612 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Fernandez, Dominic,23630 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Mehta, Ronald, F,17649 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Nara, Alisha, D,26959 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Pal, Mohamed,20550 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Jai, Kelsey, J,27837 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Perez, Meagan, R,21101 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Subram, Bobby, J,29373 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Kapoor, Sergio, E,19392 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Chandra, Marie, A,25775 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ruiz, Nelson,23638 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Gutierrez, Casey,12519 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xu, Katie, R,14799 | 162.95 | 0.00 | 0.00 | 0.00 | 162.95 |
| Xu, Shaun, N,27804 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Harrison, Melody,28468 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gonzalez, Rachael, M,23636 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Mehta, Whitney, T,24197 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rowe, Alberto, W,26973 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Blanco, Jill,17838 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Rodriguez, Jay, M,28411 | 134.95 | 0.00 | 0.00 | 0.00 | 134.95 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Martin, Jacquelyn, M,17763 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Hernandez, Mason, C,27782 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Moreno, Briana, L,28734 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Powell, Christian,19522 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Raman, Ebony,19348 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Andersen, Damien, K,29402 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Johnson, Lucas,13509 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 0.00 | 31.55 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Xu, Mario,26411 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Reed, Taylor,23983 | 1195.47 | 0.00 | 0.00 | 0.00 | 1195.47 |
| Davis, Ashley,26407 | 126.28 | 0.00 | 0.00 | 0.00 | 126.28 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Rai, Colin, W,24573 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Zeng, Martha, J,17844 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Blanco, Max,26360 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Raman, Andre, D,24079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 0.00 | 123.47 |
| Vazquez, Carrie,29419 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Harris, Jonathan,26220 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Carter, Miguel,13776 | 70.57 | 0.00 | 0.00 | 0.00 | 70.57 |
| Black, Nicolas,23945 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Morgan, Makayla, C,27156 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Romero, Nelson,25728 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Tang, Johnny,15119 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Gao, Autumn, W,24085 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Julio,22460 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Ye, Ernest, A,22558 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanz, Randall, D,22539 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Neil, C,18181 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Ross, Gabriel, K,16314 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Xu, Gilbert,22554 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Ramos, Cheryl, A,25682 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Madan, Donald, R,27168 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Beck, Christine,20714 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Guo, Alvin, R,28878 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
Generated 2025-12-23 12:04:40.256 UTC