[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bennett, Jennifer, G,13708 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Zheng, Shannon, M,14678 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Yang, Jorge,20404 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Yuan, Katrina, D,26659 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ma, Cedric, W,11094 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Moore, Daniel, L,27647 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gonzalez, Ian,25346 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Robinson, Dylan, L,14724 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Cox, Caitlin,20510 | 72.93 | 0.00 | 0.00 | 0.00 | 72.93 |
| Thomas, Taylor,29275 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Gutierrez, Naomi, S,27280 | 4447.15 | 0.00 | 0.00 | 2049.10 | 2398.05 |
| Bennett, Angelica, L,23290 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Evans, Mary, E,17356 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ms., Spencer, Sylvia, N.,19303 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhao, Alvin, A,19347 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Cai, Kelvin, A,25456 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Jerome, B,11519 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Adams, Gabrielle, J,11172 | 128.94 | 0.00 | 0.00 | 0.00 | 128.94 |
| Alvarez, Michele, J,11844 | 124.97 | 0.00 | 0.00 | 0.00 | 124.97 |
| Weber, Jarrod, M,14859 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Zhu, Jamie, J,13140 | 255.22 | 0.00 | 0.00 | 0.00 | 255.22 |
| Hughes, Elizabeth,27029 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Patterson, Jordyn, A,27010 | 41.93 | 0.00 | 0.00 | 0.00 | 41.93 |
| Brooks, Natalie, W,25071 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Alonso, Bruce, L,20775 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Scott, Amber, B,17673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Mason, C,15293 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Deng, Karl, L,17210 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Edwards, Jackson,25785 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carter, Caleb, F,11067 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Gutierrez, Casey,12519 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Hernandez, Theresa,12955 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Patel, Veronica,13963 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Mr., Rothkugel, Michael, L.,20813 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Sanz, Tabitha,17496 | 118.49 | 0.00 | 0.00 | 0.00 | 118.49 |
| Kelly, Evan,11716 | 96.27 | 0.00 | 0.00 | 0.00 | 96.27 |
| Flores, Trevor,27676 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Sharma, Luis,16861 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Nelson, Edward,21441 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhou, Jeffery, M,24848 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rai, Jaclyn, I,20920 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Miller, Alexis, A,12196 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Sanchez, Mariah, R,19220 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Li, Jake, L,19583 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Vance, Jillian, D,15230 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Wright, Jackson,11698 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Jimenez, Ricky, J,19895 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Turner, Morgan,11823 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| King, Rebecca,16233 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Rana, Ebony, J,17190 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Rodriguez, George, A,19059 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Henderson, Faith,14545 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Fernandez, Sergio, K,25544 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Anderson, Thomas,11633 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Ward, Alyssa, M,19268 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Davis, Daniel,11711 | 104.56 | 0.00 | 0.00 | 0.00 | 104.56 |
| Rogers, Catherine, A,16076 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Scott, Kaitlyn, A,12159 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Kari,14856 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chandra, Michele, E,16257 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Li, Heather, C,12803 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Srini, Ronald, E,16467 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chande, Jaime,12313 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Lal, Jose,11819 | 96.27 | 0.00 | 0.00 | 42.28 | 53.99 |
| Cook, Gabriella,26460 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gutierrez, Brandi, S,17774 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Cooper, Erin, P,26844 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Gray, Olivia, L,28439 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Mr., Ruth, Andy,22706 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Carlson, Joanna,15594 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Moreno, Desirée, E,24479 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sun, Roger, C,25237 | 118.46 | 0.00 | 0.00 | 0.00 | 118.46 |
| Luo, Latoya, D,23285 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Brown, Grace,15749 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Malhotra, Carla, W,25654 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bell, Adrian,11874 | 72.21 | 0.00 | 0.00 | 0.00 | 72.21 |
| Gill, Kristy,13669 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sanz, Nelson, M,14056 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Cox, Kimberly, K,11636 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Garcia, Miguel, L,27032 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bennett, Nicole,23467 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Wang, Tamara, L,17881 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Jimenez, Roy,12334 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Watson, Destiny, W,24593 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nelson, Kaylee, E,11680 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Moore, Austin, N,26787 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Rivera, Charles,15383 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Smith, Robert,15113 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Cook, Angela,20899 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Jai, James, J,13211 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Coleman, Samuel, N,17450 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Suri, Gerald,13617 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Alonso, Lance, I,14057 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Guo, Krystal, S,17381 | 159.00 | 0.00 | 0.00 | 0.00 | 159.00 |
| Chander, Maurice, L,14086 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Jackson, José, J,27538 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Green, Samuel, D,14096 | 58.96 | 0.00 | 0.00 | 0.00 | 58.96 |
| Garcia, Marco, J,15336 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Arun, Darren,29219 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Diaz, Destiny,28262 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Griffin, Victoria, A,20737 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Jackson, Brianna,15377 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Richardson, Erin, R,16331 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Chandra, Levi,12093 | 46.28 | 0.00 | 0.00 | 0.00 | 46.28 |
| Sanders, Sean,14341 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| James, Eduardo, C,23702 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Vance, Kari, C,21531 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Evans, Allison,11209 | 37.29 | 0.00 | 0.00 | 2.29 | 35.00 |
| Rivera, Amanda,11131 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Mitchell, Nathan,28634 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Wang, Elijah, S,21757 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Murphy, Catherine, L,16506 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Carlson, Neil, M,19226 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Serrano, Jaime, M,18159 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Vazquez, Clinton, C,27831 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Smith, Austin,13707 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Navarro, Byron,16622 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Carlson, Roy, C,20257 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sanders, Shelby, S,27735 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Hughes, Morgan, T,11642 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Foster, Haley,14258 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Browning, Melody,12801 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Lin, Glenn,29288 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Walker, Richard, T,19640 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Phillips, Mackenzie,12444 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
Generated 2025-11-03 14:06:04.778 UTC