[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gomez, Craig, D,21672 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Cai, Christy, C,20936 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Liang, Cara, M,13515 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Gonzalez, Andre, L,25440 | 57.09 | 0.00 | 0.00 | 0.00 | 57.09 |
| Martinez, Barry, D,12621 | 6471.21 | 0.00 | 3578.27 | 0.00 | 2892.94 |
| Sanchez, Cindy, K,11288 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Ward, Patrick, J,21472 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Goel, Kelli, V,15496 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Marshall, M,13388 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Prasad, Janelle, M,15110 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ortega, Francis, F,19356 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Rivera, Melissa, S,28759 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Miller, Lauren,11532 | 44.57 | 0.00 | 0.00 | 0.00 | 44.57 |
| Shan, Caleb, A,15467 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Madan, Whitney,14942 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Subram, George, C,20974 | 126.28 | 0.00 | 0.00 | 0.00 | 126.28 |
| Harrison, Jamie,15155 | 3148.94 | 0.00 | 782.99 | 0.00 | 2365.95 |
| Cooper, Nathaniel,12079 | 6008.20 | 0.00 | 3578.27 | 0.00 | 2429.93 |
| Perez, Devin,11937 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Ramos, Lori, M,13559 | 2930.44 | 0.00 | 0.00 | 0.00 | 2930.44 |
| Martinez, Madison,22775 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Williams, Joseph, T,23714 | 44.54 | 0.00 | 0.00 | 0.00 | 44.54 |
| Clark, Edward, R,23888 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Walker, Cameron, M,22242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ward, Melanie, A,21432 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Alvarez, Eddie, A,13831 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Nath, Roger,19383 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Jones, Sarah, T,11718 | 100.27 | 0.00 | 0.00 | 0.00 | 100.27 |
| Clark, Tyler, A,12908 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Ferrier, Jerry, M,14730 | 2588.07 | 0.00 | 699.10 | 0.00 | 1888.97 |
| James, Jessica,19840 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Guo, Dennis,13735 | 4516.53 | 0.00 | 0.00 | 2181.56 | 2334.97 |
| Jackson, Jeremiah, A,18400 | 2409.95 | 0.00 | 0.00 | 0.00 | 2409.95 |
| Phillips, Bailey,11789 | 72.28 | 0.00 | 0.00 | 0.00 | 72.28 |
| Reed, Lauren, J,27016 | 41.93 | 0.00 | 0.00 | 0.00 | 41.93 |
| Ramirez, Jesse,15487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Jai, Dawn,15356 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Cooper, Alyssa, E,12171 | 5983.74 | 0.00 | 3578.27 | 0.00 | 2405.47 |
| Kumar, Dylan, D,24674 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Perry, Melanie,22372 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Navarro, Reginald,25674 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ramirez, Mackenzie, M,15116 | 7212.86 | 0.00 | 2443.35 | 0.00 | 4769.51 |
| Shen, Alejandro, J,15442 | 93.48 | 0.00 | 0.00 | 0.00 | 93.48 |
| Baker, Hunter, H,19719 | 659.94 | 0.00 | 0.00 | 0.00 | 659.94 |
| Madan, Shane,27006 | 750.30 | 0.00 | 0.00 | 0.00 | 750.30 |
| Kapoor, Tina,27118 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Bennett, Kelly,29221 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Cook, Nathaniel, G,17567 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Vance, Holly, S,27795 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Dominguez, Latasha, M,15086 | 6958.57 | 0.00 | 0.00 | 2181.56 | 4777.01 |
| Munoz, Naomi, L,11643 | 100.22 | 0.00 | 0.00 | 0.00 | 100.22 |
| Gray, Nicole,19018 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| James, Rachel,21077 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Navarro, Anne,22701 | 57.98 | 0.00 | 0.00 | 0.00 | 57.98 |
| Flores, Dalton,28238 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Garcia, Samuel,26528 | 128.47 | 0.00 | 0.00 | 0.00 | 128.47 |
| Turner, Isaac,19885 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Alonso, Craig, A,15495 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mr., Saunders, Lloyd, M.,14689 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Randy, J,21825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Erik, A,24124 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Lopez, Kaitlin, J,25807 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Reed, Makayla,25838 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| King, Luke,25934 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Reed, Jasmine,24967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Riley, J,23913 | 47.96 | 0.00 | 0.00 | 0.00 | 47.96 |
| Coleman, Gabriel, B,17706 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanders, Ariana, K,27525 | 182.78 | 0.00 | 0.00 | 0.00 | 182.78 |
| Evans, Jenna,17683 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patterson, Julia, V,14463 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Perez, Blake, M,11706 | 88.99 | 0.00 | 0.00 | 0.00 | 88.99 |
| Mitchell, Gabriel, J,26565 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Jackson, Eduardo, C,11749 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Walker, Thomas,13071 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Cox, Mackenzie, A,16757 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Howard, Brooke, D,26461 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Fernandez, Roy, S,15444 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Stewart, Angel, J,11235 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Howard, Anna, A,24957 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| James, Savannah,23265 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Davis, Megan, E,23183 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Brown, Natalie, T,18475 | 616.91 | 0.00 | 0.00 | 0.00 | 616.91 |
| Powell, Alexandria,22733 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Perry, Katherine, S,12386 | 4447.37 | 0.00 | 0.00 | 2071.42 | 2375.95 |
| Young, Miguel, D,23796 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Yang, Alisha,16266 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Hernandez, Seth, M,11856 | 133.96 | 0.00 | 0.00 | 0.00 | 133.96 |
| She, Yolanda, M,18304 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Hu, Jamie, C,26772 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Schmidt, Kristi, J,11733 | 194.98 | 0.00 | 0.00 | 0.00 | 194.98 |
| Torres, Robyn,25570 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Zhou, Sandra, B,28917 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Wilson, Sydney, L,17109 | 2769.40 | 0.00 | 0.00 | 1000.44 | 1768.96 |
| Nath, Alejandro, J,24866 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Ramirez, Eduardo,13939 | 3084.02 | 0.00 | 0.00 | 2181.56 | 902.46 |
| Patel, Carmen, M,21714 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Simmons, Victoria,21935 | 39.47 | 0.00 | 0.00 | 0.00 | 39.47 |
| Taylor, Elizabeth, P,21901 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Sanchez, Victoria,15306 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Diaz, Ross, E,16274 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Karen, L,18153 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cai, Laura, L,21113 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Nelson, Amanda,12788 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Zhu, Dennis, E,12966 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Hill, Sophia, C,14434 | 3396.40 | 0.00 | 0.00 | 1000.44 | 2395.96 |
| Kumar, Ethan,11662 | 100.27 | 0.00 | 0.00 | 0.00 | 100.27 |
| Watson, Garrett, R,19545 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Rivera, Christina, K,22521 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Adriana, L,12300 | 9664.43 | 0.00 | 0.00 | 2498.34 | 7166.09 |
| Jenkins, Alexandra, D,11632 | 77.48 | 0.00 | 0.00 | 0.00 | 77.48 |
| Gray, Eduardo, L,18364 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Ramirez, Paige,26580 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Martin, Noah, A,17657 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Baker, Edward,18507 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Thomas, Ashley, J,12188 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Alonso, Jacquelyn, A,27792 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Flores, Hannah,19525 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wang, Kelli,17939 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Dominguez, Tanya, N,13601 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Martinez, Allen,19386 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Turner, Gabriella, M,11645 | 153.46 | 0.00 | 0.00 | 0.00 | 153.46 |
| Hu, Stacey,12696 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Blue, Paige,21703 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Rodriguez, Taylor,16071 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
Generated 2025-12-23 05:00:21.482 UTC