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

390 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Smith, Ethan,1453072.860.000.0036.5936.27
Raje, Tony,242121155.480.000.000.001155.48
Zhou, Colin,179622777.520.000.002181.56595.96
Raman, Francisco, M,2402013.980.000.000.0013.98
Zhao, Sandra, S,225031775.470.000.000.001775.47
Fernandez, Meagan, C,194483543.880.000.003543.880.00
Rai, Kara, D,2697038.980.000.000.0038.98
Alexander, Isabel,2282343.970.000.000.0043.97
Lal, Ricardo, C,179582811.520.000.002181.56629.96
Zhang, Arturo, V,2689139.980.000.000.0039.98
Fernandez, Bruce, E,2688838.980.000.000.0038.98
Kumar, Raul, B,128574384.080.000.002049.102334.98
Madan, Ross, C,279293.990.000.003.990.00
Kim, Carmen,255021174.480.000.000.001174.48
She, Trisha, A,180212793.520.000.002181.56611.96
Rai, Donna,1223562.760.000.0034.9927.77
Clark, Marcus, G,2795838.980.000.000.0038.98
Zeng, Valerie,179772966.030.000.002181.56784.47
Romero, Diana,1776092.250.000.000.0092.25
Hernandez, Francis,211032506.950.000.002506.950.00
Ms., Sheperdigian, Janet,2454137.270.000.000.0037.27
Xie, Carly, R,132536774.450.000.002071.424703.03
Lal, Misty, L,2238558.980.000.000.0058.98
Zeng, Aimee,1934231.270.000.000.0031.27
Ramos, Diana, J,287332407.040.000.000.002407.04
Suarez, Albert, W,2095032.280.000.000.0032.28
Sharma, Cassie, A,26978553.970.000.000.00553.97
Morgan, Kimberly, A,287352420.340.000.000.002420.34
Howard, Carlos,27891597.950.000.000.00597.95
Rai, Alicia, M,2891427.770.000.000.0027.77
Zhou, Curtis,2550538.980.000.000.0038.98
Alonso, Micheal, W,19307148.980.000.000.00148.98
Diaz, Stephanie,156947.280.000.000.007.28
Torres, Orlando, H,27896539.990.000.000.00539.99
Weber, Stanley, E,12311116.430.000.000.00116.43
Diaz, Reginald, A,2458139.980.000.000.0039.98
Suri, Joe,2102837.270.000.000.0037.27
Tang, Alejandro, L,1154234.470.000.000.0034.47
Nara, Alisha, D,26959563.770.000.000.00563.77
Zeng, Martha, J,17844196.260.000.007.28188.98
Evans, Lucas, J,1155621.490.000.000.0021.49
Johnsen, Rebekah, J,199194.990.000.000.004.99
Yang, Luke,2852660.470.000.000.0060.47
Scott, Mackenzie, L,2567666.970.000.000.0066.97
Rubio, Dwayne, D,28527563.770.000.000.00563.77
Nath, Sheena,2580039.980.000.000.0039.98
She, Kurt,262062478.340.000.000.002478.34
Lin, Candice, K,195063480.380.000.001000.442479.94
Russell, Emma, I,2151224.990.000.000.0024.99
Shan, Russell,195003478.780.000.003478.780.00
Romero, Armando, A,1259668.970.000.000.0068.97
Ward, Marcus, L,195113524.360.000.001000.442523.92
Sandoval, Giraldo, Hierro,226341775.470.000.000.001775.47
Coleman, Jessica,135535603.240.000.002071.423531.82
Goel, Kathryn,1274044.980.000.000.0044.98
Lee, Jacob,135515622.920.000.002049.103573.82
Deng, Lindsay, K,2944723.780.000.000.0023.78
Rubio, Ross,215401602.470.000.00782.99819.48
Russell, Natalie, M,2090078.960.000.000.0078.96
Raman, Bryant, S,190484765.630.000.002443.352322.28
Xu, Melvin, A,1147449.970.000.000.0049.97
Goel, Shawn, L,190584524.480.000.002181.562342.92
Raman, Douglas,2454569.970.000.000.0069.97
Rana, Cassandra,134076904.100.000.002049.104855.00
Mehta, Whitney, T,241971155.480.000.000.001155.48
Martin, Albert,26837548.980.000.000.00548.98
Sharma, Dylan,1906684.960.000.000.0084.96
Gutierrez, Kathleen,1778689.460.000.0039.9849.48
Brooks, Sara, A,1228888.980.000.000.0088.98
Raje, Omar, R,12309102.260.000.0023.7878.48
Goel, Tasha, R,1947823.780.000.000.0023.78
Chen, Wesley, J,2942721.490.000.000.0021.49
Gonzalez, Troy, A,28517578.460.000.000.00578.46
Ruiz, Jaime, J,25609565.470.000.00565.470.00
Brooks, Christina, W,2249648.970.000.000.0048.97
Rana, Roy, M,226671170.480.000.001170.480.00
Tang, Lindsey, C,253081120.490.000.000.001120.49
Jones, Brianna,255461179.470.000.000.001179.47
Jai, Kelvin,257962475.950.000.000.002475.95
Deng, Dale,28399553.970.000.000.00553.97
Lal, Lindsay, H,2055764.970.000.000.0064.97
Schmidt, Theresa,2185424.990.000.000.0024.99
Gray, Allison, D,2057124.990.000.000.0024.99
Liang, Marshall, J,254471164.470.000.000.001164.47
Vazquez, Carrie,2941953.990.000.000.0053.99
Rogers, Melissa, J,284152428.050.000.000.002428.05
Moreno, Carrie, W,271516.280.000.000.006.28
Cook, Rachel, T,23614144.450.000.000.00144.45
Rodriguez, Manuel, A,246971170.480.000.000.001170.48
Blanco, Max,26360539.990.000.000.00539.99
She, Terry, R,254541155.480.000.000.001155.48
Lal, Gilbert,245772487.330.000.000.002487.33
Zheng, Nuan,13604132.940.000.000.00132.94
Suri, Ebony, A,228082478.340.000.002478.340.00
Johnsen, Jerome,28367600.460.000.000.00600.46
Raji, Lindsay, E,226691120.490.000.001120.490.00
Foster, Mary,241121155.480.000.000.001155.48
Lin, Curtis, N,218582492.320.000.002492.320.00
Rivera, Dalton, E,28366578.460.000.000.00578.46
Zeng, Sandra,25608539.990.000.00539.990.00
Srini, Ronald, E,164674.990.000.000.004.99
Dominguez, Jay, A,218572487.330.000.002487.330.00
Adams, Ian, C,2942262.980.000.000.0062.98
Cai, Jamie, S,13505127.930.000.000.00127.93
Torres, Rodney, L,225201775.470.000.000.001775.47
Patel, Troy,1496848.970.000.000.0048.97
Shan, Sharon, A,242111170.480.000.000.001170.48
Jenkins, Devin,2238367.970.000.000.0067.97
Kumar, Carl,1274369.990.000.000.0069.99
Garcia, Tabitha,27778539.990.000.000.00539.99
Huang, Alvin,1249186.580.000.000.0086.58
Suarez, Max, A,14809115.250.000.0078.9836.27
Liang, Jeffery,15711126.560.000.000.00126.56
Cox, Taylor,1143681.760.000.000.0081.76
Raji, April, L,1498171.270.000.000.0071.27
Browning, Casey,1644947.260.000.0039.987.28
Ramos, Cheryl, A,2568238.980.000.000.0038.98
Ruiz, Janet, M,2281856.960.000.0056.960.00
Sai, Dominique,2890833.430.000.0033.430.00
Navarro, Erika, K,1147653.990.000.000.0053.99
Rodriguez, Bryant, R,293602418.050.000.000.002418.05
Ramos, Kari, D,247021174.480.000.000.001174.48
Kumar, Carly, R,247121120.490.000.000.001120.49
Diaz, Kathleen, C,28375567.760.000.000.00567.76
James, Gabriella, S,225941709.980.000.000.001709.98
Gao, Marshall,2578258.980.000.000.0058.98
Lu, Brittney, A,1284873.960.000.000.0073.96
Henderson, Hunter, C,1481263.970.000.000.0063.97
Black, Roger, J,284162442.030.000.000.002442.03
Ma, Stacey,2184031.270.000.0031.270.00
Smith, Hunter, L,2150724.990.000.0024.990.00
Gill, Alfredo, M,236292466.320.000.002466.320.00
Suri, Tammy,240311170.480.000.000.001170.48
Deng, Ricardo,2111137.270.000.0037.270.00
Jai, Christine, J,14814128.460.000.00128.460.00
Townsend, Trinity, L,12367160.450.000.0049.99110.46
Shan, Aaron,2073068.970.000.000.0068.97
Wright, Amber, L,239241129.480.000.000.001129.48
Nara, Roger,26928597.950.000.000.00597.95
Beck, Damien, E,2398958.980.000.0058.980.00
Martinez, Michele, L,1924724.990.000.0024.990.00
Sánchez, Cesar, W,239881179.470.000.000.001179.47
Kelly, Marcus, A,2569947.970.000.000.0047.97
Sharma, Barbara, D,2242158.980.000.000.0058.98
Luo, Terry, H,2685053.980.000.000.0053.98
Mehta, Ronald, F,176493.990.000.003.990.00
Lin, Cara,294111223.840.000.001223.840.00
Blanco, Joe,25675548.980.000.00548.980.00
Howard, Victoria, L,2152532.270.000.0032.270.00
Kapoor, Sergio, E,1939227.280.000.0027.280.00
Fernandez, Stanley, R,240644.990.000.004.990.00
Hu, Louis,1618734.920.000.000.0034.92
Raji, Edwin,1146925.480.000.000.0025.48
Carlson, Natasha,21136106.930.000.000.00106.93
Lopez, Edward, L,26931561.480.000.000.00561.48
Martinez, Molly, S,13603133.940.000.0083.9749.97
Serrano, Jill,240261212.970.000.000.001212.97
Davis, Zachary, L,1657997.950.000.000.0097.95
Blanco, Meghan,1796173.960.000.000.0073.96
Ye, Dawn,254881120.490.000.000.001120.49
Malhotra, Meagan, L,2782725.480.000.000.0025.48
Jai, Terrence,27956553.970.000.00553.970.00
Gomez, Kristi,269113.990.000.003.990.00
Blanco, Gina,2891823.780.000.0023.780.00
Sai, Marie, A,245822466.320.000.000.002466.32
Raman, Kristina,26932574.980.000.000.00574.98
Garcia, Douglas,248602520.310.000.000.002520.31
Sun, Alejandro, B,239231174.480.000.000.001174.48
Nath, Tonya,248472552.820.000.000.002552.82
Vazquez, Pedro, A,1568672.580.000.0032.6039.98
Raman, Ebony,1934821.490.000.0021.490.00
Martin, Dalton, J,1250536.590.000.0036.590.00
Xu, Mario,2641158.980.000.0058.980.00
Davis, Ashley,26407126.280.000.00126.280.00
Patel, Rebekah, R,223961725.980.000.000.001725.98
Jai, Darrell, T,2095137.270.000.000.0037.27
Zeng, Alan, M,223211700.990.000.000.001700.99
Fernandez, Deanna,2455469.970.000.000.0069.97
Anand, Tonya, A,27141574.980.000.000.00574.98
Shan, Terrence,2090732.280.000.000.0032.28
Sanders, Jessica,1765038.980.000.000.0038.98
Thompson, Morgan, Q,240111179.470.000.000.001179.47
Evans, Isaac, A,1718677.270.000.000.0077.27
Rai, Alisha,26848607.960.000.000.00607.96
Gonzalez, Stefanie, J,287092419.060.000.002419.060.00
Sai, Tabitha,25741567.760.000.00567.760.00
King, Wyatt,226711155.480.000.001155.480.00
Moreno, Lee,2563253.980.000.0053.980.00
Zeng, Darryl, C,2092937.270.000.0037.270.00
Gutierrez, Marie, F,294311249.840.000.001249.840.00
Raman, Holly,254773.990.000.000.003.99
Perez, Dominic, A,239401120.490.000.000.001120.49
Robinson, Jasmine,26886553.970.000.000.00553.97
Rogers, Bryan,26890588.960.000.000.00588.96
Wu, Colleen,1929128.980.000.0028.980.00
Sanchez, Morgan, J,12262119.450.000.0060.4758.98
Beck, Christine,20714187.980.000.00187.980.00
Gill, Adrienne,14953202.460.000.00202.460.00
Anand, Sharon,2620848.970.000.000.0048.97
Lu, Mandy,1498836.270.000.000.0036.27
Ruiz, Ruben, A,2005582.970.000.000.0082.97
Wagner, Deb, R,240301170.480.000.000.001170.48
Serrano, Daisy, P,241871155.480.000.000.001155.48
Washington, Destiny,2281232.280.000.000.0032.28
Suri, Terrance, C,2104634.980.000.000.0034.98
Xu, Jorge, A,14955103.970.000.000.00103.97
Long, Miguel,2485339.980.000.000.0039.98
She, Raul,1949728.980.000.000.0028.98
Stone, Stephanie, S,1906029.930.000.0029.930.00
Li, Susan,278392419.060.000.002419.060.00
Wang, Franklin, S,2938627.770.000.0027.770.00
Carlson, Dana, H,1486332.280.000.0032.280.00
Clark, Devin,2551238.980.000.0038.980.00
Young, Evan,1273935.000.000.000.0035.00
Henderson, Anna,248574.990.000.000.004.99
Navarro, Audrey, S,26937619.460.000.000.00619.46
Lin, Alejandro, L,12563118.960.000.000.00118.96
Davis, Edward,2889621.490.000.0021.490.00
Vance, Gerald, M,2784160.470.000.0060.470.00
Torres, Cheryl, T,25727539.990.000.00539.990.00
Xie, Katrina, M,2689738.980.000.0038.980.00
Deng, Corey,28921184.480.000.00184.480.00
Alonso, Hector, L,1213497.450.000.000.0097.45
Pal, Kristin, E,26956607.960.000.000.00607.96
Tang, Colleen, A,25731548.980.000.00548.980.00
Liang, Sandra, J,20949154.980.000.000.00154.98
Patel, Cassandra, P,1246583.420.000.000.0083.42
Wang, Dawn, L,2715238.980.000.000.0038.98
Srini, Stanley,1804229.980.000.000.0029.98
Hernandez, Larry,17840228.960.000.000.00228.96
Ortega, Stacy, M,2566938.980.000.000.0038.98
Lopez, James, E,2080627.280.000.000.0027.28
Suri, Veronica, D,239674.990.000.000.004.99
Gutierrez, Wendy,12610101.950.000.000.00101.95
Ortega, Jésus, L,1654244.970.000.000.0044.97
Zhao, Amy, C,2641688.970.000.000.0088.97
Martin, Teresa, D,2258848.970.000.000.0048.97
Chandra, Whitney,1571251.570.000.000.0051.57
Lopez, Carolyn, L,2566888.970.000.000.0088.97
Becker, Karla, M,1273064.900.000.000.0064.90
Rubio, Jamie, W,27179548.980.000.000.00548.98
Alvarez, Casey, A,285572419.060.000.000.002419.06
Butler, Adam,2792538.980.000.000.0038.98
Brown, Samuel, M,2699957.980.000.000.0057.98
Sai, Jillian,225181735.980.000.000.001735.98
Anand, Lindsey, K,225921754.980.000.000.001754.98
Subram, Holly, J,2855221.490.000.000.0021.49
Diaz, Billy,2183992.480.000.000.0092.48
Jenkins, Spencer, S,1486232.280.000.000.0032.28
Sai, Allen, E,27781574.980.000.000.00574.98
Lopez, Janelle, G,255001170.480.000.000.001170.48
Holt, Katie,279461143.460.000.000.001143.46
Carlson, Tyrone, S,226624.990.000.000.004.99
Ye, Randy, G,293672419.060.000.000.002419.06
Rubio, Casey, A,241524.990.000.000.004.99
Thompson, Noah, L,14547192.950.000.000.00192.95
Rubio, Byron,1862264.970.000.000.0064.97
Ruiz, Roy, L,287042419.060.000.000.002419.06
Hill, Miguel, C,224331764.960.000.000.001764.96
Gomez, Melody,258052501.310.000.000.002501.31
Gao, Sandra,1259437.980.000.000.0037.98
Nara, April, E,25721583.970.000.00583.970.00
Malhotra, Allen, A,1510297.350.000.000.0097.35
Zhang, Alvin,1908239.980.000.000.0039.98
Shen, Derek, T,225861739.460.000.000.001739.46
Tang, Gilbert, D,2153340.220.000.000.0040.22
Subram, Cindy, L,2394339.980.000.000.0039.98
Malhotra, Roy, P,232201174.480.000.001174.480.00
Powell, Gavin, M,28530588.960.000.000.00588.96
Suri, Clifford,1936963.970.000.000.0063.97
Zhang, Trisha,1815682.260.000.000.0082.26
Suri, Tabitha,279576.280.000.000.006.28
Vance, Kaitlin,2938323.780.000.000.0023.78
Jackson, Lucas, A,254812478.340.000.000.002478.34
Zhou, Alejandro, A,12304123.450.000.000.00123.45
Subram, Lydia, F,285492418.050.000.000.002418.05
Ruiz, Kendra,255981151.760.000.000.001151.76
Guo, Clayton, J,223021763.970.000.000.001763.97
Sanchez, Heidi,28438574.980.000.000.00574.98
Campbell, Andrea,256896.280.000.000.006.28
Tang, Kenneth,28477548.980.000.000.00548.98
Ortega, Leslie,2485129.480.000.000.0029.48
Gill, Julio, R,2699338.980.000.000.0038.98
Hu, Jake, L,2457689.970.000.000.0089.97
Randall, Tammy, C,1379836.270.000.000.0036.27
Luo, Sharon, D,1155321.490.000.000.0021.49
Ruiz, Briana,2090632.280.000.000.0032.28
Zhao, Kelli,263861775.470.000.000.001775.47
Nara, Damien, W,2687738.980.000.000.0038.98
Anderson, Kaitlyn, H,241011170.480.000.000.001170.48
Cai, Rosa,226181700.990.000.000.001700.99
Xie, Edwin, E,28879102.960.000.000.00102.96
Luo, Leonard, A,255821164.470.000.000.001164.47
Gill, Philip,225991700.990.000.000.001700.99
Andersen, Dale, B,1499269.990.000.000.0069.99
Deng, Yolanda,28427539.990.000.000.00539.99
Srini, Molly, L,27790562.960.000.000.00562.96
She, Deborah,255761170.480.000.000.001170.48
Gutierrez, Daisy,21541149.980.000.000.00149.98
Fernandez, Harold, C,293592453.040.000.000.002453.04
Morgan, Lauren,242171209.470.000.000.001209.47
Gonzales, Isabella, R,1481563.970.000.000.0063.97
Andersen, Tamara, B,293922393.060.000.000.002393.06
Rivera, Katelyn,2394868.490.000.000.0068.49
Zhu, Arturo, M,245754.990.000.000.004.99
Henderson, Tristan,1222484.980.000.000.0084.98
She, Warren,2182427.280.000.000.0027.28
Diaz, Mariah,254651155.480.000.000.001155.48
Sai, Marco,2484029.480.000.000.0029.48
Prasad, Rachael, M,225351750.980.000.000.001750.98
Cox, Andrea,1383088.970.000.000.0088.97
Torres, Janet, J,2398539.980.000.000.0039.98
Romero, Lori, A,2873860.470.000.000.0060.47
Anderson, Benjamin,2080932.280.000.000.0032.28
Sanz, Neil, M,2262258.980.000.000.0058.98
Lee, Emily,2058532.270.000.000.0032.27
Ortega, Robyn,241041155.480.000.000.001155.48
Lu, Dawn, G,2783321.490.000.000.0021.49
Howard, Jennifer,1626461.960.000.000.0061.96
Thomas, Miguel,254801120.490.000.000.001120.49
Alvarez, Roberto,28387583.970.000.000.00583.97
Malhotra, Troy,1156934.990.000.000.0034.99
Luo, Tony, W,2942321.490.000.000.0021.49
Garcia, Kristina,254461151.760.000.000.001151.76
Rai, Arturo, T,225041735.980.000.000.001735.98
Moore, Anna, A,1274471.970.000.000.0071.97
Sanz, Jay,28503578.460.000.000.00578.46
Kumar, Dustin, R,2684628.480.000.000.0028.48
Evans, Hunter,254931243.440.000.000.001243.44
Ye, Micah, A,2095237.270.000.000.0037.27
She, Omar, K,1544812.940.000.000.0012.94
Deng, Julie,2563138.980.000.000.0038.98
Garcia, Bruce, B,1803749.480.000.000.0049.48
Guo, Stacey,242074.990.000.000.004.99
Cooper, Steven,164356.280.000.000.006.28
Vance, Martin, A,256041174.480.000.000.001174.48
Chandra, Summer, D,2488039.980.000.000.0039.98
Suarez, Sheila,2888411.940.000.000.0011.94
Vance, Douglas,1638794.960.000.000.0094.96
Wu, Heather, M,1926182.970.000.000.0082.97
Ramos, Jamie, L,27852574.980.000.000.00574.98
Chandra, Sergio, A,2283769.970.000.000.0069.97
Shan, Cristina,14783158.960.000.000.00158.96
Chen, Krystal, D,13530186.280.000.000.00186.28
Madan, Douglas,269716.280.000.000.006.28
Blue, Oscar, L,27008616.950.000.000.00616.95
Travers, Linda,2942053.990.000.000.0053.99
Taylor, Grace,2407368.490.000.000.0068.49
Romero, Robyn, C,27802561.480.000.000.00561.48
Rai, Barbara, J,224511709.980.000.000.001709.98
Black, Nichole,224221735.980.000.000.001735.98
Rivera, Chase,28511562.960.000.000.00562.96
Zeng, Kelvin, A,262072443.350.000.000.002443.35
Zheng, Mandy,2472189.970.000.000.0089.97
Becker, Louis, J,241931199.460.000.000.001199.46
Perez, Meagan, R,2110132.280.000.000.0032.28
Smith, Destiny,224281739.460.000.000.001739.46
Jenkins, Blake,2890723.780.000.000.0023.78
Ms., Shock, Misty,2486939.980.000.000.0039.98
Xu, Shaun, N,2780453.980.000.000.0053.98
Rodriguez, Dominic, E,28525574.980.000.000.00574.98
Zhao, Omar,279273.990.000.000.003.99
Anand, Alejandro, R,2889960.470.000.000.0060.47
Bryant, Ian,273191775.470.000.000.001775.47
Gutierrez, Roberto,1135513.980.000.000.0013.98
Martinez, Richard, J,1498668.970.000.000.0068.97
Rana, Brett, L,2094337.270.000.000.0037.27
Jones, Lucas,271586.280.000.000.006.28
Moreno, Briana, L,287342419.060.000.000.002419.06
Sanz, Philip, J,1780781.240.000.000.0081.24
Andersen, Damien, K,2940253.990.000.000.0053.99
Suarez, Kendra,2361532.280.000.000.0032.28
Sun, Autumn, A,2256458.980.000.000.0058.98
Hu, Candice,27818607.960.000.000.00607.96
Washington, Faith,2084969.970.000.000.0069.97
Campbell, Katherine, P,2844821.490.000.000.0021.49
Navarro, Wendy, C,2088178.960.000.000.0078.96
Lu, Erica,27009574.980.000.000.00574.98
Goel, Katrina,216827.280.000.000.007.28
Carlson, Desiree, V,1486469.970.000.000.0069.97
Blanco, Beth,2944425.480.000.000.0025.48
Xie, Melvin,2842660.470.000.000.0060.47
Torres, Julio,224601750.980.000.000.001750.98
Sanchez, Gerald,2414439.980.000.000.0039.98
Pal, Karl, S,19187147.280.000.000.00147.28
Vazquez, Lance,1137678.480.000.000.0078.48
Vance, Francisco, A,2097269.970.000.000.0069.97
Alvarez, Neil, C,224671732.260.000.000.001732.26
Navarro, Micheal,2362578.960.000.000.0078.96
_SUM3388349.72147564.90556071.90928480.901756232.02

Generated 2025-11-02 00:38:25.976 UTC