[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 969 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| She, Raul,19497 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Rana, Roy, M,22667 | 1170.48 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Rana, Kristopher, W,22550 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Deng, Drew, E,17882 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Schmidt, Dana, S,25641 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Raman, Cynthia, P,27786 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Griffin, Spencer,13784 | 7138.10 | 0.00 | 3578.27 | 0.00 | 3559.83 |
| Serrano, Theodore,22631 | 1149.47 | 0.00 | 0.00 | 1149.47 | 0.00 |
| Gutierrez, Daisy,21541 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Rodriguez, Dominic, E,28525 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zhang, Trisha,18156 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Raji, Colin, A,25801 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Wilson, Jacob, H,15078 | 6675.60 | 0.00 | 3578.27 | 0.00 | 3097.33 |
| Bryant, Ian,27319 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Sharma, Jaclyn, C,28403 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Pal, Jon, H,15440 | 6736.56 | 0.00 | 3578.27 | 0.00 | 3158.29 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gao, Marshall,25782 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Shan, Grant,26215 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Levi,26830 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ortega, Jésus, L,16542 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Rodriguez, Deanna,25611 | 564.48 | 0.00 | 0.00 | 564.48 | 0.00 |
| Chande, Christy,26214 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ross, Hailey, C,13612 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Luo, Dale, M,22613 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Henderson, Hunter, C,14812 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhou, Claudia, M,11247 | 7131.51 | 0.00 | 3374.99 | 2340.23 | 1416.29 |
| Hernandez, Adrienne, Y,22668 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Suri, Tammy,24031 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Wright, Elijah, I,25577 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Gao, Dennis,18187 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Zheng, Trisha,22437 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Shan, Aaron,20730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| Rai, Kara, D,26970 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Subram, Carmen, J,29473 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lal, Bonnie, A,29445 | 182.78 | 0.00 | 0.00 | 0.00 | 182.78 |
| Martinez, Brandy, L,12865 | 114.23 | 0.00 | 0.00 | 0.00 | 114.23 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| She, Omar, K,15448 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ortega, Walter,28377 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Diaz, Erik, S,11565 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 29.48 | 4.99 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Rubio, Clinton, A,25612 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Butler, Blake,13583 | 8375.29 | 3578.27 | 0.00 | 0.00 | 4797.02 |
| Li, Heather, C,12803 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Morris, Savannah,13585 | 8368.29 | 3578.27 | 0.00 | 0.00 | 4790.02 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Carlson, Ruben, J,25304 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Wu, Heather, M,19261 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Washington, Kelly, M,28748 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 0.00 | 106.24 |
| Chandra, Sergio, A,22837 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Scott, Mackenzie, L,25676 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanders, Richard, D,21511 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Nath, Sheena,25800 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Bailey, Ariana, J,13691 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Wang, Cara,21023 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Sharma, Barbara, D,22421 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Hu, Lisa, L,21118 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Suri, Summer,26219 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Perez, Michele, K,13772 | 5928.25 | 0.00 | 3578.27 | 0.00 | 2349.98 |
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Gao, Colleen,15108 | 210.54 | 0.00 | 0.00 | 0.00 | 210.54 |
| Hu, Darryl,24868 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Shen, Kara, C,23628 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Nara, Shawn, C,13845 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Blue, Oscar, L,27008 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Xie, Sheena,18041 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Zheng, Lisa, R,13846 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Baker, Caleb, F,23968 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 0.00 | 152.94 |
| Blanco, Theresa,26824 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Becker, Louis, J,24193 | 1199.46 | 0.00 | 0.00 | 0.00 | 1199.46 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Smith, Destiny,22428 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Romero, Armando, A,12596 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Anderson, Samuel, D,14199 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Jai, Kelli,22530 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
Generated 2025-12-23 12:26:46.599 UTC