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

390 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Thomas, Ryan,225324.990.000.000.004.99
Sai, Allen, E,27781574.980.000.000.00574.98
Ruiz, Kendra,255981151.760.000.000.001151.76
Kumar, Nichole,232367.280.000.000.007.28
Rana, Lydia,2939513.980.000.000.0013.98
Gutierrez, Kristy,241381194.970.000.000.001194.97
Zheng, Nuan,13604132.940.000.000.00132.94
Raji, Tracy,224391700.990.000.000.001700.99
Xie, Melvin,2842660.470.000.000.0060.47
Wu, Cedric, E,2102569.970.000.000.0069.97
Liang, Mandy,28371539.990.000.000.00539.99
Martinez, Donald, D,25482162.990.000.000.00162.99
Coleman, Christian,257982452.340.000.000.002452.34
Huang, Jeffery,257556.280.000.000.006.28
Martin, Alexander, K,164024.990.000.000.004.99
Zhang, Randy,1260155.910.000.000.0055.91
Ruiz, Briana,2090632.280.000.000.0032.28
Hill, Miguel, C,224331764.960.000.000.001764.96
Cai, Rosa,226181700.990.000.000.001700.99
Sun, Trisha,224421709.980.000.000.001709.98
Nara, Terrence, R,28474565.470.000.000.00565.47
Hu, Vincent, F,28372607.960.000.000.00607.96
Jai, Lindsey, W,2397198.960.000.000.0098.96
Jai, Grant,242001120.490.000.000.001120.49
Black, Tara,2421648.970.000.000.0048.97
Liang, Marshall, J,254471164.470.000.000.001164.47
Andersen, Kelli,226021754.980.000.000.001754.98
Baker, Seth,2152032.270.000.000.0032.27
Adams, Ian, C,2942262.980.000.000.0062.98
Carlson, Derrick, R,28436617.470.000.000.00617.47
Pal, Karl, S,19187147.280.000.000.00147.28
Yang, Jackson,225701735.980.000.000.001735.98
Vazquez, Lance,1137678.480.000.000.0078.48
Xu, Omar, A,225961750.980.000.000.001750.98
Shan, Sharon, A,242111170.480.000.000.001170.48
Zhou, Rosa, D,255731155.480.000.000.001155.48
Hughes, Amanda,16189105.940.000.000.00105.94
Sun, Alejandro, B,239231174.480.000.000.001174.48
Nath, Tonya,248472552.820.000.000.002552.82
Pal, Michele,17814133.930.000.0029.98103.95
Hernandez, Mason, C,2778247.970.000.0047.970.00
Guo, Christy, R,2363969.970.000.0069.970.00
Ramos, Julio,1255125.480.000.000.0025.48
Patel, Rebekah, R,223961725.980.000.000.001725.98
Jai, Darrell, T,2095137.270.000.000.0037.27
Rodriguez, Janelle,268876.280.000.000.006.28
Mr., Thompson, Austin,12513241.760.000.000.00241.76
Thompson, Morgan, Q,240111179.470.000.000.001179.47
Sr., Cai, Ramón, S,16599149.460.000.000.00149.46
Black, Mario, M,2790521.490.000.000.0021.49
Ramos, Tabitha,2014737.970.000.000.0037.97
Chandra, Ronald, H,2080174.980.000.000.0074.98
Sai, Tabitha,25741567.760.000.00567.760.00
Deng, Brendan,25726663.440.000.00663.440.00
Wu, Ramon, M,2795538.980.000.000.0038.98
Allen, Jada,26866615.460.000.000.00615.46
Rogers, Bryan,26890588.960.000.000.00588.96
Subram, Sergio,28386600.460.000.000.00600.46
James, Jade, M,26400132.980.000.00132.980.00
Pal, Corey,257742537.320.000.000.002537.32
Sanz, Mallory,14938107.970.000.0078.9828.99
Andersen, Dale, B,1499269.990.000.000.0069.99
Romero, Nelson,25728574.980.000.00574.980.00
Zeng, Kelli, M,2282578.960.000.000.0078.96
Yuan, Kelvin, L,2569266.970.000.0066.970.00
Shen, Carl, L,1919027.280.000.000.0027.28
Tang, Alvin, L,2167842.930.000.0042.930.00
Lal, Bonnie, A,29445182.780.000.000.00182.78
Vance, Douglas,1638794.960.000.000.0094.96
She, Omar, K,1544812.940.000.000.0012.94
Blue, Oscar, L,27008616.950.000.000.00616.95
Deng, Julie,2563138.980.000.000.0038.98
Weber, Stanley, E,12311116.430.000.000.00116.43
Ramos, Linda,2359832.280.000.000.0032.28
Romero, Robyn, C,27802561.480.000.000.00561.48
Chander, Nichole, H,2845130.480.000.000.0030.48
Alonso, Albert, M,17645132.270.000.000.00132.27
Lal, Nichole, P,257533.990.000.000.003.99
Butler, Adam,2792538.980.000.000.0038.98
Chander, Christy, E,2154836.930.000.000.0036.93
Lu, Rafael, J,2286939.980.000.000.0039.98
Martinez, Dalton, M,2841323.780.000.000.0023.78
Baker, Caleb, F,2396839.980.000.000.0039.98
Rivera, Katelyn,2394868.490.000.000.0068.49
Diaz, Mariah,254651155.480.000.000.001155.48
Sai, Jillian,225181735.980.000.000.001735.98
Kumar, Grant, A,255101212.950.000.000.001212.95
Smith, Destiny,224281739.460.000.000.001739.46
Sun, Rosa,2690047.970.000.000.0047.97
Sun, Alisha,1804864.970.000.000.0064.97
Howard, Jennifer,1626461.960.000.000.0061.96
Holt, Katie,279461143.460.000.000.001143.46
Young, Henry,1240367.270.000.000.0067.27
Patel, Dominic,293662419.060.000.000.002419.06
Xu, Melvin, A,1147449.970.000.000.0049.97
Martinez, Richard, J,1498668.970.000.000.0068.97
Jones, Lucas,271586.280.000.000.006.28
Nara, Kara, E,245664.990.000.000.004.99
Arun, Chelsea, M,255111134.470.000.000.001134.47
Alexander, Riley,2279934.980.000.000.0034.98
Sharma, Dylan,1906684.960.000.000.0084.96
Gao, Sandra,1259437.980.000.000.0037.98
Malhotra, Allen, A,1510297.350.000.000.0097.35
Gonzalez, Allen,255721169.460.000.000.001169.46
Brown, Richard, M,293572398.050.000.000.002398.05
Subram, Cindy, L,2394339.980.000.000.0039.98
Torres, Teresa, M,1618839.980.000.000.0039.98
Alvarez, Julio,262052451.300.000.000.002451.30
Lin, Vincent, A,28516563.770.000.000.00563.77
Vazquez, Carrie,2941953.990.000.000.0053.99
Carlson, Desiree, V,1486469.970.000.000.0069.97
Andersen, Tamara, B,293922393.060.000.000.002393.06
Zhao, Rafael,1341245.260.000.000.0045.26
She, Warren,2182427.280.000.000.0027.28
Hernandez, Kristi, L,226351728.270.000.000.001728.27
Zhou, Damien,257762514.610.000.000.002514.61
Guo, Crystal,19379103.460.000.000.00103.46
Navarro, Micheal,2362578.960.000.000.0078.96
Schmidt, Derrick, R,226051750.980.000.000.001750.98
He, Arturo,293692422.540.000.000.002422.54
Nara, Terry,273051714.970.000.000.001714.97
Hu, Sandra, N,27817563.770.000.000.00563.77
Chandra, Summer, D,2488039.980.000.000.0039.98
Barnes, Vanessa,1381053.470.000.000.0053.47
Evans, Lucas, J,1155621.490.000.000.0021.49
Tang, Brad,254891147.770.000.000.001147.77
Hu, Candice,27818607.960.000.000.00607.96
Gonzalez, Troy, A,28517578.460.000.000.00578.46
Liang, Clayton, E,1495829.480.000.000.0029.48
Rodriguez, Manuel, A,246971170.480.000.000.001170.48
She, Terry, R,254541155.480.000.000.001155.48
Black, Nicolas,239454.990.000.000.004.99
Schmidt, Meredith,2549938.980.000.000.0038.98
Arun, Henry, L,2717728.480.000.000.0028.48
Roberts, Nathan,2947060.470.000.000.0060.47
Rai, Darrell, C,2690667.490.000.000.0067.49
Randall, Mayra,27909548.980.000.000.00548.98
Gill, Julio, R,2699338.980.000.000.0038.98
Alexander, Ana, R,226371714.970.000.000.001714.97
Nara, Damien, W,2687738.980.000.000.0038.98
Luo, Leonard, A,255821164.470.000.000.001164.47
Romero, Eddie,2888338.980.000.000.0038.98
Srini, Ronald, E,164674.990.000.000.004.99
Sanchez, Gerald,2414439.980.000.000.0039.98
Luo, Arturo,224611754.980.000.000.001754.98
Romero, Diana,1776092.250.000.000.0092.25
Vance, Francisco, A,2097269.970.000.000.0069.97
Wang, Alvin,1993948.970.000.000.0048.97
Zhu, Arturo, M,245754.990.000.000.004.99
Bailey, Garrett,1905545.950.000.000.0045.95
Rubio, Rebekah,2469929.480.000.000.0029.48
Guo, Brittney, B,224561728.270.000.000.001728.27
Martinez, Francisco,1137513.980.000.000.0013.98
Raji, Tommy,256361174.480.000.000.001174.48
Sanz, Jay,28503578.460.000.000.00578.46
Kumar, Dustin, R,2684628.480.000.000.0028.48
Simmons, Wyatt, V,226041735.980.000.000.001735.98
Williams, Jennifer, E,1945792.480.000.000.0092.48
Garcia, Arthur, T,2941353.990.000.000.0053.99
Cooper, Steven,164356.280.000.000.006.28
Munoz, Arthur, L,226081744.970.000.000.001744.97
Suarez, Sheila,2888411.940.000.000.0011.94
She, Kurt,262062478.340.000.000.002478.34
Davis, Lucas, S,1937824.990.000.000.0024.99
Zhu, Stacey, E,226361700.990.000.000.001700.99
Sandoval, Giraldo, Hierro,226341775.470.000.000.001775.47
Goel, Kathryn,1274044.980.000.000.0044.98
Deng, Lindsay, K,2944723.780.000.000.0023.78
Wright, Elijah, I,255771155.480.000.000.001155.48
Martin, Audrey,13791107.850.000.000.00107.85
Luo, Terry, H,2685053.980.000.000.0053.98
Mehta, Ronald, F,176493.990.000.003.990.00
Rivera, Garrett,226421198.970.000.001198.970.00
Sanz, Krista,278063.990.000.003.990.00
Lopez, Edward, L,26931561.480.000.000.00561.48
Collins, Richard, S,1625681.960.000.000.0081.96
Yang, Ramon, K,1360998.960.000.000.0098.96
Navarro, Robin, J,286962428.050.000.000.002428.05
Hu, Louis,1618734.920.000.000.0034.92
Perry, Hailey, G,2072124.990.000.000.0024.99
Raji, Edwin,1146925.480.000.000.0025.48
Gomez, Kristi,269113.990.000.003.990.00
Blanco, Gina,2891823.780.000.0023.780.00
Blanco, Jessie, R,236082510.940.000.002510.940.00
Rana, Andre,27904156.760.000.00156.760.00
Garcia, Abigail,14531190.540.000.00190.540.00
Rai, Jon,25642583.970.000.00583.970.00
Chander, Kelli,26934553.970.000.000.00553.97
Lopez, Holly,26876588.960.000.000.00588.96
Sanz, Latasha,2938423.780.000.000.0023.78
Raman, Kristina,26932574.980.000.000.00574.98
Chandra, Roy, R,245832487.330.000.000.002487.33
Townsend, Michelle, P,1286486.240.000.0036.2749.97
Sanz, Naomi,1284039.980.000.0039.980.00
Chander, Peter, L,14836115.250.000.0078.9836.27
Rana, Summer, M,25703607.960.000.00607.960.00
Sun, Omar, D,257834.990.000.004.990.00
Torres, Lawrence,1567131.550.000.007.2824.27
Saunders, Cynthia,245372511.320.000.002511.320.00
Davis, Ashley,26407126.280.000.00126.280.00
Zeng, Alan, M,223211700.990.000.000.001700.99
Fernandez, Deanna,2455469.970.000.000.0069.97
Patel, Bruce,271653.990.000.000.003.99
Moyer, Philip, M,16386129.950.000.000.00129.95
Rana, Kristina,2784723.780.000.000.0023.78
Ruiz, Neil, N,294772428.050.000.000.002428.05
Lopez, Jonathan, D,15103107.850.000.0071.5836.27
Gonzalez, Stefanie, J,287092419.060.000.002419.060.00
Gill, Darren, M,1140834.470.000.0034.470.00
Dominguez, Teresa, C,2096342.930.000.0042.930.00
Perez, Dominic, A,239401120.490.000.000.001120.49
Robinson, Jasmine,26886553.970.000.000.00553.97
He, Clarence,16591137.960.000.000.00137.96
Moreno, Reginald, H,1605076.940.000.0039.9836.96
Sanz, Joanna, L,25732638.950.000.00638.950.00
Anand, Dustin,14535123.470.000.00123.470.00
Lin, Randy,14540156.250.000.0036.27119.98
Xu, Gilbert,225544.990.000.004.990.00
Lal, Lacey, L,237511155.480.000.001155.480.00
Gill, Adrienne,14953202.460.000.00202.460.00
Scott, Kyle, D,11419231.750.000.00182.7848.97
Washington, Destiny,2281232.280.000.000.0032.28
Suri, Terrance, C,2104634.980.000.000.0034.98
Jimenez, Michele,1354783.950.000.000.0083.95
Liang, Jessie,1951324.990.000.000.0024.99
Martinez, Carla,248522457.330.000.000.002457.33
Wagner, Deb, R,240301170.480.000.000.001170.48
Dominguez, Natasha,2376929.480.000.0029.480.00
Ms., Smith, Samantha,294072452.040.000.000.002452.04
Wang, Christy,1949831.270.000.000.0031.27
King, Adam, M,1693214.560.000.000.0014.56
Sanchez, Ruben, S,1368827.280.000.000.0027.28
Subram, Mayra, C,284462398.050.000.000.002398.05
Suri, Henry,216831779.470.000.000.001779.47
Wu, Crystal, W,2267229.480.000.000.0029.48
Sara, Manuel,1261167.460.000.000.0067.46
Kumar, Peter,2691558.980.000.000.0058.98
Malhotra, Michele, A,2689612.980.000.0012.980.00
Alvarez, Lance, J,1619079.250.000.007.2871.97
Xie, Katrina, M,2689738.980.000.0038.980.00
Raman, Francisco, M,2402013.980.000.000.0013.98
Martin, Paula, B,21855579.970.000.000.00579.97
Cox, Melanie, C,12496204.580.000.000.00204.58
Srini, Martin, L,1862924.990.000.000.0024.99
Kapoor, George, L,1367668.870.000.0036.2732.60
Tang, Gilbert, D,2153340.220.000.000.0040.22
Dominguez, Victor, K,14784156.250.000.000.00156.25
Hu, Steve, A,1629413.980.000.000.0013.98
Srini, Cesar,1156353.990.000.000.0053.99
Goel, Willie, T,226561169.460.000.001169.460.00
Nara, April, E,25721583.970.000.00583.970.00
Ortega, Jésus, L,1654244.970.000.000.0044.97
Zhao, Amy, C,2641688.970.000.000.0088.97
Guo, Clayton, J,223021763.970.000.000.001763.97
Campbell, Andrea,256896.280.000.000.006.28
Malhotra, Roy, P,232201174.480.000.001174.480.00
Foster, Mya, M,232301155.480.000.001155.480.00
Ramos, Janet, B,2059632.270.000.000.0032.27
Madan, Carolyn,26222561.480.000.000.00561.48
Morgan, Taylor, M,248702457.330.000.000.002457.33
Yuan, Drew, R,216791700.990.000.000.001700.99
Mr., Saravan, K.,14974158.950.000.000.00158.95
Ramos, Orlando,2415429.480.000.000.0029.48
Ortega, Stacy, M,2566938.980.000.000.0038.98
Mr., Shridhar, Shish,25761562.960.000.000.00562.96
Lopez, Carolyn, L,2566888.970.000.000.0088.97
Zhao, Kelli,263861775.470.000.000.001775.47
Madan, Donald, R,2716867.490.000.000.0067.49
Black, Willie,1817239.980.000.000.0039.98
Madan, Edgar, M,27131603.490.000.000.00603.49
Munoz, Stacy,12310103.960.000.000.00103.96
Perez, Francisco, M,1783569.960.000.000.0069.96
Torres, Janet, J,2398539.980.000.000.0039.98
Pal, Maurice,26929588.960.000.000.00588.96
Anderson, Benjamin,2080932.280.000.000.0032.28
Sanz, Neil, M,2262258.980.000.000.0058.98
Diaz, Billy,2183992.480.000.000.0092.48
Ms., Slattengren, Dianne, K.,279281120.490.000.000.001120.49
Ortega, Robyn,241041155.480.000.000.001155.48
Black, Raul,253011170.480.000.000.001170.48
Lopez, Raymond, G,273176.280.000.000.006.28
Raman, Darren, K,2231539.980.000.000.0039.98
Jimenez, Rodney, R,1247673.770.000.000.0073.77
Carlson, Jerome, J,21817791.470.000.000.00791.47
Green, Morgan, M,2846960.470.000.000.0060.47
Gutierrez, Raquel, H,286972452.040.000.000.002452.04
Moore, Anna, A,1274471.970.000.000.0071.97
Black, Tamara, L,242021120.490.000.000.001120.49
Ruiz, Roy, L,287042419.060.000.000.002419.06
Shan, Jon,2415158.980.000.000.0058.98
Alonso, Micheal, W,19307148.980.000.000.00148.98
Deng, Jerry,22813119.960.000.000.00119.96
Thompson, Emma, C,1944563.970.000.000.0063.97
Russell, Carson,2111678.960.000.000.0078.96
Deng, Dale,28399553.970.000.000.00553.97
Chande, Priscilla,293582384.070.000.000.002384.07
Ye, Kelli,1947074.980.000.000.0074.98
Zhou, Alejandro, A,12304123.450.000.000.00123.45
Navarro, Erika, K,1147653.990.000.000.0053.99
Tang, Carly, A,224701735.980.000.000.001735.98
Xu, Omar, R,1927963.970.000.000.0063.97
Morgan, Lauren,242171209.470.000.000.001209.47
Suarez, Clinton,2265739.980.000.000.0039.98
Shan, Nichole, K,1946124.990.000.000.0024.99
Liu, Mandy,1788829.980.000.000.0029.98
Suarez, Felicia, W,287032419.060.000.000.002419.06
Alexander, Isabel,2282343.970.000.000.0043.97
Blanco, Meghan,1796173.960.000.000.0073.96
Raman, Rebekah, E,2245412.940.000.000.0012.94
Wang, Lisa, J,1720574.980.000.000.0074.98
Shan, Lindsay,27186600.460.000.000.00600.46
Rana, Cesar, L,1904429.930.000.000.0029.93
Wu, Heather, M,1926182.970.000.000.0082.97
Rubio, Jill,13838140.550.000.000.00140.55
Ramos, Jamie, L,27852574.980.000.000.00574.98
Chen, Krystal, D,13530186.280.000.000.00186.28
Zhou, Curtis,2550538.980.000.000.0038.98
Prasad, Regina, A,241921155.480.000.000.001155.48
Travers, Linda,2942053.990.000.000.0053.99
Taylor, Grace,2407368.490.000.000.0068.49
Suri, Joe,2102837.270.000.000.0037.27
Sharma, Nichole, M,1469236.270.000.000.0036.27
Deng, Yolanda,28427539.990.000.000.00539.99
She, Deborah,255761170.480.000.000.001170.48
Raji, Cristina, E,255061155.480.000.000.001155.48
Mr., Sneath, Timothy,1770829.480.000.000.0029.48
Jenkins, Connor,2080063.970.000.000.0063.97
Arun, Donald, B,1693394.960.000.000.0094.96
Becker, Louis, J,241931199.460.000.000.001199.46
Henderson, Tristan,1222484.980.000.000.0084.98
Anand, Lindsey, K,225921754.980.000.000.001754.98
Subram, Holly, J,2855221.490.000.000.0021.49
Raji, Marshall, L,27175565.470.000.000.00565.47
Jenkins, Blake,2890723.780.000.000.0023.78
Romero, Armando, A,1259668.970.000.000.0068.97
Alvarez, Roberto,28387583.970.000.000.00583.97
Gutierrez, Roberto,1135513.980.000.000.0013.98
Russell, Natalie, M,2090078.960.000.000.0078.96
Alvarez, Ebony, M,28428603.490.000.000.00603.49
Nara, Louis, J,269013.990.000.000.003.99
Ye, Randy, G,293672419.060.000.000.002419.06
Williams, Emma, K,16325171.270.000.000.00171.27
Kelly, Carlos, C,2856123.780.000.000.0023.78
Thompson, Noah, L,14547192.950.000.000.00192.95
Garcia, Kristina,254461151.760.000.000.001151.76
Deng, Chad,226111775.470.000.000.001775.47
Rubio, Byron,1862264.970.000.000.0064.97
Sanz, Philip, J,1780781.240.000.000.0081.24
Suarez, Kendra,2361532.280.000.000.0032.28
Goel, Tasha, R,1947823.780.000.000.0023.78
Sun, Autumn, A,2256458.980.000.000.0058.98
Shen, Derek, T,225861739.460.000.000.001739.46
Pal, Damien, M,225661700.990.000.000.001700.99
Washington, Faith,2084969.970.000.000.0069.97
Martin, Shannon, W,240454.990.000.000.004.99
Shen, Damien, C,1496448.970.000.000.0048.97
Malhotra, Ivan, E,1155821.490.000.000.0021.49
Ms., Smith, Mary, J.,28437567.760.000.000.00567.76
Gray, Allison, D,2057124.990.000.000.0024.99
Blanco, Beth,2944425.480.000.000.0025.48
Srini, Whitney,1156053.990.000.000.0053.99
Shan, Carly,1863124.990.000.000.0024.99
Alonso, Francis, J,2173869.970.000.000.0069.97
Tang, Kenneth,28477548.980.000.000.00548.98
Torres, Julio,224601750.980.000.000.001750.98
Gomez, Neil,2942625.480.000.000.0025.48
Foster, Mary,241121155.480.000.000.001155.48
Randall, Tammy, C,1379836.270.000.000.0036.27
Cook, Jade, C,2568712.980.000.000.0012.98
Cox, Cole, M,253156.280.000.000.006.28
Rowe, Kristi, R,28692539.990.000.000.00539.99
Cox, Andrea,1383088.970.000.000.0088.97
Russell, Aaron,255991174.480.000.000.001174.48
Romero, Jaime, B,28508574.980.000.000.00574.98
Suarez, Marie,2942960.470.000.000.0060.47
Evans, Hunter,254931243.440.000.000.001243.44
Suri, Dominique,255841169.460.000.000.001169.46
Jai, Shawn, E,255011155.480.000.000.001155.48
Alvarez, Mallory, L,2112456.960.000.000.0056.96
Munoz, Meghan, P,27810578.460.000.000.00578.46
Fernandez, Bruce, E,2688838.980.000.000.0038.98
Kim, Carmen,255021174.480.000.000.001174.48
Roberts, Mackenzie,2359942.930.000.000.0042.93
Clark, Marcus, G,2795838.980.000.000.0038.98
Vance, Martin, A,256041174.480.000.000.001174.48
Yang, Luke,2852660.470.000.000.0060.47
Rubio, Dwayne, D,28527563.770.000.000.00563.77
Zeng, Kelvin, A,262072443.350.000.000.002443.35
Shan, Grant,2621513.980.000.000.0013.98
_SUM3388349.72147564.90553000.04930690.111757094.67

Generated 2025-11-03 01:30:08.516 UTC