[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1250 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raje, Maurice,14821 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Nara, April, E,25721 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Hernandez, Kaitlyn, S,25647 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Ruiz, Briana,20906 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Cox, Cole, M,25315 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ramos, Janet, B,20596 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Arun, Rachael, J,23976 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jai, Lindsey, W,23971 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Madan, Carolyn,26222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Kapoor, Nancy, L,18024 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Sai, Dominique,28908 | 33.43 | 0.00 | 0.00 | 33.43 | 0.00 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| He, Claudia, F,24093 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Mr., Shridhar, Shish,25761 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Mehta, Whitney, T,24197 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rai, Cassie, R,14194 | 168.93 | 0.00 | 0.00 | 0.00 | 168.93 |
| Andersen, Tamara, B,29392 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| She, Warren,21824 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Kumar, Dustin, R,26846 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Richardson, Julia, N,27331 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Luo, Alvin,23635 | 2452.34 | 0.00 | 0.00 | 2452.34 | 0.00 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moreno, Briana, L,28734 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Andersen, Damien, K,29402 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| He, Arturo,29369 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Munoz, Meghan, P,27810 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Garcia, Francisco,25701 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Sanchez, Kari, T,19262 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Garcia, Marie,27953 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
| Clark, Marcus, G,27958 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Vance, Martin, A,25604 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ms., Sheperdigian, Janet,24541 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Vazquez, Carrie,29419 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Black, Nicolas,23945 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Yang, Luke,28526 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Wu, Trisha,26404 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Torres, Julio,22460 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Lin, Cara,29411 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Howard, Victoria, L,21525 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| She, Cara, H,22646 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hall, Destiny, G,25615 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Fernandez, Stanley, R,24064 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Rodriguez, Dominic, E,28525 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Dominguez, Erik, L,26037 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rana, Andre,27904 | 156.76 | 0.00 | 0.00 | 0.00 | 156.76 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Wright, Elijah, I,25577 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Christy, R,23639 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Martin, Dalton, J,12505 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gill, Darren, M,11408 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Torres, Nelson, F,25804 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Victor,18030 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Dominguez, Teresa, C,20963 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Patterson, Melanie,28898 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Rubio, Jamie, W,27179 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lal, Alvin,24058 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Gao, Colleen,15108 | 210.54 | 0.00 | 0.00 | 0.00 | 210.54 |
| Fernandez, Dominique,12839 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Munoz, Rodney,12836 | 68.46 | 0.00 | 0.00 | 0.00 | 68.46 |
| Munoz, Danny,19355 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Washington, Anna,14817 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Serrano, Michele, R,19483 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Romero, Lori, A,28738 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Ms., Slattengren, Dianne, K.,27928 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Patel, Cassandra, P,12465 | 83.42 | 0.00 | 0.00 | 0.00 | 83.42 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Goldberg, Nicolas,27789 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gonzalez, Raymond, P,28755 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Ashe, Tasha, W,24881 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Jimenez, Roy,12334 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanz, Latasha,29384 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Martin, Carolyn, M,12652 | 182.94 | 0.00 | 0.00 | 0.00 | 182.94 |
| Zhou, Alejandro, A,12304 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Jai, Christy, G,26979 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Vance, Marie, W,21012 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Chandra, Roy, R,24583 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Saunders, Dominique, M,29469 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Raman, Cynthia, P,27786 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gutierrez, Daisy,21541 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
Generated 2025-12-23 05:00:44.420 UTC