[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1246 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Ye, Arturo,20727 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 | 0.00 |
| Lopez, Madeline, G,12044 | 105.95 | 0.00 | 0.00 | 0.00 | 105.95 | 0.00 |
| Butler, Kyle, B,14327 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 | 0.00 |
| Zheng, Crystal,21127 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 | 0.00 |
| Wang, Logan, M,12150 | 42.95 | 0.00 | 0.00 | 0.00 | 42.95 | 0.00 |
| Sanchez, Alexandra, J,12905 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 | 0.00 |
| Butler, Vanessa,20545 | 2542.31 | 0.00 | 0.00 | 0.00 | 2542.31 | 0.00 |
| Cox, Brianna,15329 | 3134.95 | 0.00 | 0.00 | 782.99 | 2351.96 | 0.00 |
| Diaz, Taylor, E,20661 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Xie, Keith, W,24203 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 | 0.00 |
| Kapoor, Shane, D,25498 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 | 0.00 |
| Zhu, Willie,12487 | 4401.40 | 0.00 | 0.00 | 2071.42 | 2329.98 | 0.00 |
| Cooper, Julia, V,28622 | 88.46 | 0.00 | 0.00 | 0.00 | 88.46 | 0.00 |
| Lopez, Angel,23263 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 | 0.00 |
| Richardson, Kaylee, L,17560 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lopez, Stefanie, J,14826 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lopez, Gerald, M,25530 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 | 0.00 |
| Beck, Alison,28889 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 | 0.00 |
| Mehta, Adriana,12858 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 | 0.00 |
| Taylor, Dylan, P,27992 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 | 0.00 |
| Lee, Jonathan,28263 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Clark, Alexis,25039 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Price, Hailey,24428 | 152.60 | 0.00 | 0.00 | 0.00 | 152.60 | 0.00 |
| Brown, Hunter,27036 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Murphy, Kaylee, A,22743 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 | 0.00 |
| Alvarez, Shannon,11551 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 | 0.00 |
| Simmons, Rachel, E,16320 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 | 0.00 |
| Nath, Christine, M,26909 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 | 0.00 |
| Powell, Wyatt, L,12066 | 84.99 | 0.00 | 0.00 | 0.00 | 84.99 | 0.00 |
| Thompson, Elizabeth, W,11864 | 47.94 | 0.00 | 0.00 | 0.00 | 47.94 | 0.00 |
| Butler, Noah, E,12164 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 | 0.00 |
| Taylor, Nicole, B,11538 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 | 0.00 |
| McDonald, Alexandra,26722 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 | 0.00 |
| Lee, Matthew,29225 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 | 0.00 |
| Rai, Jaime, M,17667 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 | 0.00 |
| Zheng, Eugene,23960 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 | 0.00 |
| Torres, Theodore,13577 | 9450.32 | 0.00 | 2181.56 | 0.00 | 7268.76 | 0.00 |
| Garcia, Clifford,12267 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Morgan, Brooke, M,23031 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Parker, Kevin,20522 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 | 0.00 |
| Green, Dalton,18343 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Wu, Louis, K,23755 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 | 0.00 |
| Dominguez, Gloria, A,16322 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 | 0.00 |
| Kapoor, Geoffrey,17748 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 | 0.00 |
| Campbell, Morgan, W,26010 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| He, Margaret,12308 | 9691.00 | 0.00 | 0.00 | 2500.44 | 7190.56 | 0.00 |
| Gao, Shannon,27571 | 4484.48 | 0.00 | 0.00 | 2071.42 | 2413.06 | 0.00 |
| Anderson, William, L,23707 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 | 0.00 |
| Young, Sydney, K,21006 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 | 0.00 |
| Wagner, Krystal, F,28919 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| King, Allison, M,13915 | 3045.53 | 0.00 | 0.00 | 2181.56 | 863.97 | 0.00 |
| Wright, Andrea,15479 | 85.95 | 0.00 | 0.00 | 0.00 | 85.95 | 0.00 |
| Evans, Amber,27933 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 | 0.00 |
| Malhotra, Jarrod, E,27316 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Kumar, Thomas, M,12434 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 | 0.00 |
| Ashe, Mario, T,13384 | 4573.52 | 0.00 | 0.00 | 2181.56 | 2391.96 | 0.00 |
| Davis, Brianna, M,19774 | 148.47 | 0.00 | 0.00 | 0.00 | 148.47 | 0.00 |
| Jones, Megan,20115 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 | 0.00 |
| Collins, Hunter,18534 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 | 0.00 |
| Henderson, Luis,14579 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 | 0.00 |
| Lopez, Devin,24492 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 | 0.00 |
| She, Randy, H,11415 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Johnson, Christian, S,26082 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 | 0.00 |
| Gray, Isaac, G,12373 | 2359.46 | 0.00 | 0.00 | 0.00 | 2359.46 | 0.00 |
| Jones, Miguel, R,16900 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Moore, Jose, M,13161 | 4523.53 | 0.00 | 2181.56 | 0.00 | 2341.97 | 0.00 |
| Li, Alan, M,27773 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 | 0.00 |
| Carter, Isaiah,27572 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 | 0.00 |
| Brown, Edward,27621 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Hernandez, Jeremiah, C,25303 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Nara, Colleen, L,14798 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 | 0.00 |
| Ruiz, Dana, M,14819 | 4355.71 | 0.00 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Rubio, Michele, L,21769 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 | 0.00 |
| Sara, Francisco, A,12296 | 9586.37 | 0.00 | 0.00 | 2451.30 | 7135.07 | 0.00 |
| Nelson, Nathan,22742 | 71.94 | 0.00 | 0.00 | 0.00 | 71.94 | 0.00 |
| Bryant, Hannah, D,20116 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 | 0.00 |
| Reed, Maria,11208 | 134.23 | 0.00 | 0.00 | 0.00 | 134.23 | 0.00 |
| Narayanan, Sriniwa, J,15862 | 1379.95 | 0.00 | 0.00 | 782.99 | 596.96 | 0.00 |
| Foster, Abigail, R,12105 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 | 0.00 |
| Bailey, Kaitlyn, M,12153 | 5938.23 | 0.00 | 3578.27 | 0.00 | 2359.96 | 0.00 |
| Russell, Ethan, I,15522 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 | 0.00 |
| Kelly, Isaac, P,14645 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 | 0.00 |
| Evans, Charles, L,12770 | 5943.50 | 0.00 | 3578.27 | 0.00 | 2365.23 | 0.00 |
| Alexander, Miguel,15372 | 3105.27 | 0.00 | 0.00 | 782.99 | 2322.28 | 0.00 |
| Jenkins, Lucas, C,23338 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 | 0.00 |
| Bradley, Erin, S,13401 | 4798.34 | 0.00 | 0.00 | 2443.35 | 2354.99 | 0.00 |
| Anand, Priscilla, R,17005 | 2376.45 | 0.00 | 0.00 | 0.00 | 2376.45 | 0.00 |
| Roberts, Julia, M,21942 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Peterson, Ariana,11521 | 44.57 | 0.00 | 0.00 | 0.00 | 44.57 | 0.00 |
| Miller, Madison,22982 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Clark, Kaitlyn, W,16863 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 | 0.00 |
| Flores, María,17359 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Turner, Janet, M,17130 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 | 0.00 |
| Hall, Alexandra,15869 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Miller, Lucas, L,12495 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 | 0.00 |
| Gray, Carlos,11781 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 | 0.00 |
| Bradley, Alyssa, C,15677 | 7200.86 | 0.00 | 0.00 | 2443.35 | 4757.51 | 0.00 |
| Sanders, Victoria,29078 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 | 0.00 |
| Ross, Jacqueline,18918 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 | 0.00 |
| Wright, Adam,17525 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| James, Gabrielle,12725 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 | 0.00 |
| Simmons, Nathan, M,11043 | 47.98 | 0.00 | 0.00 | 0.00 | 47.98 | 0.00 |
| Hayes, Connor,27626 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 | 0.00 |
| Perry, Brianna, W,18230 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Blanco, Frank,23975 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Patel, Tabitha, R,27931 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Sanchez, Summer, L,17553 | 2342.92 | 0.00 | 0.00 | 0.00 | 2342.92 | 0.00 |
| Bennett, Caroline,17508 | 2324.92 | 0.00 | 0.00 | 0.00 | 2324.92 | 0.00 |
| Hughes, Thomas, M,17420 | 2370.22 | 0.00 | 0.00 | 0.00 | 2370.22 | 0.00 |
| Rogers, Morgan, B,11674 | 96.27 | 0.00 | 0.00 | 0.00 | 96.27 | 0.00 |
| King, Noah,25876 | 4629.07 | 0.00 | 3374.99 | 0.00 | 1254.08 | 0.00 |
| Munoz, Reginald, C,25889 | 4651.11 | 0.00 | 3399.99 | 0.00 | 1251.12 | 0.00 |
| Parker, Jesse,23032 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 | 0.00 |
| Ye, Tiffany, K,23326 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 | 0.00 |
| Yang, Dennis, P,15003 | 3048.56 | 0.00 | 0.00 | 2443.35 | 605.21 | 0.00 |
| Collins, Isaiah, A,12065 | 92.27 | 0.00 | 0.00 | 0.00 | 92.27 | 0.00 |
| Li, Benjamin, H,14623 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 | 0.00 |
| Raji, Gregory,14718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 | 0.00 |
| Torres, Ricky, L,21680 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 | 0.00 |
| Ward, Mason,23840 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Huang, Tiffany, L,21723 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 | 0.00 |
| Brooks, Jada, A,21428 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Rodriguez, Tabitha, M,21785 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Howard, Sydney,21644 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 | 0.00 |
Generated 2026-01-04 05:46:59.823 UTC