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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Murphy, Alex,222381155.480.000.000.001155.48
Coleman, Paige, L,1526378.960.000.000.0078.96
Hughes, Victoria,191121764.960.000.000.001764.96
Chande, Casey,2614978.980.000.000.0078.98
Chen, Marshall, E,190374858.340.000.002443.352414.99
Lee, Eduardo,11697152.960.000.000.00152.96
Deng, Arturo, A,281021299.830.000.000.001299.83
Brooks, Victoria, H,16479158.510.000.000.00158.51
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Fernandez, Emmanuel,2895514.980.000.000.0014.98
Vance, Regina, M,149846699.570.003578.270.003121.30
Srini, Ross,1763673.960.000.000.0073.96
Scott, Kaitlyn, A,12159258.890.000.00133.96124.93
Allen, Angel, G,15571101.850.000.0034.8966.96
Cox, Marcus,1894578.980.000.000.0078.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
Powell, Megan,130884760.320.002443.350.002316.97
Hu, Jessie, F,1933128.980.000.000.0028.98
Navarro, Roberto,2457127.770.000.000.0027.77
King, Katelyn,168672381.940.000.000.002381.94
Guo, Dennis,137354516.530.000.002181.562334.97
Jenkins, Amanda,152144490.880.000.002071.422419.46
Jackson, Jeremiah, A,184002409.950.000.000.002409.95
Chen, Crystal, M,265662016.950.000.00782.991233.96
Huang, Valerie, J,267451932.460.000.00782.991149.47
Campbell, Natalie, L,115122319.990.000.000.002319.99
Subram, Francisco, A,218974909.670.000.002443.352466.32
Diaz, Roberto, A,222024671.740.000.002181.562490.18
Bryant, Isabel, L,259864624.830.003374.990.001249.84
Ward, Julia, M,23815724.470.000.000.00724.47
She, Alisha, G,247574343.590.003578.270.00765.32
Ross, Ethan,23884603.490.000.000.00603.49
Phillips, Jose,23723628.450.000.000.00628.45
White, Judith, R,148851155.480.000.000.001155.48
King, Mackenzie, M,269161322.980.000.00782.99539.99
Madan, Pamela,185021760.470.000.000.001760.47
Chow, Shannon,1844425.480.000.000.0025.48
Pal, Drew,1190263.040.000.006.2856.76
Zhu, Jessie, D,1266634.560.000.000.0034.56
Howard, Carol, T,11170157.230.000.000.00157.23
Morris, Olivia, L,141555993.260.003578.270.002414.99
Harris, Brandon,2451786.580.000.000.0086.58
Weber, Tammy, A,179984144.340.000.002443.351700.99
Griffin, Alexia, W,180273917.540.000.002181.561735.98
Alvarez, Michele, J,11844124.970.000.000.00124.97
Alexander, Cameron,2625536.270.000.000.0036.27
Turner, Isaac,19885123.980.000.000.00123.98
Ward, Garrett,2628427.280.000.000.0027.28
She, Margaret, K,2176049.970.000.000.0049.97
Suarez, Marc,2698023.780.000.000.0023.78
Wilson, Thomas, E,155734.990.000.000.004.99
Andersen, Dawn,1647324.990.000.000.0024.99
Martin, Jay,1959759.460.000.000.0059.46
Shan, Mindy, R,251177.280.000.000.007.28
Jai, Gregory,16342143.390.000.000.00143.39
Malhotra, Johnathan,1772383.940.000.0064.9718.97
Sai, Andre,2737238.980.000.000.0038.98
Shan, Rafael, A,1321921.980.000.000.0021.98
Jai, Luis, A,18320223.190.000.000.00223.19
Green, Allison,161112340.940.000.000.002340.94
Jackson, Taylor, E,2928223.970.000.000.0023.97
King, Julia, C,2127814.980.000.000.0014.98
Serrano, Natasha,255631239.090.00699.100.00539.99
Coleman, Gabriel, B,1770677.910.000.000.0077.91
Griffin, Angela,1113371.960.000.000.0071.96
Gao, Franklin, R,137977.280.000.000.007.28
Long, Madison, J,1220551.270.000.000.0051.27
Tang, Lindsey, C,253081120.490.000.000.001120.49
Andersen, Yolanda,2195435.000.000.000.0035.00
Gutierrez, Tabitha, A,2188474.980.000.000.0074.98
She, Jeffery, M,2714942.280.000.000.0042.28
Blanco, Krista, L,2758039.980.000.000.0039.98
Baker, Rebecca,2903674.980.000.000.0074.98
Guo, Cara, R,15721118.960.000.000.00118.96
Ruiz, Diana, C,127364460.380.000.002071.422388.96
Jai, Kelvin,257962475.950.000.000.002475.95
Thomas, Nathan, A,2033071.950.000.000.0071.95
Sai, Deanna, D,180082459.070.00699.100.001759.97
Ruiz, Meghan, A,1562939.980.000.000.0039.98
Malhotra, Ruth, D,1632197.250.000.000.0097.25
Adams, Gabriella, K,2475834.890.000.000.0034.89
Luo, Dawn, A,1380427.280.000.000.0027.28
Serrano, Jessie, A,2016832.280.000.000.0032.28
Gomez, Pedro,2428871.580.000.000.0071.58
Gomez, Ebony, C,2090469.970.000.000.0069.97
Fernandez, Francisco,240976.280.000.000.006.28
Sharma, Aaron, J,1180187.280.000.000.0087.28
Goel, Jaime, W,220539.990.000.000.009.99
Thomas, Elizabeth, A,152827.280.000.000.007.28
Schmidt, Kristi, J,11733194.980.000.000.00194.98
Hughes, Cassidy,1329486.950.000.000.0086.95
Hayes, Aidan,25189152.600.000.000.00152.60
Cooper, Taylor,2210545.220.000.000.0045.22
Patel, Kristi, C,169082366.960.000.000.002366.96
Madan, Kristina, A,28698765.320.000.000.00765.32
Perez, Henry,267521917.460.000.00782.991134.47
Gill, Marie,1138348.970.000.000.0048.97
Vance, Marco,1312491.920.000.000.0091.92
Henderson, Aaron,2876227.280.000.000.0027.28
Washington, Aidan,23444548.980.000.000.00548.98
Green, Madeline,162404.990.000.000.004.99
Morris, Arianna, W,1499957.510.000.000.0057.51
Garcia, Michele,1498056.970.000.000.0056.97
Zhao, Mandy, F,2487734.470.000.000.0034.47
Sara, Henry, L,208923240.320.000.00782.992457.33
Wu, Sandra,2262433.980.000.000.0033.98
Srini, Rebekah,2833562.980.000.000.0062.98
Rubio, Jaime, R,15007209.830.000.0049.97159.86
James, Andrea, D,2802339.980.000.000.0039.98
Lu, Aimee, J,2034278.980.000.000.0078.98
Walker, Daniel, E,186614.990.000.000.004.99
Bryant, Thomas,1440764.470.000.000.0064.47
Munoz, Desiree,2487921.490.000.000.0021.49
Flores, Hannah,1952580.210.000.000.0080.21
Wang, Kelli,1793937.270.000.000.0037.27
Raje, Peter, D,2079932.280.000.000.0032.28
Gao, Dawn, C,1644366.950.000.000.0066.95
Hu, Stacey,12696231.960.000.000.00231.96
Johnston, Joanna, L,17296113.960.000.000.00113.96
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Brown, Isabella, L,266921266.860.00699.100.00567.76
Blue, Paige,2170343.960.000.000.0043.96
Gray, Seth, M,20087112.760.000.000.00112.76
Lewis, Elizabeth, S,212681725.980.000.000.001725.98
Russell, Alexandria, D,182341754.980.000.000.001754.98
Miller, Julia, R,168164.990.000.000.004.99
Sanchez, Melanie,132647265.563578.270.000.003687.29
Kennedy, Bonnie, C,2013627.280.000.000.0027.28
Gill, Brandi, D,1212413195.643578.270.007219.322398.05
Gill, Ruben, D,1793837.270.000.000.0037.27
Alexander, Megan,2183768.490.000.000.0068.49
Albrecht, Brian, T,1367739.980.000.000.0039.98
Romero, Robin,1143534.990.000.000.0034.99
Andersen, Arturo,1575898.960.000.000.0098.96
Alan, Jamie, S,2122442.280.000.000.0042.28
Lopez, Patricia,2830529.480.000.000.0029.48
Sharma, Corey, M,17495119.910.000.000.00119.91
Diaz, Kellie, A,1833088.970.000.0034.9853.99
Torres, Charles, S,1164442.280.000.000.0042.28
Bell, Allison, L,2886363.970.000.000.0063.97
Torres, Stephanie,1118281.260.000.000.0081.26
Peterson, Cole, L,2645353.950.000.000.0053.95
Barnes, Destiny, A,2475029.980.000.000.0029.98
Fernandez, Ebony,2466358.980.000.000.0058.98
Nelson, Gabriel, A,1623939.980.000.000.0039.98
Perez, Noah,1448289.970.000.000.0089.97
Gill, Frank, C,14197107.080.000.000.00107.08
Butler, Miranda, D,1434021.980.000.000.0021.98
Randall, Tammy, C,13798136.360.000.000.00136.36
Moreno, Carrie, W,271516.280.000.000.006.28
Vazquez, Brandi,2716031.730.000.000.0031.73
Blanco, Beth,2944425.480.000.000.0025.48
Carlson, Anne, H,22305119.960.000.000.00119.96
Hernandez, Casey, I,2407677.960.000.000.0077.96
White, Zachary,2404212.980.000.000.0012.98
James, Zoe, R,14611304.550.000.000.00304.55
Patterson, Cameron, M,2579069.460.000.000.0069.46
Sanders, Kimberly, M,1319656.970.000.000.0056.97
Andersen, Dale, B,14992106.260.000.000.00106.26
Thorpe, Steven, G,1289071.970.000.000.0071.97
Bryant, Alexis, A,1241759.270.000.000.0059.27
Collins, Jonathan,16849176.950.000.000.00176.95
Wang, Kelvin, S,151434366.410.000.002071.422294.99
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Gonzalez, Brenda,2502823.780.000.000.0023.78
Vazquez, Jacquelyn,2896049.970.000.000.0049.97
Hayes, Miranda, D,274474490.480.000.002071.422419.06
Chen, Kelvin,23341561.480.000.000.00561.48
Gonzalez, Molly,16370132.500.000.000.00132.50
She, Cristina, M,23342556.260.000.000.00556.26
Hughes, Luke, I,270141274.080.00699.100.00574.98
Cai, Dennis,285631197.970.000.000.001197.97
Carlson, Gary, R,241151164.470.000.000.001164.47
White, Blake, P,1279276.970.000.000.0076.97
Rubio, Eddie, L,1155234.990.000.000.0034.99
Ruiz, Marvin, R,1879623.780.000.000.0023.78
Li, Valerie, R,2750727.770.000.000.0027.77
Powell, Hunter,2278137.270.000.000.0037.27
Rai, Alvin,183287.280.000.000.007.28
Powell, Paige,1986369.990.000.000.0069.99
Sanchez, Cole,1240536.590.000.000.0036.59
Black, Nicolas,239454.990.000.000.004.99
Sun, Sandra, L,2731233.980.000.000.0033.98
Yang, Kyle, C,1324256.970.000.000.0056.97
Hernandez, Connor,148951503.580.00699.100.00804.48
Scott, Bailey, A,1214982.930.000.000.0082.93
Gill, Ricky, A,1560788.460.000.000.0088.46
Torres, Emma,11730134.460.000.000.00134.46
Johnson, Emily,11085128.960.000.000.00128.96
Perez, Gabriel, E,2528232.600.000.000.0032.60
Gonzales, Jose,2201480.200.000.000.0080.20
Diaz, Marissa, C,292654320.620.003578.270.00742.35
Deng, Maurice,23453632.450.000.000.00632.45
Chen, Jonathan, G,13096230.680.000.000.00230.68
Coleman, Abigail, E,214841120.490.000.000.001120.49
Smith, Julia,212821120.490.000.000.001120.49
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Chandra, Marco, A,28466119.980.000.000.00119.98
Jenkins, Cassidy, L,2248239.980.000.000.0039.98
Sun, Amy, C,114219780.040.003399.992294.994085.06
Gonzales, Lucas,29463751.340.000.000.00751.34
Arthur, Jay, R,126946785.130.002049.100.004736.03
Zhang, Clarence, M,130016799.430.000.002049.104750.33
Rivera, Savannah,2318237.270.000.000.0037.27
Evans, Isaiah, J,2805021.490.000.000.0021.49
Xu, Bethany, F,223824.990.000.000.004.99
Zeng, Jake,18054106.930.000.000.00106.93
Diaz, Antonio,1309456.970.000.000.0056.97
Clark, James, E,13014194.980.000.000.00194.98
Henderson, Jessica,11065202.570.000.00196.296.28
Morris, Brooke,2705728.990.000.000.0028.99
Torres, Max, L,2579721.490.000.000.0021.49
Cook, Christina,2551739.980.000.000.0039.98
Zheng, Shannon, M,14678167.950.000.0049.99117.96
Yang, Jorge,20404124.990.000.000.00124.99
Yuan, Katrina, D,2665969.990.000.000.0069.99
Ma, Cedric, W,11094235.890.000.000.00235.89
Ortega, Tyrone, H,125832646.400.002071.420.00574.98
Moore, Daniel, L,2764721.490.000.000.0021.49
Gonzalez, Ian,25346114.960.000.000.00114.96
Griffin, Xavier,228775962.340.003578.270.002384.07
Robinson, Dylan, L,14724120.410.000.000.00120.41
Flores, Xavier,238664828.110.003578.270.001249.84
Cox, Caitlin,2051072.930.000.000.0072.93
Wright, Mary, P,185621732.260.000.000.001732.26
Bennett, Angelica, L,232907.280.000.000.007.28
Evans, Mary, E,1735613.980.000.000.0013.98
Morgan, Jessica,183711754.980.000.000.001754.98
Ms., Spencer, Sylvia, N.,1930339.980.000.000.0039.98
Zhao, Alvin, A,1934727.770.000.000.0027.77
Cai, Kelvin, A,254564.990.000.000.004.99
Bailey, Jacqueline,286108.990.000.000.008.99
Adams, Gabrielle, J,11172128.940.000.000.00128.94
Zhu, Damien, M,1582243.210.000.000.0043.21
Cai, Susan,19101104.420.000.000.00104.42
Fernandez, Marie,289297.280.000.000.007.28
Weber, Jarrod, M,1485940.260.000.0031.278.99
Zhu, Jamie, J,13140325.210.000.000.00325.21
Hughes, Elizabeth,2702931.730.000.000.0031.73
Patterson, Jordyn, A,2701041.930.000.000.0041.93
Brooks, Natalie, W,2507138.880.000.000.0038.88
Sanchez, Sydney,2141549.970.000.000.0049.97
Alonso, Bruce, L,207759.990.000.000.009.99
Scott, Amber, B,176734.990.000.000.004.99
Watson, Mason, C,1529339.980.000.000.0039.98
Simmons, Christian,2075269.990.000.000.0069.99
Deng, Karl, L,1721071.950.000.000.0071.95
Edwards, Jackson,257854.990.000.000.004.99
Carter, Caleb, F,11067105.750.000.000.00105.75
Blue, Morgan, A,130563291.820.002443.350.00848.47

Generated 2025-11-03 13:18:58.867 UTC