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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Dominguez, Clinton,159336931.880.002181.560.004750.32
Wilson, Jacob, H,150786675.600.003578.270.003097.33
Vance, Veronica, G,165756994.570.000.002181.564813.01
Zhu, Lisa, R,150596793.540.003578.270.003215.27
Zhou, Leah, L,223091785.970.000.000.001785.97
Moyer, Felicia, C,28880637.960.000.000.00637.96
Mr., Rodman, Jim,205622994.090.00699.100.002294.99
Gao, Jessie,205643059.080.00699.100.002359.98
Kumar, Corey,153548297.290.003578.270.004719.02
Bennett, Morgan,150978377.090.003578.270.004798.82
Cai, Colleen, J,150885896.190.003578.270.002317.92
Sanz, Robin, L,150875917.240.003578.270.002338.97
Prasad, Martin,150895895.240.003578.270.002316.97
Andersen, Katrina,190326938.580.000.002181.564757.02
Pal, Jon, H,154406736.560.003578.270.003158.29
Sun, Trisha,224421709.980.000.000.001709.98
Subram, Dominique, S,156205959.720.003578.270.002381.45
Subram, Levi,156195908.250.003578.270.002329.98
Deng, Jerry,22813119.960.000.000.00119.96
Andersen, Clayton,156315122.390.003578.27801.77742.35
Lopez, Jermaine,114888090.330.003374.992322.282393.06
Patel, Patricia,205693114.060.00699.100.002414.96
Wu, Dawn, T,114936958.800.003399.992329.981228.83
Sanchez, Raymond,115487068.270.003374.990.003693.28
Robinson, Brandon, J,156615208.040.003578.270.001629.77
Richardson, Megan, M,156625253.070.003578.270.001674.80
Jai, April,156605169.070.003578.270.001590.80
Gutierrez, Jimmy, M,114946973.810.003399.992329.981243.84
Fernandez, Erick, E,156685913.240.003578.270.002334.97
Henderson, Julian, J,156918341.290.003578.270.004763.02
Lin, Erica, E,160333743.390.002181.560.001561.83
Collins, Blake,116106786.440.002071.420.004715.02
Diaz, Reginald, A,2458139.980.000.000.0039.98
Chander, Mario,1259067.460.000.000.0067.46
Jai, Grant,242001120.490.000.000.001120.49
Bailey, Xavier,123054940.390.000.004391.41548.98
Torres, Juan, M,12746105.240.000.000.00105.24
Liu, Damien, M,172147211.390.000.002443.354768.04
Xu, Omar, A,225961750.980.000.000.001750.98
Xie, Calvin, A,2485839.980.000.000.0039.98
Patel, Barry, J,262186.280.000.000.006.28
Liu, Jorge, J,205923113.220.00782.990.002330.23
Beck, Carl, M,163112988.320.002181.56806.760.00
Schmidt, Gina,162603001.020.002181.560.00819.46
Nath, Casey,116165253.650.002071.42784.282397.95
Alonso, Eddie, L,164202959.000.002181.560.00777.44
Gill, Kathleen,207133421.930.00782.990.002638.94
Zhao, Colleen, L,164073250.110.002443.350.00806.76
Mehta, Douglas,192581574.420.001000.440.00573.98
Ruiz, Erika, J,191921682.410.001000.440.00681.97
Deng, Raul, D,162723021.040.002181.560.00839.48
Sanz, Ebony, I,207113240.320.00782.990.002457.33
Wu, Rosa,164613287.320.002443.350.00843.97
Shan, Calvin,208113270.320.00782.990.002487.33
Tang, Kelvin,208322533.970.00782.991750.980.00
Alonso, Kendra, C,164272975.020.002181.56793.460.00
Browning, Carrie, G,192991587.410.001000.440.00586.97
Ramos, Alberto,122396901.420.000.002071.424830.00
James, Gabriella, S,225941709.980.000.000.001709.98
Vance, Meagan, F,2940553.990.000.000.0053.99
Vazquez, Jaime,2230437.270.000.000.0037.27
Wu, Roger,226301164.470.000.001164.470.00
Ray, Harold, A,1351643.970.000.000.0043.97
Ramirez, Megan, C,113876958.800.003374.992354.981228.83
Rodriguez, Jessica,216692483.980.000.00782.991700.99
Sun, Stacey, S,193613478.780.000.003478.780.00
Hernandez, Gerald, L,240541174.480.000.000.001174.48
Pal, Mohamed,2055024.990.000.000.0024.99
Vance, Ebony,2072424.990.000.000.0024.99
Gutierrez, Walter,251414.990.000.000.004.99
Madan, Dominic, F,21847187.980.000.000.00187.98
Carlson, Ruben, J,2530467.490.000.000.0067.49
Deng, Sharon, A,2689359.980.000.000.0059.98
Rai, Alicia, M,2891427.770.000.000.0027.77
Sai, Veronica,165093258.790.000.002443.35815.44
Pal, Damien, M,225661700.990.000.000.001700.99
Sharma, Ricardo,165123262.830.000.002443.35819.48
Vazquez, Lee,148436690.580.003578.270.003112.31
Jordan, Terrance, B,165463036.530.000.002181.56854.97
Chandra, Bruce, H,14970158.960.000.000.00158.96
Navarro, Lance, C,208502556.940.000.002556.940.00
Zhang, Jake,226161735.980.000.000.001735.98
Liu, Vincent,208482558.460.000.002558.460.00
Vazquez, Cheryl, A,179483045.300.000.002443.35601.95
Sanz, Frank, T,208512518.970.000.00782.991735.98
Suri, Terrance, C,2104634.980.000.000.0034.98
Roberts, Gabriella, J,165533001.040.000.002181.56819.48
Rana, Kristopher, W,2255029.480.000.000.0029.48
Hu, Micah, A,165413028.020.000.002181.56846.46
Subram, Bobby, J,29373184.480.000.000.00184.48
Chander, Casey, C,165542990.520.000.002181.56808.96
Torres, Renee, L,195103451.740.000.001000.442451.30
Romero, Roy, C,208592508.970.000.00782.991725.98
Guo, Wesley,164703021.040.002181.560.00839.48
Zheng, Valerie, R,193121564.700.000.001000.44564.26
Gill, Krista,1266477.960.000.000.0077.96
Anderson, Cameron, L,165956901.380.000.002181.564719.82
Scott, Mackenzie, L,2567666.970.000.000.0066.97
Rai, Kate,165987131.400.000.002443.354688.05
Nath, Sheena,2580039.980.000.000.0039.98
Raje, Yolanda,208522546.960.000.00782.991763.97
Sanchez, Janelle,122815169.360.000.002826.442342.92
Howard, Grace, J,208643234.290.000.00782.992451.30
Alexander, Justin, M,122725139.730.000.002822.762316.97
Chander, Nichole, H,2845130.480.000.000.0030.48
Rai, Sheena,2939323.780.000.0023.780.00
Zhang, Margaret, G,1605838.250.000.000.0038.25
Deng, Drew, E,1788232.270.000.0032.270.00
Chen, Valerie,199113335.410.000.001000.442334.97
Ortega, Gary,114967013.790.003399.992398.951214.85
Moreno, Gary, E,2154429.980.000.000.0029.98
Xu, Laura, D,162874538.840.002181.560.002357.28
Kapoor, Deanna, D,170973021.020.000.002181.56839.46
Ms., Smith, Mary, J.,28437567.760.000.000.00567.76
Moreno, Albert,124025218.400.000.002049.103169.30
Anand, Nicolas, P,205673074.080.00699.100.002374.98
Raje, Karl,193623443.790.000.003443.790.00
He, Alisha, R,180262988.320.000.002181.56806.76
Sanchez, Pamela,208793284.300.000.00782.992501.31
Alvarez, Cheryl, A,1232077.960.000.000.0077.96
Raje, Christine, W,172036952.530.000.002181.564770.97
Zhou, Colin,179622777.520.000.002181.56595.96
Moreno, Theodore, C,208722518.970.000.00782.991735.98
Martin, Paula, B,21855579.970.000.000.00579.97
Rodriguez, Ann, S,123156803.130.000.006803.130.00
Martinez, Andre,165886994.580.000.002181.564813.02
Townsend, Roberto,193593478.780.000.003478.780.00
Srini, Martin, L,1862924.990.000.000.0024.99
Blanco, Alfredo, T,176263001.040.000.002181.56819.48
Ortega, Nelson,151188301.310.003578.270.004723.04
Smith, Terrance, I,194243511.760.000.003511.760.00
Gomez, Joy, J,126586863.440.000.002071.424792.02
Suarez, Michele, C,125265229.380.000.002049.103180.28
Garcia, Emmanuel, T,122636829.380.000.002071.424757.96
Cox, Zoe, A,177552768.530.000.002181.56586.97
Ma, Stacey,2184031.270.000.0031.270.00
Washington, Isabella,208802518.970.000.00782.991735.98
She, Donna, D,1934621.490.000.0021.490.00
Gao, Mandy, M,125605636.900.000.002049.103587.80
Ma, Randy, R,2455037.270.000.0037.270.00
Xu, Shawn,1932827.280.000.000.0027.28
Green, Luke, R,2839223.780.000.0023.780.00
Townsend, Trinity, L,12367160.450.000.0049.99110.46
Pal, Cedric,2323539.980.000.0039.980.00
Griffin, Ashley,248652478.340.000.000.002478.34
Zhou, Cara,1135038.470.000.0038.470.00
Coleman, Trevor, C,253133.990.000.000.003.99
Gill, Alfredo, M,236292466.320.000.002466.320.00
Adams, Rebecca, F,176443017.330.000.003017.330.00
Alvarez, Lance, J,1619079.250.000.007.2871.97
Miller, Jeremiah,177172840.010.000.002840.010.00
Thomas, Ryan,225324.990.000.000.004.99
Liang, Krystal, S,124045251.710.000.002071.423180.29
Xu, Michele, K,15353325.830.000.000.00325.83
Malhotra, Dominique,124605678.910.000.002049.103629.81
Sara, Manuel,1261167.460.000.000.0067.46
Andersen, Bridget, K,177923266.810.000.002443.35823.46
Rogers, Melissa, J,284152428.050.000.000.002428.05
Zhou, Valerie, J,178283262.830.000.002443.35819.48
Jimenez, Diana, M,1777672.250.000.000.0072.25
Carlson, Linda, J,126095636.900.000.002049.103587.80
Blanco, Theresa,26824567.760.000.000.00567.76
Rai, Kelsey, L,194373480.380.000.003480.380.00
Rai, Colin, W,245732563.350.000.000.002563.35
Torres, Shannon,126125657.910.000.002049.103608.81
Sanz, Kendra,177533080.290.000.002443.35636.94
Ye, Darryl,177903039.310.000.002443.35595.96
Gutierrez, Lori,240651170.480.000.000.001170.48
Fernandez, Jillian, K,125995649.210.000.002071.423577.79
Chavez, Colleen, H,200493150.40699.100.000.002451.30
Sanchez, Brian, F,209313273.170.000.00782.992490.18
Lal, Alvin,240581164.470.000.000.001164.47
Andersen, Jerry,209752515.250.000.00782.991732.26
Ramos, Teresa,136895898.263578.270.000.002319.99
Nicholls, Jay, K,178133020.300.000.002443.35576.95
Srini, Ebony, A,179592748.830.000.002181.56567.27
Kapoor, Heidi, D,179373068.820.000.002443.35625.47
Black, Nina, L,179683043.330.000.002443.35599.98
Ramos, Jill,210392483.980.000.002483.980.00
Holt, Dale, C,236182481.820.000.002481.820.00
Romero, Joe, J,179432781.540.000.002181.56599.98
Patel, Heidi, R,232251184.460.000.001184.460.00
Zhou, Lisa, L,13809113.960.000.000.00113.96
Carlson, Joe, L,2562747.970.000.0047.970.00
Patel, Stefanie,27967553.970.000.000.00553.97
Gonzalez, Preston, L,14156229.570.000.0033.98195.59
McDonald, Gilbert, G,17226109.970.000.000.00109.97
Sai, Jermaine, G,14934178.450.000.000.00178.45
Romero, Neil,28424564.480.000.000.00564.48
Jenkins, Connor,2080063.970.000.000.0063.97
Raji, Jenny,2187072.960.000.000.0072.96
Richardson, Angel,126406752.130.000.002049.104703.03
Hernandez, Ruben, C,210362547.950.000.00782.991764.96
Lal, Ricardo, C,179582811.520.000.002181.56629.96
Vance, Marie, W,210122497.960.000.00782.991714.97
Mitchell, Fernando,179812983.340.000.002443.35539.99
Kumar, Raul, B,128574384.080.000.002049.102334.98
Pal, Lindsey, A,210712533.970.000.00782.991750.98
Rubio, Jésus,25616539.990.000.00539.990.00
Rivera, Chase,28511562.960.000.000.00562.96
Perez, Frederick,160533752.380.002181.560.001570.82
Gonzalez, Dominic, L,136937171.583578.270.000.003593.31
Sai, Kaitlin, J,14529254.060.000.000.00254.06
Rodriguez, Dominic, E,28525574.980.000.000.00574.98
Zhang, Brent, L,181737189.350.000.002443.354746.00
Becker, Karla, M,1273064.900.000.000.0064.90
Prasad, Rebekah, A,1591983.970.000.000.0083.97
Liang, Cedric, R,199413078.06699.100.000.002378.96
Zhao, Arturo,1942531.270.000.000.0031.27
Hall, Sydney, T,1788039.550.000.007.2832.27
Ruiz, Briana,2090632.280.000.000.0032.28
Martinez, Molly, S,13603133.940.000.000.00133.94
Bryant, Ian,273191775.470.000.000.001775.47
Luo, Leonard, A,255821164.470.000.000.001164.47
Serrano, Jill,240261212.970.000.000.001212.97
Brooks, Haley, S,17193134.960.000.0074.9859.98
Ramos, Pedro, P,2941627.770.000.000.0027.77
Schmidt, Kristina,123186808.150.000.006808.150.00
Tang, Alvin, L,2167842.930.000.0042.930.00
Deng, Brad, D,200423150.40699.100.002451.300.00
Goel, Deborah, S,114898127.510.003374.992359.462393.06
Gao, Autumn, W,2408539.980.000.0039.980.00
Alonso, Latasha, A,135918355.273578.270.000.004777.00
Jai, Christine, J,14814128.460.000.00128.460.00
Beck, Cristina, J,122845625.250.000.003295.262329.99
Dominguez, Jessie, A,256286.280.000.000.006.28
Zhao, Eugene,123286792.110.000.004394.062398.05
Gomez, Meredith,27965565.470.000.00565.470.00
Blanco, Albert, W,135818374.793578.270.000.004796.52
Prasad, Regina, A,241921155.480.000.000.001155.48
Sanchez, Morgan, J,12262119.450.000.0060.4758.98
Vance, Heidi,147716689.580.003578.270.003111.31
Zheng, Lisa, R,138465933.250.003578.270.002354.98
Ross, Gabriel, K,16314111.950.000.0039.9871.97
Raji, Tara,123855118.750.000.002071.423047.33
Travers, Linda,2942053.990.000.000.0053.99
Lin, Brent, L,277886.280.000.006.280.00
Kapoor, Carolyn, M,1645947.260.000.007.2839.98
Wu, Jake, E,224461739.460.000.000.001739.46
Anand, Wayne, H,226861243.440.000.001243.440.00
Nara, Omar, J,1353559.200.000.000.0059.20
Torres, Ian, V,172076979.560.000.002181.564798.00
Kumar, Nicolas, R,122925027.860.000.004464.09563.77
Rai, Dale, E,2173937.270.000.000.0037.27
Suri, Martin,165897343.690.000.002443.354900.34
Sanchez, Edgar,116046786.120.002049.102343.962393.06
Martin, Derrick,141918301.310.003578.270.004723.04
Romero, Robyn, C,27802561.480.000.000.00561.48
Madan, Harold, A,239381120.490.000.000.001120.49
Bailey, Ariana, J,136915976.743578.270.000.002398.47

Generated 2024-11-10 08:33:52.506 UTC