[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Carlson, Carolyn, S,23828 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Hall, Anna, J,23850 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Martinez, Charles, D,21704 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Anand, Arturo,22626 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Rubio, Alfredo, D,17929 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Butler, Alexandria,25528 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Sharma, Shaun, L,14148 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Gonzales, Oscar, H,27481 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Peterson, Makayla,24407 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Cook, Zoe,24616 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Williams, Dalton, A,17602 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Stacy, K,14506 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kapoor, Henry, C,20715 | 196.27 | 0.00 | 0.00 | 0.00 | 196.27 |
| Washington, Jackson,11978 | 74.98 | 0.00 | 0.00 | 34.99 | 39.99 |
| Raman, Toni,21530 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Martinez, Xavier,12063 | 84.99 | 0.00 | 0.00 | 0.00 | 84.99 |
| Jiménez, Albert, D,12389 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Cook, Danielle, M,13385 | 4548.50 | 0.00 | 2181.56 | 0.00 | 2366.94 |
| Rogers, Jesse,17462 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Simpson, Mindy, A,15200 | 3142.97 | 0.00 | 782.99 | 0.00 | 2359.98 |
| Phillips, Angel,29223 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Mitchell, Kaitlyn, D,18130 | 5743.97 | 0.00 | 1000.44 | 0.00 | 4743.53 |
| Hayes, Elijah, P,15325 | 1584.76 | 0.00 | 782.99 | 0.00 | 801.77 |
| Zhang, Noah, J,15339 | 1622.47 | 0.00 | 0.00 | 782.99 | 839.48 |
| Rivera, Destiny, C,11204 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Alexander, Arianna,17423 | 2297.28 | 0.00 | 0.00 | 0.00 | 2297.28 |
| Carter, Thomas, W,22792 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ramirez, Hailey,17413 | 2365.94 | 0.00 | 0.00 | 0.00 | 2365.94 |
| Huang, Kelli,18933 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Clark, Christopher, R,27808 | 866.31 | 0.00 | 0.00 | 0.00 | 866.31 |
| Nath, Priscilla, H,21820 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Griffin, Katherine, P,27543 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Liang, Tamara, L,11087 | 200.28 | 0.00 | 0.00 | 162.99 | 37.29 |
| Coleman, Victoria, O,23708 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zhang, Jeffery, C,12472 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Lewis, Richard, I,21637 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Chen, Kelli,19325 | 3546.12 | 0.00 | 0.00 | 0.00 | 3546.12 |
| Fernandez, Meredith,25606 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Richardson, Jesse, M,25895 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Cook, Mason, M,17614 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Carlson, Sabrina, A,23933 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Ramos, Hector,15667 | 3125.32 | 0.00 | 2443.35 | 0.00 | 681.97 |
| Anderson, Hannah, C,11883 | 77.27 | 0.00 | 0.00 | 42.28 | 34.99 |
| Xu, Micah, M,15931 | 5362.29 | 0.00 | 0.00 | 3018.33 | 2343.96 |
| Turner, Devin, J,23464 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Smith, Wyatt, P,23147 | 157.27 | 0.00 | 0.00 | 0.00 | 157.27 |
| White, Joshua, J,24320 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Griffin, Fernando, J,23027 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Wilson, Cameron,21498 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Richardson, Melanie, M,13858 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Hernandez, Meghan,11184 | 68.25 | 0.00 | 0.00 | 0.00 | 68.25 |
| Zhao, Ronnie,17955 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Hernandez, Amber,16019 | 573.98 | 0.00 | 0.00 | 0.00 | 573.98 |
| Perez, Connor,15369 | 3127.95 | 0.00 | 0.00 | 782.99 | 2344.96 |
| Lal, Dale,12324 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Edwards, Jennifer,12962 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Rai, Bridget, L,17542 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Nara, Alison,28364 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Zhou, Suzanne,12130 | 7987.91 | 0.00 | 0.00 | 5589.86 | 2398.05 |
| Collins, Gabriella, J,13592 | 9695.73 | 0.00 | 2443.35 | 0.00 | 7252.38 |
| Long, Justin,28010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Raje, Clayton, P,20888 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Zheng, Margaret, D,13823 | 5393.31 | 0.00 | 2443.35 | 0.00 | 2949.96 |
| Alonso, Paula, L,22692 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Rodriguez, Austin, J,18873 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Zhang, Todd,20590 | 3127.25 | 0.00 | 0.00 | 782.99 | 2344.26 |
| Howard, Chase, K,18892 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Washington, Jordan,27779 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Jaime, J,17470 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Xu, Valerie,23047 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Andersen, Alisha,25460 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gray, Kimberly, B,28100 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Deng, Darrell, A,25450 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Wilson, Alexandra,25195 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Sanchez, Joe, S,16552 | 4986.79 | 0.00 | 0.00 | 2443.35 | 2543.44 |
| Velez Amezaga, Elena,23737 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Simmons, Brandon,18946 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Phillips, Robert,27374 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ruiz, Dwayne, A,26323 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Thompson, Anna,27200 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Peterson, Abigail, L,23448 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Turner, Haley, M,11804 | 133.96 | 0.00 | 0.00 | 0.00 | 133.96 |
| Hu, Arturo, R,14663 | 104.95 | 0.00 | 0.00 | 0.00 | 104.95 |
| Collins, Thomas, C,20638 | 2478.24 | 0.00 | 0.00 | 0.00 | 2478.24 |
| Carter, Greg, G,15348 | 3198.45 | 0.00 | 0.00 | 782.99 | 2415.46 |
| Baker, Kaylee,11703 | 100.27 | 0.00 | 0.00 | 62.98 | 37.29 |
| Liang, Ernest, N,27122 | 786.33 | 0.00 | 0.00 | 0.00 | 786.33 |
| Lopez, Wyatt,20765 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Collins, Aaron, P,27663 | 6047.32 | 3578.27 | 0.00 | 0.00 | 2469.05 |
| Turner, Madeline,23845 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Bennett, Mya, M,18568 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Guo, Gilbert, H,17191 | 6895.61 | 0.00 | 0.00 | 2181.56 | 4714.05 |
| Suarez, Mathew,12279 | 2395.96 | 0.00 | 0.00 | 0.00 | 2395.96 |
| Butler, Madison,28242 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Price, Blake,27018 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Butler, Alyssa, L,23201 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Suarez, Jonathon, P,19944 | 3105.27 | 0.00 | 782.99 | 0.00 | 2322.28 |
| Hall, Savannah, K,21938 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zheng, Todd, J,15326 | 172.98 | 0.00 | 0.00 | 0.00 | 172.98 |
| Torres, Angel,21290 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Richardson, Shelby,16359 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Li, Ernest, L,23634 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Gomez, Leslie,17684 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kawai, Masato,25663 | 94.97 | 0.00 | 0.00 | 0.00 | 94.97 |
| Li, Dennis,14837 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Johnson, Joshua,20939 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Shan, Karl, J,11389 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Liang, Willie, M,19484 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Green, Jose, C,27320 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Powell, Luke, A,12175 | 155.00 | 0.00 | 0.00 | 0.00 | 155.00 |
| Lin, Martha,20678 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Edwards, Lucas, L,17572 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ramirez, Dalton, R,15256 | 1631.46 | 0.00 | 782.99 | 0.00 | 848.47 |
| Flores, James, V,13260 | 3661.29 | 0.00 | 0.00 | 751.34 | 2909.95 |
| Watson, Brianna,28812 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| She, Brad,12307 | 9594.92 | 0.00 | 0.00 | 2443.35 | 7151.57 |
| Murphy, Riley, J,23712 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Flores, Isabel,23715 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hughes, Gabrielle,23724 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Sanz, Casey,25534 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Jonathan, E,23837 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Wilson, Arthur,18762 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Cooper, Gabriella, L,18596 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Vance, Ronald,25459 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Lu, Steve,15351 | 3114.94 | 0.00 | 0.00 | 782.99 | 2331.95 |
Generated 2025-11-02 11:25:03.629 UTC