[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Li, Todd,11233 | 179.43 | 0.00 | 0.00 | 0.00 | 179.43 |
| Lee, Lauren, D,14477 | 3342.41 | 0.00 | 0.00 | 1000.44 | 2341.97 |
| Ross, Joan, A,24687 | 91.58 | 0.00 | 0.00 | 0.00 | 91.58 |
| Goel, Lindsay, A,28380 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Roberts, Kevin, A,20705 | 69.47 | 0.00 | 0.00 | 0.00 | 69.47 |
| Anderson, Jessica,20367 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Rubio, Erik, C,15064 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Gonzalez, Isaac, E,17165 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Nichole,12301 | 9717.11 | 0.00 | 0.00 | 2482.23 | 7234.88 |
| Chande, Clarence, A,22699 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Bailey, Anna,23053 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Jiménez, Craig,13406 | 3722.28 | 0.00 | 0.00 | 0.00 | 3722.28 |
| Carter, Gabrielle, B,16596 | 4486.54 | 0.00 | 0.00 | 2181.56 | 2304.98 |
| Barnes, Natalie,24295 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Romero, Janet, D,26612 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Walker, Alexis,20291 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Washington, Zachary,15509 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Johnston, Joanna, L,17296 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Thomas, Hannah,14295 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Suarez, Darren, C,19481 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Perry, Brittany,24741 | 32.60 | 0.00 | 0.00 | 32.60 | 0.00 |
| Murphy, Paige,27636 | 6011.31 | 3578.27 | 0.00 | 0.00 | 2433.04 |
| Schmidt, Allen,24704 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Murphy, Timothy,14331 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gonzalez, Isabella, L,26475 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Sai, Nancy, B,23440 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Rodriguez, Alexander, S,23064 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Cox, Patrick, S,21497 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Andersen, Alvin, C,13744 | 2959.00 | 0.00 | 0.00 | 2959.00 | 0.00 |
| Moreno, Desirée, E,24479 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Parker, Kaitlyn, M,24400 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Martinez, Miguel,27605 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Baker, Jesse, M,21766 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Xie, Peter,18018 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Gonzalez, Monica,28421 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Zhao, Tiffany, K,13565 | 4775.63 | 0.00 | 2443.35 | 0.00 | 2332.28 |
| Ramos, Lawrence, P,26493 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Luo, Drew,29018 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Srini, Marco, A,28288 | 6039.30 | 0.00 | 3578.27 | 0.00 | 2461.03 |
| Navarro, Jésus, L,29483 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Murphy, Sydney, T,28252 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Ann, E,28990 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Madan, Mayra, M,19027 | 3029.08 | 0.00 | 699.10 | 0.00 | 2329.98 |
| Perez, Alex,24522 | 2482.56 | 0.00 | 0.00 | 2482.56 | 0.00 |
| Martinez, Rebekah, A,12721 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Russell, Riley, M,18539 | 2356.95 | 0.00 | 0.00 | 0.00 | 2356.95 |
| Anand, Latoya, D,28347 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Lewis, David,15203 | 3211.45 | 0.00 | 782.99 | 0.00 | 2428.46 |
| Brooks, Katherine,22098 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Price, Gavin, J,24259 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Sai, Johnathan, B,24812 | 82.59 | 0.00 | 0.00 | 0.00 | 82.59 |
| Bailey, Erin, S,25370 | 1263.82 | 0.00 | 0.00 | 0.00 | 1263.82 |
| Reed, Kimberly, D,17311 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Andersen, Alisha,25460 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Oliver, Natasha,26996 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Liu, Lisa, J,17584 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hayes, Zachary,17448 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Sanders, Alyssa, R,25007 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Wang, Kelli,17939 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Gao, Shannon,27571 | 4484.48 | 0.00 | 0.00 | 2071.42 | 2413.06 |
| Yuan, Alisha, M,27013 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Suri, Darren,17964 | 5750.36 | 0.00 | 0.00 | 2181.56 | 3568.80 |
| Alexander, Tristan, P,11248 | 38.47 | 0.00 | 0.00 | 0.00 | 38.47 |
| Coleman, Sydney, M,23480 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzales, Vanessa,24969 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Rodriguez, Kaitlin,21107 | 806.76 | 0.00 | 0.00 | 0.00 | 806.76 |
| Chander, Carly, C,26961 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Russell, Anna, O,20386 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Williams, Daniel, S,17517 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Morgan, D,19713 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Patterson, Brittany, M,12982 | 57.97 | 0.00 | 0.00 | 0.00 | 57.97 |
| Henderson, Mariah, C,13369 | 4778.33 | 0.00 | 2443.35 | 0.00 | 2334.98 |
| Long, Dalton,24430 | 130.56 | 0.00 | 0.00 | 0.00 | 130.56 |
| Blanco, Ebony, J,17473 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Phillips, Jonathan,11278 | 5908.25 | 0.00 | 3578.27 | 2329.98 | 0.00 |
| Torres, Ricky, L,21680 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Prasad, Monica, C,21019 | 629.96 | 0.00 | 0.00 | 0.00 | 629.96 |
| Kumar, Brad,28093 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Martin, Brandi, A,15368 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Luo, Bethany,19582 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Martin, Michael,18783 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Rogers, Hailey, L,13861 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Nelson, Connor,21013 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Nara, Kenneth, K,14177 | 46.83 | 0.00 | 0.00 | 0.00 | 46.83 |
| Garcia, Abby, A,26948 | 1293.33 | 0.00 | 0.00 | 0.00 | 1293.33 |
| Long, Luis, F,24318 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Lee, Alyssa,13837 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Zhao, Jake,12312 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Ortega, Marc, C,22644 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Alonso, Sabrina, R,21051 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Weber, Darren, A,22563 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Anderson, Nicholas,29206 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Gomez, Casey,22497 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Patterson, Samuel, R,13386 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Turner, Kaitlyn,26239 | 51.96 | 0.00 | 0.00 | 0.00 | 51.96 |
| Gonzalez, Andre, L,25440 | 57.09 | 0.00 | 0.00 | 0.00 | 57.09 |
| Gomez, Jacquelyn, R,16592 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Diaz, Kellie, A,18330 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Gonzalez, Heidi, Z,13157 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Sun, Gilbert, L,12878 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Wright, Carlos, K,15515 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Edwards, Sophia, R,18232 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Yang, Gilbert, M,19370 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Samantha, J,14479 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Anderson, Alexander, G,22723 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Evans, Katelyn,26240 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Carter, Charles, R,22899 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Bryant, Melissa,13218 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Gonzales, Angela, S,22037 | 45.22 | 0.00 | 0.00 | 0.00 | 45.22 |
| Jai, Bradley,12204 | 119.93 | 0.00 | 0.00 | 22.97 | 96.96 |
| Brooks, Shelby,25103 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Rubio, Albert,27846 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
Generated 2025-12-22 03:30:04.716 UTC