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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Wu, Jeffery, D,25757628.970.000.000.00628.97
Smith, Terrance, I,194243511.760.000.003511.760.00
Cooper, Mariah, J,279012433.040.000.000.002433.04
Andersen, Christine, A,2794512.980.000.000.0012.98
Prasad, Regina, A,241921155.480.000.000.001155.48
Liu, Damien, M,172147211.390.000.002443.354768.04
Watson, Ian, G,263981758.950.000.000.001758.95
Diaz, Armando, P,179783018.010.000.002181.56836.45
Sanz, Natasha,14839156.250.000.000.00156.25
Fernandez, Deanna,2455469.970.000.000.0069.97
Lewis, Katherine,1481663.970.000.000.0063.97
Edwards, Julia, M,1620096.950.000.0039.9856.97
Washington, Kelly, M,2874823.780.000.000.0023.78
Vazquez, Stacy,225594.990.000.004.990.00
Rana, Andre,27904156.760.000.00156.760.00
Vance, Francisco, A,2097269.970.000.000.0069.97
Clark, Marcus, G,2795838.980.000.000.0038.98
Martin, Mallory, J,137947212.060.003578.270.003633.79
Ruiz, Nelson,2363829.990.000.000.0029.99
Diaz, Austin, M,1255086.750.000.000.0086.75
Lu, Bianca,132526820.460.000.002071.424749.04
Goel, Willie, T,226561169.460.000.001169.460.00
Alonso, Larry, B,1358697.960.000.000.0097.96
Perez, Jack,194553478.780.000.003478.780.00
Rubio, Jésus,25616539.990.000.00539.990.00
Sanz, Frank, T,208512518.970.000.00782.991735.98
Rai, Cassie, R,14194168.930.000.0068.9799.96
Williams, Abigail, M,169383110.050.000.002181.56928.49
Shen, Carl, L,1919027.280.000.000.0027.28
Rana, Barry,148325938.240.003578.270.002359.97
Cox, Isaiah, E,135848361.293578.270.000.004783.02
Saunders, Dominique, M,294692393.060.000.000.002393.06
Huang, Martha, E,2640838.980.000.000.0038.98
Yuan, Drew, R,216791700.990.000.000.001700.99
Campbell, Katherine, P,2844821.490.000.000.0021.49
Andersen, Dale, B,1499269.990.000.000.0069.99
Sharma, Jaclyn, C,284032419.060.000.000.002419.06
Patel, Barry, J,262186.280.000.000.006.28
Zhang, Alvin,1908239.980.000.000.0039.98
Castro, Jacquelyn,210932515.250.000.002515.250.00
Diaz, Erik, S,1156534.990.000.000.0034.99
Carlson, Lee, S,2107937.270.000.000.0037.27
Tang, Alejandro, L,1154234.470.000.000.0034.47
Prasad, Rebekah, A,1591983.970.000.000.0083.97
Black, Willie,1817239.980.000.000.0039.98
Chen, Krystal, D,13530186.280.000.000.00186.28
Rana, Summer, M,25703607.960.000.00607.960.00
Zhang, Jake,226161735.980.000.000.001735.98
Romero, Kristine, W,1630629.260.000.000.0029.26
Wang, Cara,2102391.950.000.000.0091.95
Martin, Gloria, A,12325132.950.000.000.00132.95
Gao, Claudia,136907162.083578.270.000.003583.81
Rodriguez, Deanna,25611564.480.000.00564.480.00
Foster, Jordan, M,208073249.310.00782.990.002466.32
Browning, Carrie, G,192991587.410.001000.440.00586.97
Vance, Marie, W,210122497.960.000.00782.991714.97
Rodriguez, Manuel, A,246971170.480.000.000.001170.48
Chande, Kelsey, K,148466744.570.003578.270.003166.30
Madan, Cindy, R,1225986.750.000.0027.7758.98
Alexander, Ana, R,226371714.970.000.000.001714.97
Romero, Alberto,115868.990.000.000.008.99
Gill, Darren, M,1140834.470.000.0034.470.00
Deng, Ricardo,2111137.270.000.0037.270.00
Robinson, Jasmine,26886553.970.000.000.00553.97
McDonald, Harold, J,150516650.600.003578.270.003072.33
Hernandez, Maria,149506709.590.003578.270.003131.32
Ramos, Daisy,14552103.970.000.000.00103.97
Romero, Jaime, B,28508574.980.000.000.00574.98
Martin, Ross,162013058.010.002181.560.00876.45
Chande, Tamara, L,28693574.980.000.000.00574.98
Lopez, Holly,26876588.960.000.000.00588.96
Alonso, Briana,21830539.990.000.000.00539.99
Navarro, Micheal,2362578.960.000.000.0078.96
Zhao, Omar,279273.990.000.000.003.99
Rodriguez, Stefanie, L,124595618.540.000.002071.423547.12
Nath, Clarence,240501164.470.000.000.001164.47
Chandra, Deanna,181416972.860.000.002181.564791.30
Rai, Priscilla, C,126195200.410.000.002049.103151.31
Stewart, Natalie, F,17710113.940.000.000.00113.94
Subram, Dominique, S,156205959.720.003578.270.002381.45
Lal, Tony,28515565.470.000.000.00565.47
Lu, Erica,27009574.980.000.000.00574.98
Raman, Joel,163173001.040.002181.560.00819.48
Hernandez, Francis,211032506.950.000.002506.950.00
Scott, Kyle, D,11419231.750.000.00182.7848.97
Ashe, Francisco, W,123356912.600.000.006912.600.00
Moreno, Lee,2563253.980.000.0053.980.00
Carlson, Darren, D,294782398.050.000.000.002398.05
She, Kurt,262062478.340.000.000.002478.34
Jenkins, Kayla, A,147775923.230.003578.270.002344.96
Sai, Sergio,124735665.220.000.002071.423593.80
Garcia, Kristopher, M,190704748.330.000.002443.352304.98
King, Adam, M,1693214.560.000.000.0014.56
Patel, Dominic,293662419.060.000.000.002419.06
Bhat, Drew,1482037.270.000.0037.270.00
He, Arturo,293692422.540.000.000.002422.54
Cox, Melanie, C,12496204.580.000.000.00204.58
Sanchez, Edgar,116046786.120.002049.102343.962393.06
Washington, Cassidy,1770134.470.000.0029.484.99
Bryant, Marissa, A,2889221.490.000.000.0021.49
Hu, Curtis, G,278802393.060.000.000.002393.06
Black, Tamara, L,242021120.490.000.000.001120.49
Taylor, Joseph, T,122895645.860.000.002049.103596.76
Perez, Meredith, A,235972482.230.000.002482.230.00
Raje, Melvin,1158034.990.000.000.0034.99
Yuan, Barbara,2151549.480.000.000.0049.48
Navarro, Arthur,16198114.960.000.000.00114.96
Lopez, Morgan, F,1946663.970.000.000.0063.97
Anand, Wayne, H,226861243.440.000.001243.440.00
Madan, Ross, C,279293.990.000.003.990.00
Suri, Brenda, D,226431120.490.000.001120.490.00
King, Wyatt,226711155.480.000.001155.480.00
Mitchell, Fernando,179812983.340.000.002443.35539.99
Zeng, Alan, M,223211700.990.000.000.001700.99
Zhang, Brent, L,181737189.350.000.002443.354746.00
Ramos, Alberto,122396901.420.002071.420.004830.00
Martin, Michele, J,278192419.060.000.002419.060.00
Ms., Song, Lolan,190734760.320.000.002443.352316.97
Schmidt, Kristina,123186808.150.000.006808.150.00
Lal, Tasha, A,2840823.780.000.000.0023.78
King, Thomas, M,294331289.330.000.000.001289.33
Shen, Casey, D,1250384.460.000.0025.4858.98
Wang, Dawn, L,2715238.980.000.000.0038.98
Navarro, Erika, K,1147653.990.000.000.0053.99
Patel, Joel,278202419.060.000.002419.060.00
Torres, Audrey,1657152.920.000.000.0052.92
He, Alan, A,122106825.450.002071.420.004754.03
Fernandez, Dominique,128394392.020.000.002049.102342.92
Anand, Dustin,14535123.470.000.00123.470.00
Nath, Nichole, K,1239275.470.000.0075.470.00
Jai, Kate,1470624.990.000.000.0024.99
Gutierrez, Lori,240651170.480.000.000.001170.48
Nara, Terry,273051714.970.000.000.001714.97
Harrison, Melody,2846860.470.000.000.0060.47
Alonso, Eddie, L,164202959.000.002181.560.00777.44
Suarez, Julio, J,150586639.580.003578.270.003061.31
Rubio, Micheal, K,126225135.410.000.002049.103086.31
Hill, Nathan,126155663.230.000.002071.423591.81
Gomez, Jay,262324.990.000.000.004.99
Lal, Tamara,135768330.793578.270.000.004752.52
Madan, Harold, A,239381120.490.000.000.001120.49
Torres, Cheryl, T,25727539.990.000.00539.990.00
Gao, Margaret,16401102.250.000.000.00102.25
He, Franklin, K,181276982.070.000.002181.564800.51
Malhotra, Troy,1156934.990.000.000.0034.99
Hu, Vincent, F,28372607.960.000.000.00607.96
Munoz, Lori, M,226391155.480.000.001155.480.00
Mitchell, Isaac,14554178.450.000.000.00178.45
Vance, Kaitlin,2938323.780.000.000.0023.78
Ruiz, Briana,2090632.280.000.000.0032.28
Morgan, Sean,14993152.940.000.0074.9877.96
Young, Evan,1273935.000.000.000.0035.00
Zheng, Trisha,224371739.460.000.000.001739.46
Zhao, Valerie, R,1349348.960.000.0033.9814.98
Zhao, Rafael,1341245.260.000.000.0045.26
Raje, Brendan,162504511.540.002181.560.002329.98
Ye, Sandra,246891155.480.000.000.001155.48
Coleman, Trevor, C,253133.990.000.000.003.99
Dominguez, Julio, E,170943001.040.000.002181.56819.48
Henderson, Marissa,13816260.830.000.000.00260.83
Alvarez, Deanna, K,2472015.230.000.000.0015.23
Alexander, Natalie, A,25760567.760.000.000.00567.76
James, Gabriella, S,225941709.980.000.000.001709.98
Tang, Jaclyn, K,210602508.470.000.00782.991725.48
Kovar, Kristina, R,26910588.960.000.000.00588.96
Brooks, Christina, W,2249648.970.000.000.0048.97
Ruiz, Roy, L,287042419.060.000.000.002419.06
Navarro, Robin, J,286962428.050.000.000.002428.05
Navarro, Audrey, S,26937619.460.000.000.00619.46
Munoz, Stacy,12310103.960.000.000.00103.96
Zeng, Valerie,179772966.030.000.002181.56784.47
Hu, Darryl,248682501.310.000.000.002501.31
Kovár, Abby, K,25605600.460.000.00600.460.00
Luo, Dale, M,226131183.470.000.001183.470.00
Martin, Carolyn, M,12652182.940.000.000.00182.94
Ward, Mackenzie, D,211302483.980.000.00782.991700.99
Hu, Lisa, L,2111834.980.000.000.0034.98
Diaz, Teresa, L,169463071.030.000.002181.56889.47
Xu, Terrence, L,2374339.980.000.0039.980.00
Rubio, Teresa, R,27121539.990.000.000.00539.99
Robinson, Nicole,2873023.780.000.0023.780.00
Diaz, Alexandria,1992639.980.000.000.0039.98
Alonso, Arthur, M,1905421.980.000.000.0021.98
Rubio, Clinton, A,25612574.980.000.00574.980.00
Zeng, Aimee,1934231.270.000.000.0031.27
Lopez, James, E,2080627.280.000.000.0027.28
Chander, Lindsey,26949565.470.000.000.00565.47
Munoz, Meghan, P,27810578.460.000.000.00578.46
James, Jade, M,26400132.980.000.00132.980.00
Gomez, Joe, E,1657444.970.000.004.9939.98
Luo, Cassie,164523071.010.002181.560.00889.45
Roberts, Gabrielle, E,294321307.310.000.000.001307.31
Alvarez, Krista,194673485.380.000.003485.380.00
Raji, Marshall, L,27175565.470.000.000.00565.47
Suarez, Larry, D,286942393.060.000.002393.060.00
Arun, Emmanuel, R,2846321.490.000.000.0021.49
Suri, Clifford,1936963.970.000.000.0063.97
Raje, Damien, S,257844.990.000.000.004.99
Alexander, Riley,2279934.980.000.000.0034.98
Mehta, Kristina, R,201653191.420.00699.100.002492.32
Suarez, Kendra,2361532.280.000.000.0032.28
Carlson, Diane, W,2107443.970.000.000.0043.97
Gonzalez, Geoffrey,116036767.140.002049.102319.992398.05
Arun, Heidi, Z,201493165.420.00699.100.002466.32
Wang, Lisa, J,1720574.980.000.000.0074.98
Mr., Saravan, K.,14974158.950.000.000.00158.95
Raji, Cristina, E,255061155.480.000.000.001155.48
Blanco, Clinton, J,141958316.290.003578.270.004738.02
Suri, Cynthia,225894.990.000.000.004.99
Prasad, Martin,150895895.240.003578.270.002316.97
Perez, Andre,114918158.010.003374.992329.982453.04
Johnson, Lucas,1350948.960.000.000.0048.96
Blanco, Max,26360539.990.000.000.00539.99
Williams, Jennifer, E,1945792.480.000.000.0092.48
Subram, Gerald,215173172.970.000.00782.992389.98
Mitchell, Logan, R,168287182.660.000.002443.354739.31
Howard, Grace, J,208643234.290.000.00782.992451.30
Miller, Olivia, H,26860539.990.000.000.00539.99
Zhang, Candice, J,237771179.470.000.000.001179.47
Serrano, Jill,240261212.970.000.000.001212.97
Suarez, Victor, N,2407112.940.000.000.0012.94
Sanz, Robin, L,150875917.240.003578.270.002338.97
Nara, Omar, J,1353559.200.000.000.0059.20
Butler, Kayla, J,25748539.990.000.00539.990.00
Xu, Karen, E,171153008.020.000.002181.56826.46
Chande, Christy,26214553.970.000.000.00553.97
Black, Tara,2421648.970.000.000.0048.97
Garcia, Bob,191861562.410.001000.440.00561.97
Liang, Krystal, S,124045251.710.000.002071.423180.29
Black, Raul,253011170.480.000.000.001170.48
Martin, Darren,226951174.480.000.001174.480.00
Alvarez, Julio,262052451.300.000.000.002451.30
Shan, Cristina,14783158.960.000.000.00158.96
Garcia, Meredith,1711047.260.000.000.0047.26
Deng, Dustin, F,114227075.270.003399.992334.981340.30
Sun, Alejandro, B,239231174.480.000.000.001174.48
Johnsen, Jerome,28367600.460.000.000.00600.46
Sun, Trisha,224421709.980.000.000.001709.98
Hall, Jenna,240151155.480.000.000.001155.48
Harrison, Bianca, J,1788638.970.000.000.0038.97
Rai, Dale, E,2173937.270.000.000.0037.27
Gao, Marshall,2578258.980.000.000.0058.98
Fernandez, Dominic,236302481.820.000.002481.820.00
Li, Susan,278392419.060.000.002419.060.00
Liu, Vincent,208482558.460.000.002558.460.00
Rana, Martin,242131214.460.000.000.001214.46
Chandra, Donald,114857048.300.003399.992398.471249.84
Lal, Lindsay, H,2055764.970.000.000.0064.97
Carlson, Tyrone, S,226624.990.000.000.004.99
Malhotra, Ivan, E,1155821.490.000.000.0021.49

Generated 2025-11-04 05:37:37.906 UTC