[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Andre, M,13661 | 5913.24 | 3578.27 | 0.00 | 0.00 | 2334.97 |
| Gomez, Kristi,26911 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Gomez, Jésus,29401 | 1223.84 | 0.00 | 0.00 | 1223.84 | 0.00 |
| Hu, Darryl,24868 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Lopez, Marie,16192 | 101.45 | 0.00 | 0.00 | 29.48 | 71.97 |
| Dominguez, Jésus,17087 | 75.21 | 0.00 | 0.00 | 0.00 | 75.21 |
| Romero, Jerome,11337 | 8162.00 | 0.00 | 3374.99 | 2388.96 | 2398.05 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Rai, Kristin, C,12569 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Jackson, Kayla, R,20060 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Townsend, Michelle, P,12864 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Rai, Sheena,29393 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Kumar, Clayton,13841 | 6624.60 | 0.00 | 3578.27 | 751.34 | 2294.99 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Colin, A,25801 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Kelly, Richard,17991 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Nara, Shawn, C,13845 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sai, Dominique,28908 | 33.43 | 0.00 | 0.00 | 33.43 | 0.00 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Zheng, Lisa, R,13846 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 0.00 | 72.58 |
| Raman, Joe, G,16511 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Rogers, Cody, F,26892 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 0.00 | 4822.00 |
| Carlson, Kristine, C,28753 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Coleman, Trevor, C,25313 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Green, Luke, R,28392 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Chander, Lindsey,26949 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Raman, Ebony,19348 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rubio, Clinton, A,25612 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Gray, Natalie, L,14165 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| Hall, Sydney, T,17880 | 39.55 | 0.00 | 0.00 | 0.00 | 39.55 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Romero, Teresa, A,26834 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| King, Wyatt,22671 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Beck, Clayton,11579 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 0.00 | 3151.30 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 0.00 | 663.44 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Yuan, Kristin, C,24114 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Moreno, Lee,25632 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Garcia, Francisco,25701 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Robinson, Matthew, D,29376 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 2297.28 | 2422.54 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Cook, Carlos, R,26955 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Yang, Marshall, E,12564 | 110.75 | 0.00 | 0.00 | 0.00 | 110.75 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Fernandez, Dominic,23630 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Randall, Kristi,13665 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Ramos, Anne, R,11351 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Mehta, Ronald, F,17649 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Bryant, Alexandra,12598 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Bhat, Drew,14820 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Romero, Tabitha, M,22416 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Howard, Angel, A,23223 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jackson, Alexandra, A,24184 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 0.00 | 4714.05 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Blanco, Joe,25675 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Raji, Edwin,11469 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Raji, Franklin,11400 | 6967.78 | 0.00 | 3374.99 | 2318.96 | 1273.83 |
| Scott, Kyle, D,11419 | 231.75 | 0.00 | 0.00 | 0.00 | 231.75 |
| Kapoor, Sergio, E,19392 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Yuan, Bonnie, H,15048 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Dominguez, Natasha,23769 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Kumar, Roger, C,15922 | 148.20 | 0.00 | 0.00 | 0.00 | 148.20 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Lopez, Dominique, S,15077 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hall, Destiny, G,25615 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Andersen, Jaclyn,11468 | 6959.82 | 0.00 | 3374.99 | 2319.99 | 1264.84 |
| Clark, Devin,25512 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Jimenez, Michele,13547 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| She, Raul,19497 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 0.00 | 3789.76 |
| Smith, Ethan,14530 | 72.86 | 0.00 | 0.00 | 0.00 | 72.86 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 0.00 | 90.47 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Xie, Katrina, M,26897 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Munoz, Lori, M,22639 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Richardson, Ian,11414 | 7191.77 | 0.00 | 3399.99 | 0.00 | 3791.78 |
| Walker, Sarah, R,13814 | 230.04 | 0.00 | 0.00 | 0.00 | 230.04 |
| Dominguez, Erik, L,26037 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Browning, Casey,16449 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Jai, Terrence,27956 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Alvarez, Kristi,12303 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 0.00 | 70.24 |
| Gonzalez, Rachael, M,23636 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2025-12-21 20:39:49.967 UTC