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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Blanco, Alfredo, T,176263001.040.000.002181.56819.48
Smith, Terrance, I,194243511.760.000.003511.760.00
Suarez, Michele, C,125265229.380.000.002049.103180.28
Cox, Zoe, A,177552768.530.000.002181.56586.97
Washington, Isabella,208802518.970.000.00782.991735.98
Gao, Mandy, M,125605636.900.000.002049.103587.80
Zhou, Lisa, L,13809113.960.000.000.00113.96
Patel, Stefanie,27967553.970.000.000.00553.97
McDonald, Gilbert, G,17226109.970.000.000.00109.97
Adams, Rebecca, F,176443017.330.000.003017.330.00
Miller, Jeremiah,177172840.010.000.002840.010.00
Liang, Krystal, S,124045251.710.000.002071.423180.29
Malhotra, Dominique,124605678.910.000.002049.103629.81
Andersen, Bridget, K,177923266.810.000.002443.35823.46
Zhou, Valerie, J,178283262.830.000.002443.35819.48
Raji, Franklin,114006967.780.003374.992318.961273.83
Stewart, Megan, L,114137189.750.003399.992350.961438.80
Sun, Heather,287292452.040.000.000.002452.04
Raman, Tammy,1212681.760.000.000.0081.76
Richardson, Ian,114147191.770.003399.992398.971392.81
Chandra, Donald,114857048.300.003399.992398.471249.84
Navarro, Shannon, R,151068421.280.003578.270.004843.01
Foster, Alexia,115686789.460.002071.422319.992398.05
Raji, Karla, V,159296944.580.002181.560.004763.02
Rana, Heidi, M,2247598.960.000.000.0098.96
Navarro, Lawrence,2793992.970.000.000.0092.97
Cai, Lacey, L,1273342.970.000.000.0042.97
Yuan, Bridget,26211565.470.000.000.00565.47
Raje, Andres,207103240.320.00782.990.002457.33
Ye, Jamie, C,163293272.090.002443.350.00828.74
McDonald, Deborah, R,162753282.830.002443.350.00839.48
Ross, Gabrielle, J,192531540.430.001000.440.00539.99
Rai, Maurice, S,163283001.040.002181.560.00819.48
Sai, Adriana, A,164053262.830.002443.35819.480.00
Huang, Colin,207123261.330.00782.990.002478.34
Moreno, Kellie, T,163183021.020.002181.560.00839.46
Xu, Derek, M,208242512.960.00782.991729.970.00
Kapoor, Pamela,208253226.340.000.00782.992443.35
Zeng, Todd, C,122835582.910.000.003272.942309.97
Lopez, Courtney,208392511.260.000.002511.260.00
Beck, Cristina, J,122845625.250.000.003295.262329.99
Ortega, Beth, A,122775666.520.000.003309.242357.28
Zhang, Colleen, L,165623001.040.000.002181.56819.48
Lin, Marshall,168227176.380.000.002443.354733.03
Jones, Andrew, C,165947231.370.000.002443.354788.02
Hu, Tiffany, A,208562483.980.000.00782.991700.99
Xu, Erica, M,208633261.330.000.00782.992478.34
Chen, Dennis, M,176273021.020.000.002181.56839.46
Dominguez, Lori,126486817.600.000.002049.104768.50
Walker, Sarah, R,13814230.040.000.000.00230.04
Dominguez, Felicia, R,1419668.970.000.000.0068.97
Diaz, Deanna, D,177202790.530.000.002181.56608.97
Raje, Melvin,1158034.990.000.000.0034.99
Luo, Alejandro, K,123166799.450.000.006799.450.00
Yuan, Omar, C,123805570.220.000.002049.103521.12
Ashe, Francisco, W,123356912.600.000.002049.104863.50
He, Warren, L,171926977.580.000.002181.564796.02
Washington, Julia, R,208752518.970.000.00782.991735.98
Dominguez, Julio, E,170943001.040.000.002181.56819.48
Xie, Terry,208852518.970.000.00782.991735.98
Rodriguez, Stefanie, L,124595618.540.000.002071.423547.12
Gomez, Gerald,177432793.520.000.002181.56611.96
Raman, Bruce,208862533.970.000.00782.991750.98
Huang, Todd,124635202.220.000.002071.423130.80
Pal, Rafael, J,177152831.530.000.002831.530.00
Andersen, Leonard,177722846.000.000.002181.56664.44
Serrano, Jimmy, L,176323001.020.000.002181.56819.46
Shan, Jerry,193823443.790.000.003443.790.00
Sanchez, Brenda,25656539.990.000.000.00539.99
Long, Maria,1603661.960.000.000.0061.96
Gill, Marvin, M,178216.280.000.000.006.28
Shan, Cedric, H,237751155.480.000.000.001155.48
Gomez, Theodore,13503101.250.000.000.00101.25
Washington, Haley, F,239041198.970.000.000.001198.97
Cooper, Mariah, J,279012433.040.000.000.002433.04
Lopez, Emmanuel, R,125595633.910.000.002049.103584.81
Xie, Franklin, A,177472743.530.000.002181.56561.97
Shan, Casey, C,177823021.040.000.002181.56839.48
Thompson, Benjamin,194353457.770.000.003457.770.00
Rodriguez, Gerald,122166955.410.000.002071.424883.99
Butler, Eduardo, G,13533137.940.000.000.00137.94
Gill, Randall, A,1816582.260.000.000.0082.26
Hu, Curtis, G,278802393.060.000.000.002393.06
Sandoval, Jill,1414390.580.000.000.0090.58
Andersen, Keith,116126795.120.002049.100.004746.02
Henderson, Dakota, M,164063110.050.002181.56928.490.00
Liang, Wesley, A,121235837.840.002049.102351.961436.78
Xie, Colleen, C,121335830.680.002071.422441.931317.33
Ruiz, Ricky,207183283.430.00782.990.002500.44
Romero, Juan, A,163243282.810.002443.35839.460.00
Foster, Jordan, M,208073249.310.00782.990.002466.32
Luo, Cassie,164523071.010.002181.560.00889.45
Raje, Julie, H,122146803.920.002049.100.004754.82
Carlson, Linda, J,126095636.900.000.002049.103587.80
Munoz, Kristine,164463093.030.002181.560.00911.47
Rai, Kelsey, L,194373480.380.000.003480.380.00
Chande, Nina, D,192631587.410.001000.440.00586.97
Torres, Shannon,126125657.910.000.002049.103608.81
Xu, Jenny, K,122226909.100.002049.100.004860.00
Ye, Darryl,177903039.310.000.002443.35595.96
Ross, Ryan,164283021.020.002181.560.00839.46
Fernandez, Jillian, K,125995649.210.000.002071.423577.79
Goel, Kara,164653271.790.000.002443.35828.44
Sanchez, Brian, F,209313273.170.000.00782.992490.18
Rubio, Jimmy,208372547.950.000.002547.950.00
Andersen, Jerry,209752515.250.000.00782.991732.26
Madan, Frederick,165503001.040.000.002181.56819.48
Nicholls, Jay, K,178133020.300.000.002443.35576.95
Xie, Brad, D,193021577.390.000.001000.44576.95
Kapoor, Heidi, D,179373068.820.000.002443.35625.47
Yuan, Kurt,165613030.030.000.002181.56848.47
Ramos, Jill,210392483.980.000.002483.980.00
Williams, Abigail, M,169383110.050.000.002181.56928.49
Romero, Joe, J,179432781.540.000.002181.56599.98
Jenkins, Nathan, M,122865254.880.000.002849.412405.47
Rodriguez, Marie, L,179603001.040.000.002181.56819.48
Sutton, Marshall,208623240.320.000.00782.992457.33
Richardson, Angel,126406752.130.000.002049.104703.03
Sai, Kaitlin, J,14529254.060.000.000.00254.06
Hernandez, Ruben, C,210362547.950.000.00782.991764.96
Subram, Allen,1789529.980.000.000.0029.98
Lal, Ricardo, C,179582811.520.000.002181.56629.96
Sharma, Nina,237601183.470.000.000.001183.47
Vance, Marie, W,210122497.960.000.00782.991714.97
Raje, Tamara, J,1994686.950.000.000.0086.95
Mitchell, Fernando,179812983.340.000.002443.35539.99
Hughes, Adam,2454637.270.000.000.0037.27
Kumar, Raul, B,128574384.080.000.002049.102334.98
Patterson, Jessica,171826950.600.000.002181.564769.04
Pal, Lindsey, A,210712533.970.000.00782.991750.98
Diaz, Teresa, L,169463071.030.000.002181.56889.47
She, Ramon,180003080.290.000.002443.35636.94
Zhao, Eugene,123286792.110.000.004394.062398.05
Wu, Rafael,127455199.720.000.002071.423128.30
Shan, Willie,170982768.530.000.002768.530.00
Malhotra, Evelyn,128534354.080.000.002049.102304.98
Schmidt, Kristina,123186808.150.000.006808.150.00
Diaz, Armando, P,179783018.010.000.002181.56836.45
Deng, Edwin, A,170852986.030.000.002181.56804.47
Yuan, Katie,194593478.780.000.003478.780.00
Serrano, Erika,123945635.910.000.002049.103586.81
Diaz, Blake, E,181356921.580.000.002181.564740.02
Lal, Johnny, G,123815161.730.000.002822.762338.97
Raji, Raul, P,21135103.950.000.000.00103.95
Martinez, David, R,208692542.960.000.00782.991759.97
Ramos, Ruben, L,237621164.470.000.000.001164.47
Huang, Clarence, C,193413498.780.000.003498.780.00
Gonzalez, Tammy, J,25657609.450.000.000.00609.45
Xu, Karen, E,171153008.020.000.002181.56826.46
Jai, Damien,14806242.940.000.000.00242.94
Chen, Tamara,123825606.260.000.002071.423534.84
Henderson, Marissa,13816260.830.000.000.00260.83
Morris, Caitlin,194163476.390.000.003476.390.00
Edwards, Julia, M,1620096.950.000.000.0096.95
Jai, Shawna, W,177502888.530.000.002181.56706.97
Sara, Arthur, D,237531193.450.000.000.001193.45
Miller, Nathan, l,194183476.390.000.003476.390.00
Chen, Valerie,199113335.410.000.001000.442334.97
Deng, Tonya, O,1793664.970.000.000.0064.97
Lu, Bianca,132526820.460.000.002071.424749.04
Martin, Joy, L,13544108.440.000.000.00108.44
Nason, Kirk, J,128745638.540.000.002071.423567.12
Ma, Heather,176393075.030.000.002181.56893.47
Prasad, Cassandra, D,186213033.330.000.003033.330.00
Nath, Chad,177442765.530.000.002181.56583.97
Xie, Carl, R,181366904.600.000.002181.564723.04
Jiménez, Derrick, B,178902753.520.000.002181.56571.96
Rivera, Bryan,181606914.590.000.002181.564733.03
Taylor, Blake, S,178893043.330.000.002443.35599.98
Xie, Tara,199123427.390.000.001000.442426.95
Li, Laura, O,209332518.970.000.00782.991735.98
Sanz, Pedro,181686907.550.000.002181.564725.99
Carlson, Melinda,209213234.290.000.00782.992451.30
Shan, Russell,195003478.780.000.001000.442478.34
Sharma, Alicia, L,194403492.760.000.003492.760.00
Jimenez, Robyn, M,128614394.060.000.002049.102344.96
Luo, Chad, R,210402566.950.000.002566.950.00
Navarro, Randall, A,186203001.040.000.002181.56819.48
Nelson, Luke, E,210272537.970.000.00782.991754.98
Rodriguez, Jessica,216692483.980.000.00782.991700.99
Gutierrez, Kellie, K,179663262.830.000.002443.35819.48
Li, Suzanne,215083152.950.000.00782.992369.96
Serrano, Sheila, C,210182515.250.000.00782.991732.26
Navarro, Gary, E,135614393.360.000.002049.102344.26
Munoz, Walter,210562547.950.000.002547.950.00
Lopez, Michele, C,215093117.960.000.00782.992334.97
Gray, Jessica,194793443.790.000.003443.790.00
Alonso, Joy, A,199183360.410.000.001000.442359.97
Zeng, Valerie,179772966.030.000.002181.56784.47
Andersen, Katrina,190326938.580.000.002181.564757.02
Alvarez, Krista,194673485.380.000.003485.380.00
Xie, Katie, C,199163354.390.000.001000.442353.95
Malhotra, Raymond, T,132516844.420.000.002049.104795.32
Perez, Regina, S,190317226.380.000.002443.354783.03
Rubio, Victor, S,1619390.470.000.004.9985.48
Zhao, Stacey, J,283652433.040.000.000.002433.04
Harrison, Bianca, J,1788638.970.000.000.0038.97
Wang, Tamara, L,1788159.980.000.000.0059.98
Rodriguez, Deanna,25611564.480.000.00564.480.00
She, Wayne,236072451.300.000.002451.300.00
Hernandez, Adrienne, Y,226681174.480.000.001174.480.00
Watson, Bryce,277991174.480.000.001174.480.00
Dominguez, Jay, A,218572487.330.000.002487.330.00
Zhang, Margaret, G,1605838.250.000.000.0038.25
Shan, Alicia,279646.280.000.000.006.28
Nath, Nichole, K,1239275.470.000.0075.470.00
Sai, Dominique,2890833.430.000.0033.430.00
Gutierrez, Audrey,178292983.330.000.002181.56801.77
Sanchez, Brett,126085689.880.000.002049.103640.78
He, Wesley, I,178493025.530.000.002181.56843.97
Hill, Nathan,126155663.230.000.002071.423591.81
Ma, Ronnie, C,178153123.780.000.002443.35680.43
Ruiz, Derrick, C,126346787.760.000.004490.482297.28
Kelly, Jacqueline,210342533.970.000.00782.991750.98
Ye, Omar,210202497.960.000.00782.991714.97
Perez, Jack,194553478.780.000.003478.780.00
Nath, Leonard, L,126376845.120.000.002049.104796.02
Wang, Aimee,210112527.960.000.00782.991744.97
Andersen, Nichole,126536860.090.000.002049.104810.99
Prasad, Virginia,179333103.310.000.002443.35659.96
Fernandez, Meagan, C,194483543.880.000.003543.880.00
Xu, Ronnie,178922787.510.000.002181.56605.95
Rubio, Lance, E,194773533.770.000.003533.770.00
Romero, Reginald, F,128544367.020.000.002049.102317.92
Lin, Rosa,128564460.380.000.002071.422388.96
Tang, Jaclyn, K,210602508.470.000.00782.991725.48
Raje, Kate,179742791.460.000.002181.56609.90
Vazquez, Jamie,210532542.960.000.00782.991759.97
Gutierrez, Gina, A,210922511.260.000.002511.260.00
Jimenez, Frank,210672483.980.000.00782.991700.99
Ward, Mackenzie, D,211302483.980.000.00782.991700.99
Carlson, Felicia,195023565.360.000.003565.360.00
Gutierrez, Robin,211042566.950.000.00782.991783.96
Ashe, Bethany,1935023.780.000.000.0023.78
Zheng, Leah, R,12627110.940.000.000.00110.94
Jai, Casey, C,2256093.970.000.000.0093.97
Subram, Cesar, L,1147569.460.000.000.0069.46
Gomez, Jay,262324.990.000.000.004.99
Mrs., West, Alyssa,2321939.980.000.000.0039.98
Ramos, Latasha, L,2254029.480.000.000.0029.48
Gomez, Kristine, E,186273027.320.000.002443.35583.97
Rubio, Ross,215401602.470.000.00782.99819.48
Blanco, Jacquelyn,134116819.460.000.002071.424748.04
Gomez, Beth, C,132546801.130.000.002049.104752.03
Liu, Stacey, A,135574443.380.000.002071.422371.96
Rogers, Christina, F,216682518.970.000.00782.991735.98
Jiménez, Javier, M,226871155.480.000.001155.480.00
Brooks, Savannah, R,245582487.330.000.000.002487.33
Ruiz, Jaime, J,25609565.470.000.00565.470.00
Russell, Jason, A,27949553.970.000.00553.970.00

Generated 2024-11-10 15:04:18.215 UTC