[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1250 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhang, Austin,19395 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Diaz, Theodore, D,11785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Mitchell, Jada,11851 | 84.99 | 0.00 | 0.00 | 0.00 | 84.99 |
| Harris, Katherine, B,15410 | 1619.90 | 0.00 | 0.00 | 782.99 | 836.91 |
| Russell, Tristan,25003 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Adams, Robert, Q,12901 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Ramirez, Catherine, E,28862 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gutierrez, Janet, M,18231 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Chen, Glenn, K,27134 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Phillips, Morgan,27617 | 5976.32 | 3578.27 | 0.00 | 0.00 | 2398.05 |
| Jones, Ryan,23580 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Johnson, Grace, M,18093 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Yang, Noah,26602 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Diaz, Dylan,25855 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Alonso, Monique,24842 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Diaz, Albert, A,12436 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Alvarez, Dana,15067 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Reed, Alexandra, C,27683 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Reed, Emma, H,21936 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Hu, Martha, C,13464 | 4501.55 | 0.00 | 0.00 | 2181.56 | 2319.99 |
| Morgan, Isaac,20408 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Xie, Devon, L,20099 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chandra, Frederick,27657 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Martin, Robert, C,13889 | 3084.02 | 0.00 | 0.00 | 2181.56 | 902.46 |
| Gonzalez, Toni, E,26575 | 2890.41 | 0.00 | 0.00 | 2049.10 | 841.31 |
| Hernandez, Jennifer,24436 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Patel, Evelyn, W,18033 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gray, Sean, L,16722 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Morgan, Paige, L,17826 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Kelly, Jared, J,19429 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Vazquez, Gary,11379 | 4426.06 | 0.00 | 0.00 | 2049.10 | 2376.96 |
| Garcia, Jasmine, A,22297 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Jai, Thomas,12904 | 5915.53 | 0.00 | 3578.27 | 0.00 | 2337.26 |
| Hernandez, Mary, D,17272 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Moore, Megan, I,23189 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Phillips, Mason,16915 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Jai, Austin, M,23188 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Rogers, Makayla,17141 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Jimenez, Kristy, E,23299 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Gao, Colin,18108 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Carter, Sara,18060 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Mitchell, Sophia,17949 | 2606.25 | 0.00 | 0.00 | 1819.92 | 786.33 |
| Sanz, Adrienne,16298 | 7000.87 | 0.00 | 0.00 | 2181.56 | 4819.31 |
| Richardson, Isabella, F,13933 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Price, Destiny,18983 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Rivera, Jessica, M,27542 | 4532.97 | 0.00 | 0.00 | 2071.42 | 2461.55 |
| Jones, Jasmine, J,13320 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Martinez, Austin,21292 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Navarro, Ruben,21010 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Young, Isaac,22340 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Perry, Devin,23709 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lee, Jessica,19636 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Diaz, Eric, R,18655 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Travers, Brooke,19406 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Ramirez, Christina, M,14288 | 3351.40 | 0.00 | 0.00 | 1000.44 | 2350.96 |
| Cooper, Michelle, L,17822 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Sara, Rachael,25652 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sai, Edgar,11879 | 107.42 | 0.00 | 0.00 | 0.00 | 107.42 |
| Hughes, Melanie, A,11985 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 |
| Diaz, Ian, D,11689 | 88.99 | 0.00 | 0.00 | 0.00 | 88.99 |
| Williams, Hannah, R,28104 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cooper, Haley,15897 | 3114.94 | 0.00 | 0.00 | 782.99 | 2331.95 |
| Chen, Austin, V,24190 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Wood, Morgan, M,18760 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Scott, Jordan, L,15535 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Johnson, Devin,15985 | 3179.95 | 0.00 | 0.00 | 782.99 | 2396.96 |
| Patterson, Richard, L,22011 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Collins, Eric, L,15275 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Jenkins, Julian,16099 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Alvarez, Victor,18022 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Kumar, Clarence,27120 | 1264.84 | 0.00 | 0.00 | 0.00 | 1264.84 |
| Pal, Tara,16395 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Collins, Elijah, L,18824 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Hayes, Mya, J,23168 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Diaz, Joe, L,27180 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Zhang, Luis, R,16811 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Anand, Terrence, J,16204 | 7162.39 | 0.00 | 0.00 | 2443.35 | 4719.04 |
| Bell, Brian, R,28603 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Kennedy, Sheena,25495 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Srini, Nancy, K,19329 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Sanchez, Tabitha, E,27408 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Turner, Jordan, C,11420 | 11200.77 | 0.00 | 0.00 | 4448.38 | 6752.39 |
| Brown, Olivia,11218 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 |
| Gomez, Tyrone, C,23297 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Patterson, Riley, S,18058 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yang, Samuel, R,15271 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Van, Arthur, A,12606 | 333.30 | 0.00 | 0.00 | 0.00 | 333.30 |
| Torres, Gerald, M,26954 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Jimenez, Sabrina,17995 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Yang, Lisa,24640 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Coleman, Eric, T,19138 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Carter, Wyatt,17429 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hill, Bailey, L,25767 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Gutierrez, Theodore, D,25409 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Ward, Cody,23166 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Davis, Kayla,16381 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Peterson, Brianna, W,16746 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Madan, Abby,19354 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Xu, Drew,20831 | 2012.95 | 0.00 | 0.00 | 782.99 | 1229.96 |
| Reed, Charles,14756 | 1588.57 | 0.00 | 699.10 | 0.00 | 889.47 |
| Smith, Xavier, M,21081 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Shan, Gilbert, B,22652 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Simmons, Devin, K,12102 | 5903.19 | 0.00 | 3578.27 | 0.00 | 2324.92 |
| Cooper, Kaitlyn, V,27801 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Edwards, Kevin, L,14734 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Brown, Taylor, R,26502 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Serrano, Melinda,25681 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Long, Tristan,27566 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Reed, Alexa, C,23685 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Parker, Jada, L,24233 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Howard, Garrett,18976 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Torres, Kaitlyn,18806 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Jones, Samuel, P,15896 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Anderson, Abigail, L,15249 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Gill, Joe,13766 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Alonso, Rebekah, H,14825 | 61.45 | 0.00 | 0.00 | 0.00 | 61.45 |
| Xu, Susan,17108 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Nath, Karla,22317 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Alvarez, Shannon,11551 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Henderson, Edward,27747 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Simmons, Rachel, E,16320 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Sanders, Mariah,13468 | 4626.52 | 0.00 | 0.00 | 2181.56 | 2444.96 |
| Martin, Emily, T,13487 | 4533.52 | 0.00 | 0.00 | 2181.56 | 2351.96 |
| Cook, Evan, H,18991 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-12-24 06:26:29.071 UTC