[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Anand, Colin, G,27645 | 6051.31 | 3578.27 | 0.00 | 0.00 | 2473.04 |
| Anderson, William, L,23707 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Gomez, Dwayne,12295 | 174.17 | 0.00 | 0.00 | 45.22 | 128.95 |
| Cook, Cody, K,12450 | 5955.23 | 0.00 | 3578.27 | 0.00 | 2376.96 |
| Suarez, Erik, W,15194 | 3173.94 | 0.00 | 782.99 | 0.00 | 2390.95 |
| Ye, Tiffany, K,23326 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Fernandez, Marco,24701 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Zhang, Caleb,12863 | 4478.35 | 0.00 | 0.00 | 2071.42 | 2406.93 |
| Alexander, Isabella,27555 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Prasad, Dominique, L,11432 | 9330.20 | 0.00 | 0.00 | 4401.40 | 4928.80 |
| Gonzales, Caroline,27576 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Bailey, Abigail, E,27531 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Sai, Joel,11571 | 4390.68 | 0.00 | 0.00 | 4390.68 | 0.00 |
| Arun, Bruce, T,21037 | 2438.28 | 0.00 | 0.00 | 782.99 | 1655.29 |
| Lopez, Marco,11429 | 10468.38 | 0.00 | 0.00 | 4401.40 | 6066.98 |
| Zhu, Micah, V,11576 | 4486.41 | 0.00 | 0.00 | 4486.41 | 0.00 |
| Price, Elizabeth, J,14464 | 3357.72 | 0.00 | 0.00 | 1000.44 | 2357.28 |
| West, Jordyn, J,27554 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Srini, Barry,17932 | 2765.40 | 0.00 | 0.00 | 1000.44 | 1764.96 |
| Gonzalez, Edward,15968 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Kumar, Kevin,27459 | 4552.13 | 0.00 | 0.00 | 2049.10 | 2503.03 |
| Stewart, Bailey, J,14485 | 3312.70 | 0.00 | 0.00 | 1000.44 | 2312.26 |
| Diaz, Nathan,14495 | 1839.92 | 0.00 | 0.00 | 1000.44 | 839.48 |
| Martin, Kayla, E,27523 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Edwards, Richard, P,17135 | 2379.47 | 0.00 | 0.00 | 0.00 | 2379.47 |
| Arun, Shane,27784 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Russell, Julian, M,28585 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Martinez, Gerald,21433 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Washington, Nicole,26093 | 4657.81 | 0.00 | 3374.99 | 0.00 | 1282.82 |
| Richardson, Ariana, B,18847 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Arun, George, J,14763 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carter, James,14257 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Ramos, Jacquelyn, Y,17836 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Watson, Carlos,23855 | 624.46 | 0.00 | 0.00 | 0.00 | 624.46 |
| Ruiz, Gary,21097 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Raje, Dustin,16323 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ruiz, Dana, M,14819 | 4355.71 | 0.00 | 3578.27 | 0.00 | 777.44 |
| Hill, Morgan, M,11320 | 72.21 | 0.00 | 0.00 | 0.00 | 72.21 |
| Lal, Sharon, L,17891 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Suri, Denise, C,27524 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Beck, Brendan,17952 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Goel, Sheena,12833 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Ma, Colleen, A,11480 | 4935.36 | 0.00 | 0.00 | 4381.39 | 553.97 |
| Carlson, Walter,19943 | 3112.97 | 0.00 | 0.00 | 782.99 | 2329.98 |
| Johnson, Devin,15985 | 3179.95 | 0.00 | 0.00 | 782.99 | 2396.96 |
| Diaz, Natalie, L,14472 | 3503.70 | 0.00 | 0.00 | 1000.44 | 2503.26 |
| Alexander, Isabelle, L,15992 | 3194.93 | 0.00 | 0.00 | 782.99 | 2411.94 |
| Raji, Johnny, S,12850 | 4406.39 | 0.00 | 0.00 | 2071.42 | 2334.97 |
| Chande, Brad, S,22430 | 2638.94 | 0.00 | 0.00 | 2638.94 | 0.00 |
| Ross, Emily, A,20639 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Kelly, Brooke,19808 | 589.98 | 0.00 | 0.00 | 0.00 | 589.98 |
| Campbell, Sydney,13465 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Gutierrez, Felicia, E,17817 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Washington, Lucas, B,17524 | 2316.97 | 0.00 | 0.00 | 0.00 | 2316.97 |
| Young, Dalton, R,18954 | 893.47 | 0.00 | 0.00 | 0.00 | 893.47 |
| Bryant, Trevor,11090 | 6704.08 | 0.00 | 3578.27 | 2374.47 | 751.34 |
| Munoz, Rebekah,28396 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| James, Destiny, A,11788 | 255.27 | 0.00 | 0.00 | 0.00 | 255.27 |
| Nath, Kelvin, M,26791 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Jimenez, Gerald, E,23963 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Smith, Cameron, M,13589 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Simmons, Eric, M,14643 | 1613.06 | 0.00 | 699.10 | 0.00 | 913.96 |
| Allen, Isaac, J,22261 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Cox, Jasmine,25086 | 1308.31 | 0.00 | 0.00 | 1308.31 | 0.00 |
| Romero, Kendra,26826 | 1237.82 | 0.00 | 0.00 | 1237.82 | 0.00 |
| Hernandez, Xavier,21746 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Hayes, Connor,27626 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Davis, Anna, K,23720 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Perry, Brianna, W,18230 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| McDonald, Elijah,18911 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Beck, Bethany, H,16312 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Wood, Paige, C,19376 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| 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 |
| Ward, Mason,23840 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Taylor, Thomas,23493 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Howard, Sydney,21644 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Kumar, Brendan,13769 | 5085.53 | 0.00 | 2181.56 | 0.00 | 2903.97 |
| Martin, Jessica, S,14822 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Bell, Alexa, R,21600 | 563.77 | 0.00 | 0.00 | 563.77 | 0.00 |
| Watson, Jeremy, A,19225 | 1218.98 | 0.00 | 0.00 | 1218.98 | 0.00 |
| Patel, Cindy, A,11249 | 9890.27 | 0.00 | 3399.99 | 2309.97 | 4180.31 |
| Jones, Elizabeth, P,11265 | 2351.96 | 0.00 | 0.00 | 2351.96 | 0.00 |
| Ramirez, Zoe, R,11710 | 97.98 | 0.00 | 0.00 | 0.00 | 97.98 |
| Jones, Edward,28075 | 88.42 | 0.00 | 0.00 | 0.00 | 88.42 |
| Martin, Nicole, I,21933 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Young, James, M,20531 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Young, Richard, C,18115 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Nath, Mitchell, W,17452 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Williams, Daniel, S,17517 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanchez, Cindy, K,11288 | 77.27 | 0.00 | 0.00 | 2.29 | 74.98 |
| Lee, Christopher, M,23090 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Vance, Joel,27766 | 827.33 | 0.00 | 0.00 | 827.33 | 0.00 |
| Ward, Chloe, L,24425 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Diaz, Casey, S,29356 | 628.97 | 0.00 | 0.00 | 628.97 | 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 |
| Collins, Gabriel, L,16983 | 2357.28 | 0.00 | 0.00 | 0.00 | 2357.28 |
| Serrano, Nelson,26354 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Alexander, Alexis, L,27476 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Diaz, Carson,16813 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Thompson, Chloe, M,15743 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Ramon, T,25543 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Rogers, Ariana, F,11486 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Clark, Thomas, M,21439 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Shan, Julie, M,13789 | 819.48 | 0.00 | 0.00 | 819.48 | 0.00 |
| Jackson, Emily,25092 | 1257.82 | 0.00 | 0.00 | 1257.82 | 0.00 |
| Anderson, Miguel,19393 | 1134.47 | 0.00 | 0.00 | 1134.47 | 0.00 |
| Phillips, Natalie,22415 | 615.47 | 0.00 | 0.00 | 615.47 | 0.00 |
| 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 |
| Collins, Miguel,17362 | 2309.97 | 0.00 | 0.00 | 0.00 | 2309.97 |
| Gonzales, Alexandra, M,23844 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Thomas, Alyssa, L,20894 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Munoz, Dwayne, F,24091 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Reed, Evan, V,16797 | 1732.26 | 0.00 | 0.00 | 1732.26 | 0.00 |
| Wu, Eugene, P,22414 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Walker, Megan, G,11154 | 2319.99 | 0.00 | 0.00 | 2319.99 | 0.00 |
| Ruiz, Erik, S,25613 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Moreno, Mathew,26090 | 5819.05 | 0.00 | 3399.99 | 0.00 | 2419.06 |
Generated 2025-11-03 21:42:54.521 UTC