[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martinez, Samantha, C,12742 | 5148.31 | 0.00 | 0.00 | 4466.39 | 681.92 |
| Gao, Darryl,22693 | 1754.98 | 0.00 | 0.00 | 1754.98 | 0.00 |
| Jiménez, Cheryl,17198 | 7233.36 | 0.00 | 0.00 | 2443.35 | 4790.01 |
| Madan, Barry,26977 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Ward, Paige,16953 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Griffin, Devin,26042 | 5759.06 | 0.00 | 3374.99 | 0.00 | 2384.07 |
| Ward, Chase, T,15820 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Shen, Jon, R,13510 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Madan, Adriana,12275 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Hughes, Julian, S,11722 | 153.46 | 0.00 | 0.00 | 0.00 | 153.46 |
| Gray, Gabriella, M,22276 | 599.47 | 0.00 | 0.00 | 599.47 | 0.00 |
| Rodriguez, Erick, D,27209 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ward, Jeremy, D,24951 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Mitchell, Seth, A,11776 | 6079.24 | 0.00 | 3578.27 | 0.00 | 2500.97 |
| Pal, Gregory,19436 | 1942.70 | 0.00 | 0.00 | 782.99 | 1159.71 |
| Washington, Jackson,11978 | 74.98 | 0.00 | 0.00 | 34.99 | 39.99 |
| Peterson, Arianna, J,24989 | 36.59 | 0.00 | 0.00 | 36.59 | 0.00 |
| Wu, Jon,26278 | 29.98 | 0.00 | 0.00 | 29.98 | 0.00 |
| Allen, Marcus, D,23729 | 71.58 | 0.00 | 0.00 | 71.58 | 0.00 |
| Russell, Brandon,15278 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Anderson, Logan, C,15821 | 30.97 | 0.00 | 0.00 | 30.97 | 0.00 |
| Shan, Michele,27323 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Parker, Seth, R,18962 | 567.27 | 0.00 | 0.00 | 567.27 | 0.00 |
| Sharma, Chad, J,23847 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Andersen, Russell,14695 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Rivera, Timothy, A,21737 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Yuan, Edwin,21664 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Jiménez, Craig,13406 | 3722.28 | 0.00 | 0.00 | 0.00 | 3722.28 |
| Hu, Brittney,14160 | 6679.70 | 0.00 | 3578.27 | 0.00 | 3101.43 |
| Hernandez, Michele, F,22524 | 2478.24 | 0.00 | 0.00 | 0.00 | 2478.24 |
| Jones, Logan,22355 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Torres, Allison, E,21244 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Hill, Caleb, W,16333 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Stone, Michelle,13307 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Coleman, Alexia, E,13478 | 4898.32 | 0.00 | 0.00 | 2443.35 | 2454.97 |
| Torres, Tabitha,17629 | 4173.32 | 0.00 | 0.00 | 4173.32 | 0.00 |
| Powell, Ryan, K,29014 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Clark, Samantha,26573 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Scott, Morgan, D,22163 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Gonzales, Ethan, D,20696 | 73.96 | 0.00 | 0.00 | 73.96 | 0.00 |
| Watson, Caitlin, C,19733 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Andersen, Kara, B,14704 | 95.94 | 0.00 | 0.00 | 95.94 | 0.00 |
| Scott, Connor, R,21312 | 94.97 | 0.00 | 0.00 | 0.00 | 94.97 |
| Moreno, Julio, C,15953 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Bailey, Dalton, P,19722 | 586.46 | 0.00 | 0.00 | 0.00 | 586.46 |
| Malhotra, Cindy, T,25594 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Barnes, Anna,20436 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Powell, Sarah, H,24641 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Moreno, Ricky, R,17775 | 2793.91 | 0.00 | 0.00 | 1000.44 | 1793.47 |
| Gutierrez, Bruce, S,26861 | 36.27 | 0.00 | 0.00 | 36.27 | 0.00 |
| Morris, Hailey,15558 | 1362.96 | 0.00 | 0.00 | 1362.96 | 0.00 |
| Hernandez, Katherine,24528 | 2420.34 | 0.00 | 0.00 | 2420.34 | 0.00 |
| Bennett, Samantha, S,17096 | 4144.34 | 0.00 | 0.00 | 4144.34 | 0.00 |
| Rai, Katie, A,14951 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Perez, James, L,16385 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Shan, Clayton,13659 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| McDonald, Cesar, C,12821 | 124.94 | 0.00 | 0.00 | 0.00 | 124.94 |
| Hu, Jeffery, E,21132 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Richardson, Chloe, R,12115 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 |
| Bryant, Jordyn,12766 | 4417.73 | 0.00 | 3578.27 | 0.00 | 839.46 |
| Williams, Rachel, C,18924 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Diaz, Robert, J,15902 | 1397.95 | 0.00 | 0.00 | 782.99 | 614.96 |
| Rai, Marshall, A,25903 | 5773.04 | 0.00 | 3374.99 | 0.00 | 2398.05 |
| Walker, Samuel, J,26002 | 4699.31 | 0.00 | 3374.99 | 0.00 | 1324.32 |
| Washington, Arthur,26004 | 4698.81 | 0.00 | 3399.99 | 0.00 | 1298.82 |
| Moore, Kaitlyn,23585 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Shan, David,18680 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Andersen, Sheena,21047 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Cook, Melissa,25508 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Butler, Elizabeth, M,21057 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Nara, Jenny,11438 | 34.99 | 0.00 | 0.00 | 34.99 | 0.00 |
| Shan, Jason,28971 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Serrano, Theresa,11284 | 55.48 | 0.00 | 0.00 | 10.24 | 45.24 |
| Wang, Omar, D,15924 | 5744.00 | 0.00 | 0.00 | 2181.56 | 3562.44 |
| She, Krystal, A,25254 | 51.96 | 0.00 | 0.00 | 0.00 | 51.96 |
| Navarro, Andy, H,16397 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Liu, Barbara, A,25685 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Bryant, Devin,18947 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Martinez, Henry,19738 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Alexander, Gabrielle,17670 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Butler, Abigail, K,17389 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Jiménez, Casey,22438 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Liu, Colleen, A,29040 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Hughes, Kelly,26272 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Hill, Sierra, K,20343 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Rodriguez, Abigail,22301 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Long, Thomas, E,22289 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Long, Jasmine, C,28301 | 161.29 | 0.00 | 0.00 | 161.29 | 0.00 |
| Nara, Christy,11843 | 116.76 | 0.00 | 0.00 | 116.76 | 0.00 |
| Johnson, Joseph, L,24393 | 36.59 | 0.00 | 0.00 | 36.59 | 0.00 |
| Evans, Alex, C,12365 | 53.97 | 0.00 | 0.00 | 0.00 | 53.97 |
| Patterson, Logan,12101 | 92.27 | 0.00 | 0.00 | 49.99 | 42.28 |
| Zhang, Ryan,11873 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Ruiz, Paula, D,14377 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Yang, Christian,23139 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Torres, Jessica,27015 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Romero, Lee,20389 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Bailey, Timothy, L,18456 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Kumar, Terry, E,20083 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xie, Bradley, J,28476 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Watson, Lauren, K,15198 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Kapoor, Marie,12374 | 34.99 | 0.00 | 0.00 | 34.99 | 0.00 |
| Taylor, Greg, M,11683 | 5897.23 | 0.00 | 3578.27 | 2318.96 | 0.00 |
| Rubio, Frank,28764 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Brown, Alyssa, O,26468 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Serrano, Meghan, A,20391 | 23.97 | 0.00 | 0.00 | 23.97 | 0.00 |
| Xie, Alisha, C,17368 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Kumar, Luis,18583 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Srini, Frederick,18757 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Sanchez, Sean,12452 | 5935.55 | 0.00 | 3578.27 | 0.00 | 2357.28 |
| Rivera, Michelle, A,23058 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Moreno, Rebekah, J,14170 | 3291.82 | 0.00 | 2443.35 | 0.00 | 848.47 |
| Jenkins, Victoria,25428 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Blue, Rachel,20359 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gao, Clayton, C,22827 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Xu, Bonnie, C,14520 | 1503.58 | 699.10 | 0.00 | 0.00 | 804.48 |
| Watson, Natalie,25765 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Gonzales, Antonio,22270 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Nath, Mindy, F,20320 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Watson, Hailey, I,16119 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Patterson, Dakota, M,14465 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Parker, Judith, F,26904 | 28.99 | 0.00 | 0.00 | 28.99 | 0.00 |
| Chande, Darrell,11635 | 42.28 | 0.00 | 0.00 | 39.99 | 2.29 |
| Wilson, Kaitlyn,11691 | 119.96 | 0.00 | 0.00 | 65.97 | 53.99 |
| Yuan, Nina, R,11531 | 5875.55 | 0.00 | 3578.27 | 2297.28 | 0.00 |
Generated 2025-11-04 06:28:51.459 UTC