[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1750 > < TAKE 250 >
140 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Sara, Levi, S,12540 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Zheng, Trisha,22437 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gomez, Kristi,26911 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Morgan, Makayla, C,27156 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Parker, Wyatt,25325 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sai, Roy, J,16038 | 84.25 | 0.00 | 0.00 | 0.00 | 84.25 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Lal, Alvin,24058 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Anderson, Samuel, D,14199 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Sanz, Randall, D,22539 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Townsend, Michelle, P,12864 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 0.00 | 72.58 |
| Carlson, Kristine, C,28753 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Raman, Ebony,19348 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sharma, Jaclyn, C,28403 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chande, Christy,26214 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Hernandez, Gabriel, J,13805 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Andersen, Kathryn,21865 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Hall, Sydney, T,17880 | 39.55 | 0.00 | 0.00 | 0.00 | 39.55 |
| King, Wyatt,22671 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 0.00 | 663.44 |
| Moreno, Lee,25632 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Yang, Marshall, E,12564 | 110.75 | 0.00 | 0.00 | 0.00 | 110.75 |
| Liu, Roger, E,20058 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Coleman, Gabriel, B,17706 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rai, Dustin, J,26417 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ashe, Melvin,26817 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Yuan, Cedric,15449 | 49.56 | 0.00 | 0.00 | 0.00 | 49.56 |
| Alvarez, Deanna, K,24720 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Nara, Roger,26928 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Morris, Jacqueline, H,29468 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Maurice,26929 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Kumar, Nichole,23236 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Dominguez, Natasha,23769 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Clark, Devin,25512 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Miller, Grace,22502 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Hayes, Seth, C,17757 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Goel, Tasha, R,19478 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sun, Autumn, A,22564 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Fernandez, Chelsea, J,19905 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| 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 |
| Blanco, Meghan,17961 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Chander, Nichole, H,28451 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Kapoor, Jermaine, A,29368 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Gray, Allison, D,20571 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chandra, Whitney,15712 | 51.57 | 0.00 | 0.00 | 0.00 | 51.57 |
| Vazquez, Carrie,29419 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Ramos, Erik, M,25312 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Rana, Cesar, L,19044 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Rai, Darrell, C,26906 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Zheng, Nuan,13604 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Randall, Mayra,27909 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Coleman, Christian,25798 | 2452.34 | 0.00 | 0.00 | 0.00 | 2452.34 |
| 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 |
| Adams, Ian, C,29422 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Malhotra, Allen, A,15102 | 97.35 | 0.00 | 0.00 | 0.00 | 97.35 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Kumar, Carl,12743 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martinez, Francisco,11375 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Stone, Brent,22811 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Mehta, George, L,20566 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Tasha,20565 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Zhao, Amy, C,26416 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Subram, Lydia, F,28549 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Lopez, Janelle, G,25500 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Thomas, Miguel,25480 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Holt, Katie,27946 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Srini, Whitney,11560 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Roberts, Nathan,29470 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ruiz, Briana,20906 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Romero, Jaime, B,28508 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Simmons, Wyatt, V,22604 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Chande, Tamara, L,28693 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Guo, Stacey,24207 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Chandra, Summer, D,24880 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suarez, Sheila,28884 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Yang, Luke,28526 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Zhu, Stacey, E,22636 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Zhao, Omar,27927 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Bryant, Ian,27319 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| _SUM | 3388349.72 | 49631.45 | 561208.39 | 810781.72 | 1966728.16 |
Generated 2025-12-22 02:13:15.856 UTC