[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Peterson, Mary,19219 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lopez, Denise, K,15480 | 3077.98 | 0.00 | 0.00 | 782.99 | 2294.99 |
| Collins, Jack, J,25887 | 4673.31 | 3399.99 | 0.00 | 0.00 | 1273.32 |
| Zhang, Alisha, G,28394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Martinez, Lauren, L,11272 | 5975.23 | 0.00 | 3578.27 | 2396.96 | 0.00 |
| Scott, Fernando, C,22254 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Morgan, Kaylee,21300 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Raji, Roger, M,22436 | 607.96 | 0.00 | 0.00 | 607.96 | 0.00 |
| Ye, Mandy,19475 | 1394.93 | 0.00 | 0.00 | 1394.93 | 0.00 |
| Perez, Chelsea, K,22393 | 588.96 | 0.00 | 0.00 | 588.96 | 0.00 |
| Suri, Sergio, C,16391 | 4624.91 | 0.00 | 0.00 | 4624.91 | 0.00 |
| Sanchez, Cindy, K,11288 | 77.27 | 0.00 | 0.00 | 2.29 | 74.98 |
| Martinez, Dylan, M,26319 | 4456.14 | 0.00 | 2049.10 | 0.00 | 2407.04 |
| Zhou, Susan,15678 | 7223.34 | 0.00 | 0.00 | 2443.35 | 4779.99 |
| Lee, Christopher, M,23090 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Young, Chloe,11015 | 2500.97 | 0.00 | 0.00 | 2500.97 | 0.00 |
| Andersen, Mario, J,20977 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Wright, Jenna,11291 | 5873.26 | 0.00 | 3578.27 | 2294.99 | 0.00 |
| Gonzalez, Adriana, L,12300 | 9664.43 | 0.00 | 0.00 | 4891.40 | 4773.03 |
| Griffin, Hunter, D,11286 | 5954.22 | 0.00 | 3578.27 | 2375.95 | 0.00 |
| Ramirez, Amanda, E,15017 | 1307.06 | 0.00 | 699.10 | 607.96 | 0.00 |
| Lewis, Anthony,18672 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Morris, Zoe, J,15541 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Guo, Todd, K,12732 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zhao, Wesley, M,24580 | 596.96 | 0.00 | 0.00 | 0.00 | 596.96 |
| Wood, Alexis, A,13985 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Vance, Edgar,19351 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Travers, Garrett,11836 | 69.99 | 0.00 | 0.00 | 34.99 | 35.00 |
| White, Jacob, K,12015 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Martinez, Michael, B,19983 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Deng, Ashlee,14791 | 7210.85 | 0.00 | 0.00 | 2443.35 | 4767.50 |
| Pal, Shawna, W,24723 | 1793.47 | 0.00 | 0.00 | 0.00 | 1793.47 |
| Rodriguez, Ryan, M,26492 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Gonzales, Miguel,17335 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suri, Darren,17964 | 5750.36 | 0.00 | 0.00 | 3396.41 | 2353.95 |
| Gutierrez, Joe,26227 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Thomas, Anna, R,14624 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Fernandez, Rebekah,23970 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Bryant, Katherine, A,11517 | 101.76 | 0.00 | 0.00 | 0.00 | 101.76 |
| Jackson, Logan, D,21751 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Wright, Luis,18761 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Bryant, Maria, E,26370 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Robinson, Christopher, A,12767 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Lal, Lindsey, H,16291 | 4921.69 | 0.00 | 0.00 | 4921.69 | 0.00 |
| Jimenez, Theresa, W,19240 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Butler, Angela, L,11082 | 3110.81 | 0.00 | 0.00 | 2329.99 | 780.82 |
| Munoz, Janet,11439 | 12489.17 | 0.00 | 0.00 | 10070.11 | 2419.06 |
| Andersen, Alvin, C,13744 | 2959.00 | 0.00 | 0.00 | 2959.00 | 0.00 |
| Martinez, Chelsea, S,14927 | 4190.23 | 0.00 | 3578.27 | 611.96 | 0.00 |
| Chandra, Jay,15411 | 3127.95 | 0.00 | 0.00 | 782.99 | 2344.96 |
| Ruiz, Erik, S,25613 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Dominguez, Latasha, M,15086 | 6958.57 | 0.00 | 0.00 | 2181.56 | 4777.01 |
| Moreno, Mathew,26090 | 5819.05 | 0.00 | 3399.99 | 0.00 | 2419.06 |
| Huang, Roger, L,13778 | 819.48 | 0.00 | 0.00 | 819.48 | 0.00 |
| King, Katherine, A,20750 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| She, Dennis, M,11339 | 4379.08 | 0.00 | 0.00 | 4379.08 | 0.00 |
| Srini, Barry,17932 | 2765.40 | 0.00 | 0.00 | 1000.44 | 1764.96 |
| Gutierrez, Jacquelyn, C,12384 | 5056.53 | 0.00 | 0.00 | 4478.07 | 578.46 |
| Arun, Bruce, T,21037 | 2438.28 | 0.00 | 0.00 | 782.99 | 1655.29 |
| Gao, Willie, R,14154 | 3018.00 | 0.00 | 2181.56 | 0.00 | 836.44 |
| Coleman, Jasmine, L,11145 | 2309.97 | 0.00 | 0.00 | 2309.97 | 0.00 |
| Peterson, Devin, M,29210 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Gonzales, Benjamin,21576 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Miller, Thomas, J,17408 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moore, Zachary, S,11625 | 5913.25 | 0.00 | 3578.27 | 0.00 | 2334.98 |
| Lan, Andrew, L,28011 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jones, Anna, A,29045 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Hughes, Jordyn,24440 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Xu, Dale,26382 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Sanz, Jerome,28538 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Goel, Donna, H,29430 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Perez, Rebecca, H,19813 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Taylor, Anna, D,23028 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Brooks, Morgan, J,15548 | 1337.96 | 0.00 | 0.00 | 1337.96 | 0.00 |
| Sanchez, Alyssa,20037 | 2595.95 | 0.00 | 0.00 | 2595.95 | 0.00 |
| Martin, Gary, L,20793 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Sanchez, Katelyn,11290 | 5933.25 | 0.00 | 3578.27 | 2354.98 | 0.00 |
| Bryant, Trevor,11090 | 6704.08 | 0.00 | 3578.27 | 2374.47 | 751.34 |
| Stone, Karl, L,16451 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Bennett, Taylor, L,28972 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Jimenez, Jamie,26825 | 1228.83 | 0.00 | 0.00 | 1228.83 | 0.00 |
| Gutierrez, Briana, J,24442 | 82.59 | 0.00 | 0.00 | 0.00 | 82.59 |
| Lopez, Jesse,27659 | 75.48 | 0.00 | 0.00 | 75.48 | 0.00 |
| Allen, Alex,19663 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Li, Adam,16985 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Yang, Sandra,23962 | 28.99 | 0.00 | 0.00 | 28.99 | 0.00 |
| Sanchez, Holly,14329 | 91.95 | 0.00 | 0.00 | 91.95 | 0.00 |
| Sanz, Kristy,22284 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Clark, Grace, L,12098 | 83.97 | 0.00 | 0.00 | 8.99 | 74.98 |
| Mitchell, Rebecca, M,12424 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Raji, Keith,15500 | 3153.95 | 0.00 | 0.00 | 782.99 | 2370.96 |
| Huang, Edwin,15195 | 3154.95 | 0.00 | 782.99 | 0.00 | 2371.96 |
| Adams, Alex, C,21139 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Wang, Glenn, R,17220 | 6914.85 | 0.00 | 0.00 | 2181.56 | 4733.29 |
| Wood, Brianna,26519 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Roberts, Devin, B,21718 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Green, Jordan, P,21578 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Hayes, Angela,21325 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Anand, Kenneth, L,22513 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Edwards, Luke, C,11686 | 128.97 | 0.00 | 0.00 | 53.99 | 74.98 |
| Sanchez, Ariana, C,11654 | 5955.23 | 0.00 | 3578.27 | 0.00 | 2376.96 |
| Smith, Ryan, C,11624 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Bryant, Antonio, R,13016 | 4813.32 | 0.00 | 2443.35 | 0.00 | 2369.97 |
| Butler, Jordyn,13083 | 4532.52 | 0.00 | 2181.56 | 0.00 | 2350.96 |
| Dominguez, Monique, C,22778 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Perez, Caleb,12943 | 105.95 | 0.00 | 0.00 | 0.00 | 105.95 |
| Chen, Dylan,16781 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Raman, Pedro, C,16041 | 64.97 | 0.00 | 0.00 | 64.97 | 0.00 |
| Alonso, Gerald,20958 | 68.49 | 0.00 | 0.00 | 68.49 | 0.00 |
| Allen, Sophia,20183 | 2451.30 | 0.00 | 0.00 | 2451.30 | 0.00 |
| Richardson, Haley,11296 | 5897.53 | 0.00 | 3578.27 | 2319.26 | 0.00 |
| Suarez, Micheal,24063 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Kumar, Nina, L,12807 | 5024.86 | 0.00 | 0.00 | 4484.87 | 539.99 |
| Murphy, Cole,27066 | 33.98 | 0.00 | 0.00 | 33.98 | 0.00 |
| Lopez, Eric,16227 | 80.96 | 0.00 | 0.00 | 80.96 | 0.00 |
| Chander, Johnny,27935 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Edwards, Thomas, C,15517 | 3112.98 | 0.00 | 0.00 | 782.99 | 2329.99 |
| Wilson, Julia,15396 | 3147.95 | 0.00 | 0.00 | 782.99 | 2364.96 |
| Murphy, Mackenzie, J,15399 | 3148.22 | 0.00 | 0.00 | 782.99 | 2365.23 |
| Johnson, Thomas, C,22593 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Wang, Heather, R,12499 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| James, Kaitlyn, I,15562 | 1347.97 | 0.00 | 0.00 | 1347.97 | 0.00 |
| Lal, Brandon,13883 | 3021.04 | 0.00 | 0.00 | 3021.04 | 0.00 |
| Gao, Cedric, A,12053 | 5973.24 | 0.00 | 3578.27 | 2394.97 | 0.00 |
| Flores, James, V,13260 | 3661.29 | 0.00 | 0.00 | 751.34 | 2909.95 |
Generated 2025-11-03 15:18:35.691 UTC