[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 120 >
120 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Erik,27176 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Cox, Allison, L,14335 | 1804.92 | 0.00 | 0.00 | 1000.44 | 804.48 |
| Price, Anna,14576 | 1476.54 | 0.00 | 699.10 | 0.00 | 777.44 |
| Wright, Kaylee,24855 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Chandra, Tammy,12474 | 5928.25 | 0.00 | 3578.27 | 0.00 | 2349.98 |
| Chande, Brad, S,22430 | 2638.94 | 0.00 | 0.00 | 2638.94 | 0.00 |
| Wood, Elizabeth, D,26312 | 2881.74 | 0.00 | 0.00 | 2881.74 | 0.00 |
| Goel, Kate,21783 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Sanchez, Kristopher, D,17759 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rivera, Savannah,23182 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ma, Jaclyn,28890 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Patterson, Justin, M,14492 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chander, Jaime, L,19412 | 618.47 | 0.00 | 0.00 | 0.00 | 618.47 |
| Brooks, Mackenzie,24292 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Powell, Eduardo,22108 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Sai, Brenda, V,12393 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Ward, Cody,23166 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Nath, Cedric, C,17746 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Pal, Warren, S,25660 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Allen, Sara, H,17461 | 2406.95 | 0.00 | 0.00 | 0.00 | 2406.95 |
| Richardson, Amanda,15888 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 |
| Yang, Franklin,12139 | 102.93 | 0.00 | 0.00 | 0.00 | 102.93 |
| Carlson, Jésus,16059 | 146.97 | 0.00 | 0.00 | 0.00 | 146.97 |
| Flores, Benjamin,18025 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Goel, Jaime, W,22053 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Chen, Elijah,27272 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Alonso, Jill,27884 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Kelly, Cody,23697 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Davis, Michael, B,19671 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Xu, Carol, P,13580 | 3707.30 | 0.00 | 0.00 | 0.00 | 3707.30 |
| Edwards, Ian, A,29158 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Garcia, Jeremiah,26798 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Bell, Cody, A,12965 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Navarro, Marie, J,15338 | 1597.70 | 0.00 | 0.00 | 782.99 | 814.71 |
| Li, Jason,13729 | 4883.82 | 0.00 | 0.00 | 2443.35 | 2440.47 |
| Alexander, Megan,21837 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Peterson, Nicole,21385 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Butler, Gail,23977 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Evans, Kaitlyn,13452 | 4800.30 | 0.00 | 0.00 | 2443.35 | 2356.95 |
| Thomas, Michael, K,25183 | 82.59 | 0.00 | 0.00 | 0.00 | 82.59 |
| Howard, Jessica,23564 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Shan, Mindy, R,25117 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Price, Ashley, H,26087 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Cox, Destiny, M,13447 | 4533.52 | 0.00 | 0.00 | 2181.56 | 2351.96 |
| Reed, Jacqueline,14002 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Hughes, Abigail, T,19122 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Diaz, Darren,16327 | 4647.88 | 0.00 | 0.00 | 4647.88 | 0.00 |
| Guo, Alejandro,17799 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Sanchez, Eduardo,13715 | 2778.52 | 0.00 | 0.00 | 2181.56 | 596.96 |
| Thomas, Brandon, L,21770 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Flores, Melissa,23687 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Kapoor, Marie,12374 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Murphy, Abigail,27466 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Sun, Martha, V,26394 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Bryant, Paige, J,25915 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Zhou, Darryl, T,22834 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Martin, Natalie, M,20675 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Carter, Luke, M,14635 | 37.21 | 0.00 | 0.00 | 0.00 | 37.21 |
| Ross, Zachary,18406 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Brown, Alexis, A,27749 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Ruiz, Ebony,25683 | 1251.12 | 0.00 | 0.00 | 0.00 | 1251.12 |
| Diaz, Jonathan, K,13190 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Coleman, Eduardo,26818 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Richardson, Lucas,21144 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Thomas, Katherine,26536 | 4514.97 | 0.00 | 0.00 | 2071.42 | 2443.55 |
| Bailey, Emma, H,25044 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Cooper, Arianna,18340 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanchez, Ian, F,17399 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Jordan, Dominique, M,28502 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Suarez, Theodore,12817 | 5922.53 | 0.00 | 3578.27 | 0.00 | 2344.26 |
| Allen, Jeremy, J,25281 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Xie, Jerry,20081 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Bailey, Timothy, L,18456 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Torres, Evan,19543 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Ramirez, Xavier, G,25396 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Wang, Dennis, C,25318 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Cox, Kaylee,23800 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Rivera, María, R,19741 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Coleman, Jackson, S,27467 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Ross, Miguel, E,15405 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Zhang, Luke,18862 | 2354.47 | 0.00 | 0.00 | 0.00 | 2354.47 |
| Bennett, Isabella, K,17043 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Jai, Franklin, S,28886 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Travers, Savannah,28363 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Rodriguez, Samantha, E,21245 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Hall, Jonathan,12933 | 142.95 | 0.00 | 0.00 | 0.00 | 142.95 |
| Baker, Hunter, H,19719 | 659.94 | 0.00 | 0.00 | 0.00 | 659.94 |
| Ye, Margaret,28688 | 901.35 | 0.00 | 0.00 | 0.00 | 901.35 |
| Morgan, Patrick, A,23318 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Carter, Jordan, L,28669 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Miller, Robert, M,17872 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nelson, Kaylee, E,11680 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Price, Ana, E,11053 | 2329.98 | 0.00 | 0.00 | 2329.98 | 0.00 |
| Cook, Natalie,11707 | 6025.22 | 0.00 | 3578.27 | 0.00 | 2446.95 |
| Perry, Emma,21744 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gonzalez, Allison,11745 | 5948.23 | 0.00 | 3578.27 | 0.00 | 2369.96 |
| Moore, Charles,28172 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Reed, Maria,11208 | 134.23 | 0.00 | 0.00 | 0.00 | 134.23 |
| Zeng, Jessie,25091 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Romero, Krista,14956 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Thompson, Rachel, B,27108 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Suri, Gerald,13617 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Lewis, Julia,27213 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Butler, Kyle, B,14327 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Ruiz, Teresa,13666 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Jenkins, Lauren, S,14610 | 1468.59 | 0.00 | 699.10 | 0.00 | 769.49 |
| Tang, Tamara,28470 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Sharma, Cristina, J,20309 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Robinson, Dalton, M,21413 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Andersen, Andres,19492 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Raman, Gerald, V,22691 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Jackson, Seth, R,12520 | 5919.73 | 0.00 | 3578.27 | 0.00 | 2341.46 |
| Alexander, Fernando,17128 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Bailey, Jared,20647 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Patel, Adriana, L,29441 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Hayes, Noah, E,28994 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Suri, Kristina, J,22650 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Thomas, Jonathan, C,19777 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Romero, Kellie,24544 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Richardson, Hailey, W,15873 | 3123.93 | 0.00 | 0.00 | 782.99 | 2340.94 |
Generated 2025-12-22 04:34:45.882 UTC