[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Garcia, David,22683 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Patel, Kristopher,15976 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Ye, Jorge, R,16426 | 5768.36 | 0.00 | 0.00 | 2181.56 | 3586.80 |
| Lopez, Devin,24492 | 791.32 | 0.00 | 0.00 | 791.32 | 0.00 |
| Kelly, Abigail, A,26609 | 4509.48 | 0.00 | 0.00 | 2071.42 | 2438.06 |
| Campbell, Isaiah,20405 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Sara, Francisco, A,12296 | 9586.37 | 0.00 | 0.00 | 4884.34 | 4702.03 |
| Gill, Andy,22673 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Torres, Jesse, S,25181 | 32.60 | 0.00 | 0.00 | 32.60 | 0.00 |
| Nelson, Nathan,22742 | 71.94 | 0.00 | 0.00 | 71.94 | 0.00 |
| Shan, Maurice, M,11433 | 12909.67 | 0.00 | 0.00 | 6934.48 | 5975.19 |
| Watson, Gabriella, D,22333 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Patterson, Trevor, J,21158 | 49.97 | 0.00 | 0.00 | 49.97 | 0.00 |
| Ruiz, Jerome, J,21549 | 98.96 | 0.00 | 0.00 | 98.96 | 0.00 |
| Stewart, Angela,13301 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Chandra, Ruth,16208 | 119.96 | 0.00 | 0.00 | 119.96 | 0.00 |
| Taylor, Ethan,22555 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Narayanan, Sriniwa, J,15862 | 1379.95 | 0.00 | 0.00 | 1379.95 | 0.00 |
| Gonzales, Justin,12190 | 5890.53 | 0.00 | 3578.27 | 2312.26 | 0.00 |
| Richardson, Amanda,15888 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 |
| Bailey, Kaitlyn, M,12153 | 5938.23 | 0.00 | 3578.27 | 2359.96 | 0.00 |
| Arun, Phillip, A,27133 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Roberts, Julia, M,21942 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Miller, Wyatt, M,26703 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Zhou, Suzanne,12130 | 7987.91 | 0.00 | 0.00 | 5589.86 | 2398.05 |
| Hill, Isabella, P,27310 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Martinez, Barry, D,12621 | 6471.21 | 0.00 | 3578.27 | 2329.98 | 562.96 |
| Wright, Sydney, S,25863 | 4631.11 | 3399.99 | 0.00 | 0.00 | 1231.12 |
| Bailey, Kaylee,29224 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Wu, Karen,21353 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Murphy, Isabella,22645 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Young, Mary, C,17689 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Joy, G,26469 | 64.97 | 0.00 | 0.00 | 64.97 | 0.00 |
| Roberts, Chloe,14913 | 1533.56 | 0.00 | 699.10 | 0.00 | 834.46 |
| Gray, Ariana, D,11425 | 10528.63 | 0.00 | 0.00 | 4551.06 | 5977.57 |
| Xu, Bonnie, C,14520 | 1503.58 | 699.10 | 0.00 | 0.00 | 804.48 |
| Walker, Joshua, W,20732 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Huang, Kelvin,14560 | 1538.58 | 699.10 | 0.00 | 0.00 | 839.48 |
| Winston, Isabelle, C,18577 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Nath, Tracy, B,16507 | 35.23 | 0.00 | 0.00 | 0.00 | 35.23 |
| Phillips, Carlos, D,27750 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Blanco, Nelson,23718 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Bell, Jeremy, F,26525 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Butler, Tristan,25865 | 4643.83 | 3374.99 | 0.00 | 0.00 | 1268.84 |
| Goel, Kelli, V,15496 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Salah, Tamer, A,12636 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Lewis, Megan, L,24524 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Zheng, Bianca, G,27662 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Black, Melvin,12429 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Perry, Tristan, G,25866 | 4603.82 | 3374.99 | 0.00 | 0.00 | 1228.83 |
| Cooper, Xavier,20185 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Murphy, Jeremy,27651 | 6021.82 | 3578.27 | 0.00 | 0.00 | 2443.55 |
| Long, Jessica, R,16808 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Collins, Aaron, P,27663 | 6047.32 | 3578.27 | 0.00 | 0.00 | 2469.05 |
| Gray, Carlos,11781 | 134.46 | 0.00 | 0.00 | 59.48 | 74.98 |
| Truempy, Marcel,14558 | 1528.07 | 699.10 | 0.00 | 0.00 | 828.97 |
| Goel, Shaun, L,22417 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Young, Jennifer, M,27673 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Long, Jocelyn,12886 | 5965.22 | 0.00 | 3578.27 | 0.00 | 2386.95 |
| Foster, Rachel,28018 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| West, Elizabeth,26604 | 4442.16 | 0.00 | 0.00 | 2049.10 | 2393.06 |
| King, Isabella, E,27922 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Young, Madeline,18121 | 1793.47 | 0.00 | 0.00 | 0.00 | 1793.47 |
| Hernandez, Natalie, L,14565 | 1503.58 | 699.10 | 0.00 | 0.00 | 804.48 |
| Young, Kyle, T,20847 | 1947.46 | 0.00 | 0.00 | 782.99 | 1164.47 |
| Brown, Brandon, E,14400 | 3357.40 | 0.00 | 0.00 | 1000.44 | 2356.96 |
| Moreno, Jaime,20870 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Mehta, Joe,17679 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nath, Wayne,12468 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Martin, Christopher, B,28017 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Martinez, Adriana, S,15457 | 2781.54 | 0.00 | 2181.56 | 0.00 | 599.98 |
| Mohamed, Xavier, D,23195 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Fernandez, Johnathan,25144 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Morris, Ian, A,28070 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Jai, Arturo, T,24180 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Foster, Kaitlyn, M,28083 | 5962.34 | 3578.27 | 0.00 | 0.00 | 2384.07 |
| Allen, Seth, M,12946 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Ross, Melanie, H,25872 | 5819.05 | 3399.99 | 0.00 | 0.00 | 2419.06 |
| Raman, Barry, A,24783 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Jackson, Olivia,27681 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Huang, Aimee,23160 | 673.97 | 0.00 | 0.00 | 0.00 | 673.97 |
| Rogers, Katherine, B,20395 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Thomas, Emma, J,18904 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Russell, Trevor,16719 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hernandez, Stephanie, V,21235 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Sanchez, Jay, W,28047 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Turner, Angel, L,16278 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Ross, Samantha, R,27918 | 5998.61 | 3578.27 | 0.00 | 0.00 | 2420.34 |
| Wang, Jackson, S,18977 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Walker, Natalie,12894 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Griffin, Julia, R,18550 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Lopez, Kyle,28061 | 6006.32 | 3578.27 | 0.00 | 0.00 | 2428.05 |
| Cook, Jasmine, C,14408 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Shan, April, L,11566 | 1006.83 | 0.00 | 0.00 | 308.01 | 698.82 |
| Martinez, Ashley,11166 | 87.96 | 0.00 | 0.00 | 0.00 | 87.96 |
| Turner, Jordan, C,11420 | 11200.77 | 0.00 | 0.00 | 4448.38 | 6752.39 |
| Harris, Anna, L,13298 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| She, Alejandro, H,17873 | 4203.32 | 0.00 | 0.00 | 2443.35 | 1759.97 |
| Wilson, Kaitlyn,11691 | 119.96 | 0.00 | 0.00 | 65.97 | 53.99 |
| Young, Jack, L,28078 | 6011.31 | 3578.27 | 0.00 | 0.00 | 2433.04 |
| Subram, Carolyn,26052 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Lewis, Jessica, W,25868 | 5798.04 | 3399.99 | 0.00 | 0.00 | 2398.05 |
| Zhao, Lisa, C,19859 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Navarro, Craig,15357 | 7232.37 | 0.00 | 2443.35 | 0.00 | 4789.02 |
| James, Jared, M,15504 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Watson, Alexa,12517 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Wang, Sandra,24878 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Harris, Rachel,16753 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Baker, Sierra,19465 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Faith, L,27407 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Allen, Natalie,16997 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Wagner, Jenny, M,28186 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Adams, Xavier, C,22133 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Young, Mason,27427 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Hall, Ashley, A,26047 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gomez, Deanna,15655 | 2753.82 | 0.00 | 2181.56 | 0.00 | 572.26 |
| Jackson, Ryan, G,26260 | 93.46 | 0.00 | 0.00 | 0.00 | 93.46 |
| Foster, Spencer, J,21612 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Moore, Julia,24656 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Ward, Bruce, R,28162 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Hayes, Cassidy,22766 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Johnston, Julia,15837 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| He, Trisha, C,12490 | 167.83 | 0.00 | 0.00 | 58.98 | 108.85 |
| Zhao, Jon,28148 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Simmons, Luke, J,16330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
Generated 2025-11-06 19:01:30.517 UTC