[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ ALL   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   <  SKIP 1250  >   <  TAKE 250  >   

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hall, Julia, R,2733711.940.000.000.0011.94
Sanchez, Joe, S,165524986.790.000.002443.352543.44
Wang, Margaret, P,2281512.980.000.000.0012.98
Jai, Colin,12138119.910.000.000.00119.91
Ma, Jorge, O,1405286.260.000.0027.2858.98
Ruiz, Dwayne, A,2632327.280.000.000.0027.28
Cox, Megan, A,11657178.960.000.000.00178.96
Thompson, Anna,2720036.270.000.000.0036.27
Rogers, Shelby,11712127.800.000.0042.5985.21
Xu, Nina,1329181.460.000.000.0081.46
Rai, Wayne, T,12489157.920.000.0039.98117.94
Gutierrez, Raquel, H,286972452.040.000.000.002452.04
Tang, Franklin, N,269401273.830.000.000.001273.83
Hill, James, S,293172438.060.000.000.002438.06
Howard, Natalie,13491176.410.000.0014.98161.43
Bhat, Edwin,130796752.130.000.002049.104703.03
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Zhou, Trisha, B,126866864.460.002071.420.004793.04
Dominguez, Ricky, B,256581735.980.000.000.001735.98
Prasad, Nancy,247091735.980.000.000.001735.98
Diaz, Marvin,2794229.480.000.0029.480.00
Garcia, Brenda,1357439.980.000.0039.980.00
Chavez, Kurt, C,2356356.970.000.000.0056.97
Garcia, Daniel, C,118185954.220.003578.272375.950.00
Schmidt, Kaitlin,13628191.250.000.000.00191.25
Garcia, Taylor, N,118305930.230.003578.272351.960.00
Patterson, Jose,113236074.540.003578.272496.270.00
Rai, Arturo, T,225041735.980.000.000.001735.98
Bennett, Alexia,26690132.470.000.000.00132.47
Smith, Austin,13707189.040.000.000.00189.04
Walker, Elizabeth,2745758.470.000.000.0058.47
Griffin, Aidan, A,2371729.990.000.000.0029.99
Hughes, Jonathan,22282574.980.000.00574.980.00
Vazquez, Nelson, D,2207665.950.000.000.0065.95
Long, Dakota, N,2245339.980.000.000.0039.98
Baker, Kaylee,11703100.270.000.0062.9837.29
Ye, Ernest, A,225584.990.000.000.004.99
Ramirez, Jada,1374056.970.000.000.0056.97
Hu, Aimee, R,2798139.980.000.0039.980.00
Thompson, Isabella,18756128.410.000.000.00128.41
Moore, Anna, A,1274471.970.000.000.0071.97
Prasad, Jay,152841683.930.00782.990.00900.94
Huang, Jeffery,257556.280.000.000.006.28
Alonso, Kendra, C,164272975.020.002181.56793.460.00
Zhang, Randy,1260164.900.000.000.0064.90
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Wu, Dennis, G,1150361.780.000.000.0061.78
Hernandez, Andrea, D,2176278.960.000.0078.960.00
Thomas, Jessica,16848125.450.000.0094.4830.97
Rodriguez, Hannah,132864516.530.002181.560.002334.97
Ma, Brittney,125842633.390.002071.420.00561.97
White, Greg, C,174032322.280.000.000.002322.28
Gill, Erika, A,182024143.260.003578.270.00564.99
Kumar, Louis, A,182034172.250.003578.270.00593.98
Jenkins, Elijah, S,1727667.970.000.0067.970.00
Powell, Alyssa,154767.280.000.007.280.00
Chander, Dawn,1381839.990.000.0039.990.00
Gutierrez, Lawrence, M,195645293.240.003578.270.001714.97
Romero, Kari,2186139.980.000.0039.980.00
Xu, Rafael, N,211954144.340.002443.350.001700.99
Navarro, Albert, L,215614947.780.002443.350.002504.43
Andersen, Warren,119198171.520.003374.990.004796.53
Gomez, Adrienne,119208156.320.003374.990.004781.33
Johnson, Marcus,18960618.980.000.00618.980.00
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Sharma, Ethan, M,200921149.470.000.000.001149.47
Moyer, Ashlee, R,25749742.350.000.00742.350.00
Dominguez, Adrienne, M,23392553.970.000.000.00553.97
Suri, Andre, D,241891174.480.000.000.001174.48
Washington, Luis, T,12533271.950.000.0072.96198.99
Deng, Kurt, D,13635215.740.000.0032.27183.47
Arun, Bryant, C,2045321.490.000.0021.490.00
Yang, Hunter, E,2023721.490.000.0021.490.00
Russell, Connor,2762428.990.000.0028.990.00
Vazquez, Carolyn,2365039.980.000.000.0039.98
Adams, Blake, L,186461735.980.000.000.001735.98
Bennett, Mya, M,185681732.260.000.000.001732.26
Chen, Christian, D,2801529.480.000.000.0029.48
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Rai, Latoya, A,208831149.470.000.000.001149.47
Carter, Noah, E,2595427.280.000.000.0027.28
Moreno, Walter, L,206819.990.000.009.990.00
Patterson, Ian, R,2297769.970.000.000.0069.97
Jenkins, Jasmine, S,1893569.990.000.0069.990.00
Rubio, Brandi, M,2314932.280.000.000.0032.28
Gao, Bianca, C,131125717.890.000.002049.103668.79
Anand, Sheena, L,14907127.280.000.000.00127.28
Henderson, Angelica, M,1600639.980.000.000.0039.98
Sai, Dominique,2890833.430.000.0033.430.00
Ramirez, Angela,15514124.990.000.000.00124.99
Foster, Natalie,159664.990.000.000.004.99
Morgan, Natalie,1514963.970.000.000.0063.97
Williams, Austin,2035432.220.000.000.0032.22
Henderson, Marissa,13816260.830.000.000.00260.83
Lin, Autumn, E,182726056.610.003578.272478.340.00
Diaz, Robyn, Z,2090369.970.000.000.0069.97
Butler, Emily, M,2096438.980.000.000.0038.98
Bennett, Isabelle, C,18674145.960.000.000.00145.96
Clark, Fernando, C,1487271.970.000.000.0071.97
Perez, Geoffrey, P,210002721.550.002181.560.00539.99
Clark, Jose,267274482.140.000.002049.102433.04
Taylor, Brianna,17027230.900.000.0051.96178.94
Long, Robert, C,1866413.980.000.0013.980.00
Ward, Paige,1695313.980.000.0013.980.00
Zhao, Warren,256351754.980.000.000.001754.98
Huang, Gilbert, N,159276932.900.002181.560.004751.34
Serrano, Jésus, B,129915641.900.000.002049.103592.80
Raje, Shawn,1705483.980.000.000.0083.98
She, Karen, H,26852114.460.000.00114.460.00
Tang, Melvin, R,1366315.230.000.0015.230.00
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Dominguez, Derrick, A,22679611.960.000.000.00611.96
Jackson, Lauren,2476786.580.000.000.0086.58
Suarez, Jonathon, P,199443105.270.00782.990.002322.28
Lal, Bethany, A,162532721.550.000.002181.56539.99
Lu, Sandra, N,135214514.770.000.004514.770.00
Hernandez, Wyatt, S,2467971.580.000.000.0071.58
Serrano, Stacy,246132148.210.001000.441147.770.00
Gomez, Leslie,176844.990.000.000.004.99
King, Eric,1899769.990.000.000.0069.99
Hall, Madison, M,1450854.980.000.000.0054.98
Thomas, Hannah,1429556.970.000.000.0056.97
Torres, Francis,1722321.980.000.000.0021.98
Gutierrez, Stacy, L,2185389.970.000.000.0089.97
Johnson, Joshua,2093913.980.000.000.0013.98
Sun, Clayton,285334.990.000.004.990.00
Diaz, Theodore, D,1178574.980.000.000.0074.98
Martin, Joy, L,13544108.440.000.000.00108.44
Yang, Ramon, K,1360998.960.000.000.0098.96
Deng, Nina, O,137904397.750.003578.27819.480.00
Wu, Jon,2627829.980.000.0029.980.00
Jai, Jackson,133554558.530.002181.560.002376.97
Vazquez, Natasha, J,1972769.990.000.0069.990.00
Prasad, Meagan,196116054.220.003578.270.002475.95
Simmons, Alexandria,1750612.940.000.0012.940.00
Li, Austin, B,1811012.940.000.0012.940.00
Munoz, Jésus, K,136976485.670.003578.270.002907.40
Jiménez, Alfredo,1543039.980.000.0039.980.00
Kelly, Morgan, L,1476139.980.000.0039.980.00
Gutierrez, Carrie, C,28139127.280.000.000.00127.28
Zhao, Karen, L,254082735.530.002181.560.00553.97
Perez, Levi,26830553.970.000.000.00553.97
Butler, Edward, L,2065547.420.000.000.0047.42
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Zhou, Cedric,175144142.230.003578.27563.960.00
Lewis, Benjamin,1245521.980.000.000.0021.98
Nath, Michele, L,110568207.503374.990.002413.452419.06
Cooper, Bailey,1786367.930.000.000.0067.93
Rogers, Victoria,1565864.970.000.000.0064.97
Nara, Sharon,184826030.610.003578.272452.340.00
White, Noah, M,175802404.970.000.000.002404.97
Walker, Julia,2721728.980.000.000.0028.98
Simmons, Maria, B,280877.280.000.000.007.28
White, Ashley, D,2188739.990.000.0039.990.00
Bradley, Katherine,2359638.980.000.000.0038.98
Martin, Ethan, M,13998245.250.000.0097.97147.28
Huang, Jorge,1729186.270.000.0053.9932.28
Thompson, Brianna, X,18642216.400.000.000.00216.40
Gao, Edwin,257161302.590.00699.100.00603.49
Luo, Alvin,236352452.340.000.002452.340.00
Sai, George, T,2354993.490.000.000.0093.49
Ortega, Alfredo, W,259581903.480.00782.990.001120.49
Lopez, Isaac,27692603.490.000.000.00603.49
Walker, Dalton, S,2844769.990.000.000.0069.99
Zhao, Clayton,2058624.990.000.000.0024.99
Torres, Isaiah, E,2327722.930.000.0022.930.00
Hernandez, Gabriel, J,1380528.980.000.000.0028.98
Hill, Amanda,211521134.470.000.000.001134.47
Arun, Sergio,2564339.980.000.000.0039.98
Gonzales, Ethan, D,2069673.960.000.0073.960.00
Price, Jasmine, L,2890029.480.000.000.0029.48
Carter, Sara,180601700.990.000.000.001700.99
Lewis, Nicholas, G,181024.990.000.004.990.00
Turner, James, E,16841126.960.000.0069.9956.97
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Martin, Thomas, A,169521735.980.000.000.001735.98
Yuan, Lacey, W,123496772.140.002049.100.004723.04
White, Anthony,181405741.410.001000.440.004740.97
Russell, Miranda,19165633.960.000.000.00633.96
Xu, Todd,2845669.990.000.0069.990.00
Andersen, Kara, B,1470495.940.000.0095.940.00
Cook, Jada,1336056.970.000.0056.970.00
Wang, Erica, J,221682997.320.000.002443.35553.97
Flores, Isabel,23715539.990.000.000.00539.99
Chande, Cristina,2623348.970.000.0048.970.00
Perez, Isaac, S,23853588.960.000.000.00588.96
Flores, Grace, C,172654.990.000.000.004.99
Lopez, Janelle, G,255001170.480.000.000.001170.48
Sharma, Kurt,118855900.550.003578.272322.280.00
Jiménez, Craig,134067300.553578.270.000.003722.28
Torres, Derrick,1469189.970.000.000.0089.97
Shen, Michele,27985539.990.000.000.00539.99
Jimenez, Larry, M,263631744.970.000.000.001744.97
Hernandez, Katherine,245282420.340.000.002420.340.00
Gomez, Rebekah,13486225.440.000.000.00225.44
Ramos, Kendra,2489615.230.000.000.0015.23
Ms., Sloan, Cathy, J.,279482457.330.000.000.002457.33
Sara, Evelyn,160453802.370.002181.560.001620.81
Yang, Jordan, K,14458133.950.000.000.00133.95
Nelson, Carlos,2897774.980.000.000.0074.98
Serrano, Eddie,21041589.960.000.00589.960.00
Chander, Alison,182496044.590.003578.272466.320.00
Reed, Jared, M,28531751.340.000.000.00751.34
King, Seth, L,1499429.980.000.000.0029.98
Chen, Autumn, I,214084624.910.002181.560.002443.35
Johnson, John, A,2784048.970.000.000.0048.97
Wang, Crystal, C,111128295.020.003374.990.004920.03
Powell, Connor, M,25839107.940.000.00107.940.00
Johnson, Austin,11821151.430.000.000.00151.43
Hernandez, Sydney,134564582.510.000.002181.562400.95
Wu, Steve,149496795.600.003578.270.003217.33
Suarez, Lee, D,22680620.950.000.000.00620.95
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Patel, Francisco,154437.280.000.007.280.00
Nelson, Jesse, M,2679388.970.000.000.0088.97
Xu, Eugene, A,14208117.430.000.0058.4758.96
Powell, Benjamin, F,2596824.990.000.000.0024.99
She, Michele, P,290513.990.000.000.003.99
Coleman, Emma,2768460.470.000.000.0060.47
Bryant, Tristan, L,244412419.060.000.000.002419.06
Patterson, Marcus, D,2384338.980.000.000.0038.98
Turner, Bailey,1810164.470.000.000.0064.47
Williams, Kaitlyn, A,1922159.980.000.000.0059.98
Jimenez, Hector,2625782.950.000.000.0082.95
Sun, Alisha,1804864.970.000.000.0064.97
Brooks, Chase, A,2276429.990.000.000.0029.99
Deng, Melvin, C,277971120.490.000.000.001120.49
Ye, Arturo,2072730.480.000.000.0030.48
Roberts, Dalton,263874.990.000.000.004.99
Howard, Jennifer,1626461.960.000.000.0061.96
Ross, Spencer, R,2547139.980.000.000.0039.98
She, Rafael, I,201524142.750.003578.27564.480.00
Hernandez, Theresa,1295583.970.000.000.0083.97
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Lopez, Madeline, G,12044105.950.000.000.00105.95
Lin, Randy,14540156.250.000.0036.27119.98
Xie, Wayne, S,183026029.570.003578.272451.300.00
Rodriguez, Regina, A,2408239.980.000.000.0039.98
Malhotra, Edgar, K,1255568.970.000.000.0068.97
Shan, Jason,2897127.280.000.0027.280.00
Sanz, Julio, H,214044684.390.002181.560.002502.83
Arun, Preston,2378434.980.000.0034.980.00
Cooper, Danielle, J,2584935.230.000.0035.230.00
Carter, Edward,2382469.970.000.0069.970.00
Ashe, Alyssa, C,2169344.980.000.000.0044.98
Gonzales, Gloria, A,23174553.970.000.000.00553.97
Perez, Savannah, J,17036176.950.000.0056.97119.98
Gomez, Byron,24049574.980.000.000.00574.98
Jai, Christy, G,26979588.960.000.000.00588.96
Jones, Christopher, J,1451239.980.000.0039.980.00

Generated 2025-11-06 22:15:58.331 UTC