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

394 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Xie, Melvin,2842660.470.000.000.0060.47
Kumar, Arturo, W,240441174.480.000.000.001174.48
Ramos, Tabitha,2014737.970.000.000.0037.97
Gomez, Neil,2942625.480.000.000.0025.48
Navarro, Lance, C,208502556.940.000.00782.991773.95
Goel, Calvin, J,17213179.950.000.000.00179.95
Kovar, Kristina, R,26910588.960.000.000.00588.96
Torres, Katelyn, L,2080424.990.000.000.0024.99
Rubio, Dwayne, D,28527563.770.000.000.00563.77
Lopez, Cassandra,223081768.960.000.000.001768.96
Sanz, Frank, T,208512518.970.000.00782.991735.98
She, Kurt,262062478.340.000.000.002478.34
Adams, Sean, J,162934.990.000.000.004.99
Carlson, Lee, S,2107937.270.000.000.0037.27
Zeng, Kelvin, A,262072443.350.000.000.002443.35
Kumar, Peter,2691558.980.000.000.0058.98
Zhang, Colleen, L,165623001.040.000.002181.56819.48
Tang, Colleen, A,25731548.980.000.000.00548.98
Alvarez, Neil, C,224671732.260.000.000.001732.26
Tang, Nicolas, S,122825111.440.000.002049.103062.34
Ramos, Janet, B,2059632.270.000.000.0032.27
Zhou, Damien,257762514.610.000.000.002514.61
Gao, Lacey, C,165313291.800.000.002443.35848.45
Kapoor, Jillian, R,1570178.860.000.000.0078.86
Schmidt, Billy,224341735.980.000.000.001735.98
Yuan, Kurt,165613030.030.000.002181.56848.47
Arun, Rachael, J,239764.990.000.000.004.99
Malhotra, Frederick,1795127.280.000.000.0027.28
Vance, Ebony,2072424.990.000.000.0024.99
Madan, Carolyn,26222561.480.000.000.00561.48
Zhu, Laura, M,2943923.780.000.000.0023.78
Lal, Jerry, L,2782234.470.000.000.0034.47
Navarro, Wendy, C,2088178.960.000.000.0078.96
Pal, Kristin, E,26956607.960.000.000.00607.96
Jenkins, Nathan, M,122865254.880.000.002049.103205.78
Kapoor, Nancy, L,18024149.980.000.000.00149.98
Vazquez, Melinda, C,2255348.970.000.000.0048.97
Hu, Tiffany, A,208562483.980.000.00782.991700.99
Ortega, Stacy, M,2566938.980.000.000.0038.98
Barnes, Alexis, J,239354.990.000.000.004.99
Kelly, Brianna, C,169453262.830.000.002443.35819.48
Mr., Shridhar, Shish,25761562.960.000.000.00562.96
Mitchell, Jose, F,2456813.980.000.000.0013.98
Chen, Dennis, M,176273021.020.000.002181.56839.46
Lopez, Samuel, L,26858553.970.000.000.00553.97
Hu, Jake, L,2457689.970.000.000.0089.97
Patterson, Jessica,171826950.600.000.002181.564769.04
Perez, Dominic, A,239401120.490.000.000.001120.49
Turner, Charles,2418812.940.000.000.0012.94
Lal, Johnny, G,123815161.730.000.002071.423090.31
Rogers, Bryan,26890588.960.000.000.00588.96
He, Warren, L,171926977.580.000.002181.564796.02
Zhu, Stacey, E,226361700.990.000.000.001700.99
Xu, Karen, E,171153008.020.000.002181.56826.46
Zhao, Omar,279273.990.000.000.003.99
Bailey, Xavier,123054940.390.000.002071.422868.97
Goel, Kathryn,1274044.980.000.000.0044.98
Chen, Tamara,123825606.260.000.002071.423534.84
Long, Kelly, G,2554538.980.000.000.0038.98
Suarez, Michele, C,125265229.380.000.002049.103180.28
Sun, Brent,255851188.460.000.000.001188.46
Prasad, Jillian,128604464.090.000.002049.102414.99
Hu, Candice,27818607.960.000.000.00607.96
Diaz, Larry, T,13664210.250.000.000.00210.25
Gonzalez, Troy, A,28517578.460.000.000.00578.46
Suri, Michele,1800738.980.000.000.0038.98
Carlson, Desiree, V,1486469.970.000.000.0069.97
Malhotra, Ruth, D,1632189.970.000.000.0089.97
Moreno, Carrie, W,271516.280.000.000.006.28
Gutierrez, Kristy,241381194.970.000.000.001194.97
Blanco, Beth,2944425.480.000.000.0025.48
Tang, Tonya,209173234.290.000.00782.992451.30
Alonso, Hector, L,1213497.450.000.000.0097.45
Suarez, Reginald,181777043.560.000.002181.564862.00
Lu, Clayton, L,2361334.980.000.000.0034.98
Lopez, Raymond, G,273176.280.000.000.006.28
Alonso, Tanya, K,26942588.960.000.000.00588.96
Sanz, Pedro,181686907.550.000.002181.564725.99
Chander, Colin, P,1284724.990.000.000.0024.99
Martinez, Donald, D,25482162.990.000.000.00162.99
Wagner, Deb, R,240301170.480.000.000.001170.48
Reed, Cole,12603117.450.000.000.00117.45
Zheng, Nuan,13604132.940.000.000.00132.94
Serrano, Frank,232321120.490.000.000.001120.49
Rana, Carolyn,2182963.970.000.000.0063.97
Torres, Devin, A,237521164.470.000.000.001164.47
Foster, Mary,241121155.480.000.000.001155.48
Chandra, Regina, M,15057114.960.000.000.00114.96
Rivera, Dalton, E,28366578.460.000.000.00578.46
Roberts, Gabrielle, E,294321307.310.000.000.001307.31
Navarro, Audrey, S,26937619.460.000.000.00619.46
Miller, Jeremiah,177172840.010.000.002181.56658.45
Lopez, Harold,26913607.960.000.000.00607.96
Liang, Krystal, S,124045251.710.000.002071.423180.29
Pal, Karl, S,19187147.280.000.000.00147.28
Malhotra, Dominique,124605678.910.000.002049.103629.81
Vance, Francisco, A,2097269.970.000.000.0069.97
Diaz, Jaime, A,177952983.340.000.002443.35539.99
Morgan, Arianna,1815548.970.000.000.0048.97
Carlson, Linda, J,126095636.900.000.002049.103587.80
Guo, Brittney, B,224561728.270.000.000.001728.27
He, Wesley, I,178493025.530.000.002181.56843.97
Navarro, Micheal,2362578.960.000.000.0078.96
Ma, Ronnie, C,178153123.780.000.002443.35680.43
Zhang, Alvin,1908239.980.000.000.0039.98
Hernandez, Renee, C,178032761.020.000.002181.56579.46
Yuan, Clarence, D,240471174.480.000.000.001174.48
Andersen, Jerry,209752515.250.000.00782.991732.26
Allen, Miguel, C,1138513.980.000.000.0013.98
Reed, Rachel, E,126446838.120.000.002049.104789.02
Jackson, Lucas, A,254812478.340.000.000.002478.34
Ye, Omar,210202497.960.000.00782.991714.97
Zhao, Amy, C,2641688.970.000.000.0088.97
Gutierrez, Renee,178963044.790.000.002443.35601.44
Guo, Clayton, J,223021763.970.000.000.001763.97
Wang, Aimee,210112527.960.000.00782.991744.97
Anderson, Kaitlyn, H,241011170.480.000.000.001170.48
Yuan, Bridget,26211565.470.000.000.00565.47
Xie, Edwin, E,28879102.960.000.000.00102.96
Cai, Jamie, S,13505127.930.000.000.00127.93
Beck, Clayton,1157943.980.000.000.0043.98
Robinson, Matthew, D,2937621.490.000.000.0021.49
Garcia, Tabitha,27778539.990.000.000.00539.99
Suarez, Max, A,14809115.250.000.000.00115.25
Parker, Eric, H,27130539.990.000.000.00539.99
Gomez, Larry, S,257782443.350.000.000.002443.35
Perez, Fernando,2784827.770.000.000.0027.77
Chander, Warren, A,179653001.040.000.002181.56819.48
Serrano, Sheila, C,210182515.250.000.00782.991732.26
Kumar, Raul, B,128574384.080.000.002049.102334.98
Diaz, Philip, J,128554414.340.000.002071.422342.92
She, Ramon,180003080.290.000.002443.35636.94
Zheng, Franklin,210442533.970.000.00782.991750.98
Vazquez, Jamie,210532542.960.000.00782.991759.97
Zeng, Valerie,179772966.030.000.002181.56784.47
Alvarez, Krista,194673485.380.000.001000.442484.94
Ward, Mackenzie, D,211302483.980.000.00782.991700.99
Deng, Dale,28399553.970.000.000.00553.97
Chande, Priscilla,293582384.070.000.000.002384.07
Yang, Jackson,225701735.980.000.000.001735.98
Prasad, Rebekah, A,1591983.970.000.000.0083.97
Schmidt, Mayra,1788429.980.000.000.0029.98
Mehta, Ivan, S,263901725.980.000.000.001725.98
Zhang, Franklin, L,1259753.210.000.000.0053.21
Romero, Tabitha, M,224161764.960.000.000.001764.96
Hernandez, Lori,18186139.440.000.000.00139.44
Sai, Kaitlin, J,14529254.060.000.000.00254.06
Dominguez, Felicia, R,1419668.970.000.000.0068.97
Wood, Julian, A,181667200.370.000.002443.354757.02
Castro, Jacquelyn,210932515.250.000.00782.991732.26
Ye, Rosa, C,199403440.430.000.001000.442439.99
Subram, Gerald,215173172.970.000.00782.992389.98
Long, Maria,1603661.960.000.000.0061.96
Washington, Haley, F,239041198.970.000.000.001198.97
Yuan, Alison, K,2457498.960.000.000.0098.96
Smith, Jacob, A,224181732.260.000.000.001732.26
Muñoz, Armando, E,1990613.980.000.000.0013.98
Rodriguez, Bryant, R,293602418.050.000.000.002418.05
Tang, Carly, A,224701735.980.000.000.001735.98
Patel, Ebony,255311188.460.000.000.001188.46
Subram, Sergio,28386600.460.000.000.00600.46
James, Gabriella, S,225941709.980.000.000.001709.98
Anderson, Devin, A,228222475.950.000.002475.950.00
Lopez, Morgan, F,1946663.970.000.000.0063.97
Raman, George, M,26359600.460.000.000.00600.46
Lal, Gilbert,245772487.330.000.000.002487.33
Sharma, Lacey, M,2947288.980.000.000.0088.98
King, Adam, M,1693214.560.000.000.0014.56
Lin, Randy,14540156.250.000.000.00156.25
Zhang, Jake,226161735.980.000.000.001735.98
Suarez, Victor, N,2407112.940.000.000.0012.94
Cox, Taylor,1143681.760.000.000.0081.76
Raji, April, L,1498171.270.000.000.0071.27
Gill, Cheryl, R,2841060.470.000.000.0060.47
Dominguez, Erik, L,2603738.980.000.000.0038.98
Price, Wyatt,1233678.980.000.000.0078.98
Xu, Terrence, L,2374339.980.000.000.0039.98
Rana, Andre,27904156.760.000.000.00156.76
Pal, Corey,257742537.320.000.000.002537.32
Xu, Omar, R,1927963.970.000.000.0063.97
Raje, Damien, S,257844.990.000.000.004.99
Jai, Kate,1470624.990.000.000.0024.99
Rodriguez, Chelsea,12525119.980.000.000.00119.98
Blanco, Francis, J,25750553.970.000.000.00553.97
Subram, Cindy, L,2394339.980.000.000.0039.98
Shen, Damien, C,1496448.970.000.000.0048.97
Kelly, Dalton, L,1563461.960.000.000.0061.96
Shan, Nichole, K,1946124.990.000.000.0024.99
Zhao, Sandra, S,225031775.470.000.000.001775.47
Suarez, Felicia, W,287032419.060.000.000.002419.06
Ramos, Linda,2359832.280.000.000.0032.28
Sanz, Naomi,1284039.980.000.000.0039.98
Guo, Christy, R,2363969.970.000.000.0069.97
Rana, Summer, M,25703607.960.000.000.00607.96
Martin, Dalton, J,1250536.590.000.000.0036.59
Black, Roger, J,284162442.030.000.000.002442.03
Schmidt, Meredith,2549938.980.000.000.0038.98
Rana, Lydia,2939513.980.000.000.0013.98
Roberts, Nathan,2947060.470.000.000.0060.47
She, Todd,234424.990.000.000.004.99
Gill, Darren, M,1140834.470.000.000.0034.47
Torres, Nelson, F,258044.990.000.000.004.99
Torres, Victor,1803064.970.000.000.0064.97
Dominguez, Teresa, C,2096342.930.000.000.0042.93
Patterson, Melanie,2889869.460.000.000.0069.46
Evans, Kyle,27890561.480.000.000.00561.48
Sharma, Cassie, A,26978553.970.000.000.00553.97
Shan, Cristina,14783158.960.000.000.00158.96
Liu, Roger, E,2005831.270.000.000.0031.27
Sanz, Natasha,14839156.250.000.000.00156.25
Gill, Julio, R,2699338.980.000.000.0038.98
Randall, Tammy, C,1379836.270.000.000.0036.27
Cook, Jade, C,2568712.980.000.000.0012.98
Ruiz, Briana,2090632.280.000.000.0032.28
Cox, Cole, M,253156.280.000.000.006.28
Nara, Terrence, R,28474565.470.000.000.00565.47
Jai, Lindsey, W,2397198.960.000.000.0098.96
She, Kara,2361734.980.000.000.0034.98
Zeng, Darryl, C,2092937.270.000.000.0037.27
James, Jade, M,26400132.980.000.000.00132.98
Rai, Dustin, J,264176.280.000.000.006.28
Ashe, Melvin,26817553.970.000.000.00553.97
Alvarez, Deanna, K,2472015.230.000.000.0015.23
Malhotra, Ebony,1158914.980.000.000.0014.98
Miller, Olivia, H,26860539.990.000.000.00539.99
Morris, Jacqueline, H,294682428.050.000.000.002428.05
Gutierrez, Wendy,12610101.950.000.000.00101.95
Weber, Stanley, E,12311116.430.000.000.00116.43
Rai, Barbara, J,224511709.980.000.000.001709.98
Black, Nichole,224221735.980.000.000.001735.98
Nara, Alisha, D,26959563.770.000.000.00563.77
Andersen, Tamara, B,293922393.060.000.000.002393.06
Diaz, Austin, M,1255086.750.000.000.0086.75
She, Warren,2182427.280.000.000.0027.28
Perez, Meagan, R,2110132.280.000.000.0032.28
Yuan, Barbara,2151549.480.000.000.0049.48
Luo, Terry, H,2685053.980.000.000.0053.98
Goel, Tracy, J,1817821.980.000.000.0021.98
Russell, Aaron,255991174.480.000.000.001174.48
Sanz, Jay,28503578.460.000.000.00578.46
Kumar, Dustin, R,2684628.480.000.000.0028.48
Rai, Cassie, R,14194168.930.000.000.00168.93
Dominguez, Natasha,2376929.480.000.000.0029.48
Martin, Victor, L,26885574.980.000.000.00574.98
Ross, Hailey, C,1361283.950.000.000.0083.95
Alvarez, Mallory, L,2112456.960.000.000.0056.96
Williams, Jennifer, E,1945792.480.000.000.0092.48
He, Arturo,293692422.540.000.000.002422.54
Ye, Micah, A,2095237.270.000.000.0037.27
Munoz, Meghan, P,27810578.460.000.000.00578.46
Hernandez, Larry,17840228.960.000.000.00228.96
Chandra, Marie, A,257752451.300.000.000.002451.30
Kapoor, Sergio, E,1939227.280.000.000.0027.28
Torres, Randall,25646539.990.000.000.00539.99
Suri, Summer,26219570.470.000.000.00570.47
Shen, Kara, C,2362869.970.000.000.0069.97
Blanco, Theresa,26824567.760.000.000.00567.76
Vance, Kaitlin,2938323.780.000.000.0023.78
Pal, Damien, M,225661700.990.000.000.001700.99
Goel, Terrence, M,19389138.450.000.000.00138.45
Serrano, Kari,269056.280.000.000.006.28
Sharma, Dawn,239871147.770.000.000.001147.77
Gonzalez, Arthur, G,287472398.050.000.000.002398.05
Gonzalez, Rachael, M,236362479.940.000.000.002479.94
Rai, Jon,25642583.970.000.000.00583.97
Andersen, Dale, B,1499269.990.000.000.0069.99
He, Cedric, W,252984.990.000.000.004.99
Andersen, April, C,20973193.980.000.000.00193.98
Zeng, Kelli, M,2282578.960.000.000.0078.96
Morgan, Lauren,242171209.470.000.000.001209.47
Alvarez, Julio,262052451.300.000.000.002451.30
Williams, Blake,2942178.480.000.000.0078.48
Carlson, Kendra,1804432.270.000.000.0032.27
Deng, Julie,2563138.980.000.000.0038.98
Liu, Mandy,1788829.980.000.000.0029.98
Martin, Audrey,13791107.850.000.000.00107.85
Rodriguez, Jay, M,28411134.950.000.000.00134.95
Townsend, Michelle, P,1286486.240.000.000.0086.24
Hernandez, Mason, C,2778247.970.000.000.0047.97
Andersen, Bethany,2532439.980.000.000.0039.98
Raman, Ebony,1934821.490.000.000.0021.49
Xu, Mario,2641158.980.000.000.0058.98
Davis, Ashley,26407126.280.000.000.00126.28
Lin, Franklin, M,2455769.970.000.000.0069.97
Alonso, Francis, J,2173869.970.000.000.0069.97
Lopez, Jonathan, D,15103107.850.000.000.00107.85
Sanchez, Heidi,28438574.980.000.000.00574.98
Deng, Kelli,2279427.280.000.000.0027.28
Ramos, Diana, J,287332407.040.000.000.002407.04
Chen, Krystal, D,13530186.280.000.000.00186.28
Zhou, Curtis,2550538.980.000.000.0038.98
Anand, Nichole,12508132.970.000.000.00132.97
Coleman, Gabriel, B,1770637.930.000.000.0037.93
Andersen, Kelli,226021754.980.000.000.001754.98
Carter, Miguel,1377670.570.000.000.0070.57
Romero, Nelson,25728574.980.000.000.00574.98
Nara, Roger,26928597.950.000.000.00597.95
Lal, Ashlee, A,284172426.000.000.000.002426.00
Prasad, Regina, A,241921155.480.000.000.001155.48
Travers, Linda,2942053.990.000.000.0053.99
Wu, Jake, E,224461739.460.000.000.001739.46
Suri, Joe,2102837.270.000.000.0037.27
Rubio, Rebekah,2469929.480.000.000.0029.48
Gao, Autumn, W,2408539.980.000.000.0039.98
Wu, Colleen,1929128.980.000.000.0028.98
Xu, Gilbert,225544.990.000.000.004.99
Lal, Lacey, L,237511155.480.000.000.001155.48
Beck, Christine,20714187.980.000.000.00187.98
Martinez, Dalton, M,2841323.780.000.000.0023.78
Zheng, Mandy,2472189.970.000.000.0089.97
Madan, Joel, C,1788764.970.000.000.0064.97
Kelly, Marcus, A,2569947.970.000.000.0047.97
Shen, Maurice, L,26938722.770.000.000.00722.77
Butler, Kayla, J,25748539.990.000.000.00539.99
Muñoz, Kari,1952087.970.000.000.0087.97
Alonso, Briana,21830539.990.000.000.00539.99
Ruiz, Nelson,2363829.990.000.000.0029.99
Xu, Shaun, N,2780453.980.000.000.0053.98
Clark, Marcus, G,2795838.980.000.000.0038.98
Munoz, Arthur, L,226081744.970.000.000.001744.97
Guo, Dawn, R,256031169.460.000.000.001169.46
Raman, Lydia,26868539.990.000.000.00539.99
Gutierrez, Jésus, E,1643747.260.000.000.0047.26
Sanchez, Christina, S,1454628.990.000.000.0028.99
Davis, Edward,2889621.490.000.000.0021.49
Xie, Katrina, M,2689738.980.000.000.0038.98
Mehta, Whitney, T,241971155.480.000.000.001155.48
Tang, Bonnie, W,27856578.460.000.000.00578.46
Rana, Brett, L,2094337.270.000.000.0037.27
Vance, Martin, A,256041174.480.000.000.001174.48
Ms., Sheperdigian, Janet,2454137.270.000.000.0037.27
Deng, Corey,28921184.480.000.000.00184.48
Goel, Willie, T,226561169.460.000.000.001169.46
Gao, Ernest,2782827.770.000.000.0027.77
Rai, Donna,1223562.760.000.000.0062.76
Beck, Bradley, L,2238868.490.000.000.0068.49
Garcia, Douglas,248602520.310.000.000.002520.31
Moreno, Briana, L,287342419.060.000.000.002419.06
Andersen, Damien, K,2940253.990.000.000.0053.99
Ruiz, Pedro,240341203.460.000.000.001203.46
Thompson, Morgan, Q,240111179.470.000.000.001179.47
Rana, Kristina,2784723.780.000.000.0023.78
Black, Mario, M,2790521.490.000.000.0021.49
Rai, Alisha,26848607.960.000.000.00607.96
Martin, Orlando, C,16300111.950.000.000.00111.95
Evans, Lucas, J,1155621.490.000.000.0021.49
Yang, Luke,2852660.470.000.000.0060.47
Mr., Saravan, K.,14974158.950.000.000.00158.95
Wu, Trisha,264041775.470.000.000.001775.47
Coleman, Austin, V,1486529.990.000.000.0029.99
Foster, Mya, M,232301155.480.000.000.001155.48
Foster, Isabella,27892649.460.000.000.00649.46
Gill, Lori, A,225101763.970.000.000.001763.97
Washington, Faith,2084969.970.000.000.0069.97
Brown, Richard, M,293572398.050.000.000.002398.05
Chapman, Joel,1905056.970.000.000.0056.97
Ramos, Orlando,2415429.480.000.000.0029.48
Gill, Paula, W,285242398.050.000.000.002398.05
Allen, Jada,26866615.460.000.000.00615.46
Davis, Lucas, S,1937824.990.000.000.0024.99
Rodriguez, Dominic, E,28525574.980.000.000.00574.98
Ortega, Jésus, L,1654244.970.000.000.0044.97
Wright, Elijah, I,255771155.480.000.000.001155.48
Gonzalez, Cassandra,1796732.270.000.000.0032.27
Vazquez, Carrie,2941953.990.000.000.0053.99
Black, Nicolas,239454.990.000.000.004.99
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
Liang, Mandy,28371539.990.000.000.00539.99
Torres, Julio,224601750.980.000.000.001750.98
Shan, Christine, R,26895553.970.000.000.00553.97
Ms., Smith, Samantha,294072452.040.000.000.002452.04
Young, Evan,1273935.000.000.000.0035.00
Lopez, Martin, E,2186428.980.000.000.0028.98
Wang, Christy,1949831.270.000.000.0031.27
Arun, Evelyn,2784223.780.000.000.0023.78
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
Subram, Mayra, C,284462398.050.000.000.002398.05
Guo, Crystal,19379103.460.000.000.00103.46
Tang, Gilbert, D,2153340.220.000.000.0040.22
Li, Jorge, V,2013328.980.000.000.0028.98
Srini, Cesar,1156353.990.000.000.0053.99
Subram, Cynthia, A,2096529.990.000.000.0029.99
Mehta, George, L,2056627.280.000.000.0027.28
Yuan, Tasha,2056564.970.000.000.0064.97
Martin, Teresa, D,2258848.970.000.000.0048.97
Subram, Lydia, F,285492418.050.000.000.002418.05
Ortega, Leslie,2485129.480.000.000.0029.48
Serrano, Ricky,2793838.980.000.000.0038.98
Yuan, Drew, R,216791700.990.000.000.001700.99
_SUM3388349.7249631.45559026.83808170.261971521.18

Generated 2025-12-23 11:32:13.666 UTC