[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Flores, María,17359 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Turner, Janet, M,17130 | 98.96 | 0.00 | 0.00 | 98.96 | 0.00 |
| Shen, Marshall, M,13388 | 106.96 | 0.00 | 0.00 | 106.96 | 0.00 |
| Edwards, Dalton, L,12173 | 5929.23 | 0.00 | 3578.27 | 2350.96 | 0.00 |
| Morris, Taylor, V,27207 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| King, Charles, L,28241 | 130.46 | 0.00 | 0.00 | 130.46 | 0.00 |
| Scott, Connor, R,21312 | 94.97 | 0.00 | 0.00 | 0.00 | 94.97 |
| Moore, Marcus, E,23360 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Walker, Cameron, M,22242 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Nelson, Eduardo, A,18591 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| 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 |
| Nath, Roger,19383 | 119.96 | 0.00 | 0.00 | 119.96 | 0.00 |
| Sara, Harold, S,22697 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Jones, Sarah, T,11718 | 100.27 | 0.00 | 0.00 | 100.27 | 0.00 |
| 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 |
| Kelly, Steven, M,12151 | 5895.24 | 0.00 | 3578.27 | 2316.97 | 0.00 |
| Huang, Stacey,25443 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Serrano, Teresa,20759 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Zhou, Aimee, M,20729 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Jones, Grace,11853 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 |
| Reed, Angela, K,20190 | 1204.46 | 0.00 | 0.00 | 0.00 | 1204.46 |
| Phillips, Bailey,11789 | 72.28 | 0.00 | 0.00 | 34.99 | 37.29 |
| Goel, Darrell,27772 | 123.48 | 0.00 | 0.00 | 123.48 | 0.00 |
| Ramirez, Mackenzie, M,15116 | 7212.86 | 0.00 | 2443.35 | 2428.05 | 2341.46 |
| Moreno, Billy,11572 | 4450.37 | 0.00 | 0.00 | 4450.37 | 0.00 |
| 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 |
| Pal, Ricardo, J,16001 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Patterson, Julia, V,14463 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Kim, Meagan,14842 | 99.94 | 0.00 | 0.00 | 99.94 | 0.00 |
| Gutierrez, Andy,12798 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Diaz, Arthur,19460 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Romero, Kellie,24544 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Wright, Lucas,14271 | 21.98 | 0.00 | 0.00 | 21.98 | 0.00 |
| Xie, Kenneth, J,13842 | 826.46 | 0.00 | 0.00 | 0.00 | 826.46 |
| Torres, Cody,11687 | 97.98 | 0.00 | 0.00 | 0.00 | 97.98 |
| Watson, Katelyn, B,21477 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Jai, Ricardo,14373 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Butler, Angelica,16556 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Yang, Clayton, C,25145 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Jenkins, Kaitlyn, R,14298 | 3365.67 | 0.00 | 0.00 | 1000.44 | 2365.23 |
| Morris, Dalton,23178 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hall, James,27202 | 96.92 | 0.00 | 0.00 | 96.92 | 0.00 |
| Goel, Clarence,17189 | 46.47 | 0.00 | 0.00 | 46.47 | 0.00 |
| Sun, Wesley,24863 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Nath, Alejandro, J,24866 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Sharma, Rafael, B,12200 | 5935.55 | 0.00 | 3578.27 | 2357.28 | 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 |
| Gonzalez, Adriana, L,12300 | 9664.43 | 0.00 | 0.00 | 4891.40 | 4773.03 |
| Garcia, Bryant,11431 | 9912.98 | 0.00 | 3399.99 | 2364.98 | 4148.01 |
| Gray, Eduardo, L,18364 | 124.99 | 0.00 | 0.00 | 124.99 | 0.00 |
| Alexander, Sydney,16760 | 67.97 | 0.00 | 0.00 | 67.97 | 0.00 |
| Liang, Rafael, R,14935 | 29.93 | 0.00 | 0.00 | 29.93 | 0.00 |
| Rana, Erick, C,19679 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Ross, Jessica,14880 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Dominguez, Kari, S,17789 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Hayes, Justin, V,24965 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Dominguez, Briana,11561 | 4344.09 | 0.00 | 2049.10 | 2294.99 | 0.00 |
| Ortega, Diana,12125 | 8595.41 | 0.00 | 0.00 | 4441.38 | 4154.03 |
| Wilson, Joshua, A,28606 | 7.95 | 0.00 | 0.00 | 7.95 | 0.00 |
| Morgan, Rachel,27463 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Wood, Tristan, M,21915 | 570.47 | 0.00 | 0.00 | 570.47 | 0.00 |
| Rana, Jay,19421 | 1930.76 | 0.00 | 0.00 | 1930.76 | 0.00 |
| Wang, Jack, L,17152 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Brooks, Olivia,18665 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Scott, Madeline,23125 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Zheng, Ramon, R,28393 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Griffin, Emily,19657 | 756.26 | 0.00 | 0.00 | 0.00 | 756.26 |
| Gonzales, Elijah, A,13999 | 3295.43 | 0.00 | 1000.44 | 0.00 | 2294.99 |
| Long, Miranda,11777 | 5915.53 | 0.00 | 3578.27 | 0.00 | 2337.26 |
| Young, Gabriel, C,25401 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Rivera, Olivia, N,17669 | 624.95 | 0.00 | 0.00 | 0.00 | 624.95 |
| Morgan, Dalton, L,11814 | 101.26 | 0.00 | 0.00 | 0.00 | 101.26 |
| Yang, Robert,24298 | 86.58 | 0.00 | 0.00 | 86.58 | 0.00 |
| Green, Edward, C,26081 | 64.97 | 0.00 | 0.00 | 64.97 | 0.00 |
| Morgan, Katherine, V,22736 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Morris, Jesse,21688 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Rivera, Jeremy,16978 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| White, Nathan, G,22361 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Suri, Meredith,21058 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Howard, Patrick, L,12797 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| She, Mario,11407 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Rubio, Dana,19311 | 4640.26 | 0.00 | 0.00 | 1000.44 | 3639.82 |
| Price, Maria,19423 | 1938.47 | 0.00 | 0.00 | 1938.47 | 0.00 |
| Rodriguez, Lauren,27037 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Rana, Denise, S,14519 | 80.96 | 0.00 | 0.00 | 80.96 | 0.00 |
| Sharma, Peter,23600 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Lopez, Tina, J,24219 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Miller, Tyler, E,11940 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Evans, Eduardo,23288 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gonzalez, Sydney,18915 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Wilson, Christopher, E,16014 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Ebony,17797 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Stone, Megan, L,13313 | 76.97 | 0.00 | 0.00 | 76.97 | 0.00 |
| Evans, Andrea,26465 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Chapman, Katrina,23897 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Walker, Alexis,20291 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Ortega, Marc, C,22644 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Thomas, Daniel,24262 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Zimmerman, Henry,22192 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Rivera, Lauren, C,21317 | 108.95 | 0.00 | 0.00 | 0.00 | 108.95 |
| Cox, Riley, S,24345 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Sanchez, Dominic,21072 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Powell, Nathan,28460 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Luo, Yolanda,13945 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Diaz, Isabella, H,20559 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Sanders, Patrick, L,14444 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Powell, Logan, H,13761 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Sanders, Christina,22310 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Wang, Louis, J,22507 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Suri, Geoffrey,26419 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Chen, Margaret, F,27941 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Miller, Christopher,12377 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Pearson, Simon,13472 | 2518.98 | 0.00 | 0.00 | 0.00 | 2518.98 |
| Chander, Carly, C,26961 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Bradley, Amanda,25289 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Bradley, Lucas, P,25397 | 2427.04 | 0.00 | 0.00 | 0.00 | 2427.04 |
| Walker, Nicholas, O,23699 | 1274.33 | 0.00 | 0.00 | 0.00 | 1274.33 |
Generated 2025-11-04 04:39:20.879 UTC