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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Ruiz, Jill, P,14423141.910.000.000.00141.91
Gomez, Beth, C,132546801.130.000.002049.104752.03
Romero, Roy, C,208592508.970.000.00782.991725.98
Gutierrez, Robin,211042566.950.000.00782.991783.96
Kovár, Abby, K,25605600.460.000.00600.460.00
Martin, Michele, J,278192419.060.000.002419.060.00
Ashe, Bruce,122645662.900.000.003292.942369.96
Raje, Kenneth,236062543.440.000.002543.440.00
Rodriguez, Ann, S,123156803.130.000.006803.130.00
Rogers, Melissa, J,284152428.050.000.000.002428.05
Gonzales, Katherine, R,134086792.120.000.002049.104743.02
Jimenez, Diana, M,1777672.250.000.000.0072.25
Yuan, Omar, C,123805570.220.000.002049.103521.12
Blanco, Max,26360539.990.000.000.00539.99
Washington, Julia, R,208752518.970.000.00782.991735.98
Xie, Terry,208852518.970.000.00782.991735.98
Lal, Gilbert,245772487.330.000.000.002487.33
Watson, Bryce,277991174.480.000.001174.480.00
Shan, Tommy, H,226141155.480.000.001155.480.00
Prasad, Mayra,112387542.773399.990.003579.82562.96
Gomez, Jésus,294011223.840.000.001223.840.00
Thompson, Benjamin,194353457.770.000.003457.770.00
Alvarez, Cheryl, A,1232077.960.000.000.0077.96
Rubio, Jerome, L,147925913.240.003578.270.002334.97
Xu, Willie, J,141576650.600.003578.270.003072.33
Gomez, Larry, S,257782443.350.000.000.002443.35
Garcia, Bob,191861562.410.001000.440.00561.97
Perez, Fernando,2784827.770.000.000.0027.77
Romero, Alberto,115868.990.000.000.008.99
Chander, Mario,1259067.460.000.000.0067.46
Wu, Susan, L,16564132.270.000.000.00132.27
Goel, Terrence, M,19389138.450.000.000.00138.45
Suarez, Victor, N,2407112.940.000.000.0012.94
Harris, Jonathan,26220539.990.000.000.00539.99
Cox, Taylor,1143681.760.000.000.0081.76
Chen, Tamara,123825606.260.000.002071.423534.84
Martinez, David, R,208692542.960.000.00782.991759.97
Morgan, Makayla, C,271566.280.000.000.006.28
Serrano, Kari,269056.280.000.000.006.28
Zhou, Martha, M,14804138.960.000.000.00138.96
Rodriguez, Noah, J,2232513.980.000.000.0013.98
Muñoz, Dana,2845921.490.000.000.0021.49
Romero, Teresa, A,268346.280.000.000.006.28
Beck, Clayton,1157943.980.000.000.0043.98
Stewart, Megan, L,114137189.750.003399.992350.961438.80
Anderson, Cameron, L,165956901.380.000.002181.564719.82
Jenkins, Devin,2238367.970.000.000.0067.97
Moreno, Raquel, D,256372510.940.000.000.002510.94
Huang, Alvin,1249186.580.000.000.0086.58
Randall, Kristi,1366514.980.000.000.0014.98
Suarez, Max, A,14809115.250.000.0078.9836.27
McDonald, George,113948161.970.003399.992342.922419.06
Sanchez, Janelle,122815169.360.000.002826.442342.92
Andersen, Jaclyn,114686959.820.003374.992319.991264.84
Gao, Martha,1358277.960.000.0068.978.99
Rai, Sheena,2939323.780.000.0023.780.00
Lopez, Jermaine,114888090.330.003374.992322.282393.06
Ortega, Beth, A,122775666.520.000.003309.242357.28
Rodriguez, Chelsea,12525119.980.000.000.00119.98
Blanco, Francis, J,25750553.970.000.000.00553.97
Arun, Andre, E,122875720.370.000.003331.922388.45
Lin, Candice, K,195063480.380.000.001000.442479.94
Sanz, Ebony, I,207113240.320.00782.990.002457.33
Sanz, Randall, D,2253998.960.000.000.0098.96
Dominguez, Deanna,237791147.770.000.000.001147.77
Gao, Marshall,2578258.980.000.000.0058.98
Andersen, Nichole,126536860.090.000.002049.104810.99
Kelly, Olivia, L,123915121.430.000.002049.103072.33
Henderson, Hunter, C,1481263.970.000.000.0063.97
Lin, Franklin, M,2455769.970.000.000.0069.97
Roberts, Gabriella, J,165533001.040.000.002181.56819.48
Sara, Evelyn,160453802.370.002181.560.001620.81
Black, Roger, J,284162442.030.000.000.002442.03
Ma, Stacey,2184031.270.000.0031.270.00
She, Donna, D,1934621.490.000.0021.490.00
Deng, Dustin, F,114227075.270.003399.992334.981340.30
Black, Shawn, A,194993492.760.000.003492.760.00
Luo, Alvin,236352452.340.000.002452.340.00
Sun, Vincent, F,165857192.390.000.002443.354749.04
Prasad, Rebekah, A,1591983.970.000.000.0083.97
Mehta, Ivan, S,263901725.980.000.000.001725.98
Guo, Roger,1353978.960.000.000.0078.96
Hernandez, Ruben, C,210362547.950.000.00782.991764.96
Deng, Shawn, C,16590168.950.000.000.00168.95
Shan, Calvin,208113270.320.00782.990.002487.33
Garcia, Tammy, A,1229386.760.000.000.0086.76
Coleman, Gabriel, B,1770637.930.000.000.0037.93
Perez, Jack,194553478.780.000.003478.780.00
Liang, Wesley, A,121235837.840.002049.102351.961436.78
Sanchez, Preston, J,12506119.980.000.00119.980.00
Beck, Damien, E,2398958.980.000.0058.980.00
Li, Caleb,226401149.470.000.001149.470.00
Anderson, Samuel, D,14199118.940.000.000.00118.94
Yuan, Cedric,1544949.560.000.000.0049.56
Perez, Holly, E,1237675.470.000.000.0075.47
Miller, Olivia, H,26860539.990.000.000.00539.99
Hernandez, Lori,18186139.440.000.000.00139.44
Patel, Manuel, M,2088969.970.000.000.0069.97
Chen, Jeffery, C,168277205.360.000.002443.354762.01
Blanco, Jaime,2252839.980.000.000.0039.98
Ortega, Carrie, L,113538078.020.003374.992309.972393.06
Hill, Gabriella,2636438.980.000.000.0038.98
Howard, Angel, A,232231155.480.000.001155.480.00
Zhang, Benjamin, F,1259342.970.000.008.9933.98
Nelson, Luke, E,210272537.970.000.00782.991754.98
Kelly, Marcus, A,2569947.970.000.000.0047.97
Shen, Maurice, L,26938722.770.000.000.00722.77
Xie, Louis, B,135908306.303578.270.000.004728.03
Gao, Colleen,15108210.540.000.000.00210.54
Martin, Janet, L,2454069.970.000.000.0069.97
Torres, Audrey,1657152.920.000.000.0052.92
Munoz, Rodney,1283668.460.000.000.0068.46
Martinez, Molly, S,13603133.940.000.0083.9749.97
Gill, Cheryl, R,2841060.470.000.0060.470.00
Munoz, Lori, M,226391155.480.000.001155.480.00
Sharma, Alicia, L,194403492.760.000.003492.760.00
Suri, Brenda, D,226431120.490.000.001120.490.00
Price, Wyatt,1233678.980.000.0028.9949.99
Torres, Adrienne, C,114828143.030.003374.992354.982413.06
Gill, Kristi, A,27171588.960.000.000.00588.96
Hernandez, Jonathon, F,156996969.570.002181.560.004788.01
Zhou, Leah, L,223091785.970.000.000.001785.97
Wang, Kyle,2059932.270.000.000.0032.27
Vance, Meagan, F,2940553.990.000.000.0053.99
Shan, Terrence,2090732.280.000.000.0032.28
Bailey, Xavier,123054940.390.000.004391.41548.98
Raman, Martin,1770978.950.000.0048.9729.98
Schmidt, Theresa,2185424.990.000.000.0024.99
Dominguez, Jessie, A,256286.280.000.000.006.28
Blanco, Albert, W,135818374.793578.270.000.004796.52
Raji, Mario,286952419.060.000.000.002419.06
Madan, Donald, R,2716867.490.000.000.0067.49
Miller, Emily, R,113338163.313399.990.002344.262419.06
Liang, Cedric, R,199413078.06699.100.000.002378.96
Morris, Savannah,135858368.293578.270.000.004790.02
Martin, Mallory, J,137947212.060.003578.270.003633.79
Sara, Andre, M,136615913.243578.270.000.002334.97
Shan, Misty,2086837.270.000.000.0037.27
Coleman, Alexis, M,112447175.753399.990.003166.31609.45
Watson, Jan, K,136805948.243578.270.000.002369.97
Rodriguez, Marie, L,179603001.040.000.002181.56819.48
Raman, Joe, G,1651147.260.000.0039.987.28
Moreno, Craig, N,141585976.740.003578.270.002398.47
Jenkins, Caleb,14184105.240.000.000.00105.24
Martin, Derrick,141918301.310.003578.270.004723.04
Sharma, James, L,2104932.280.000.000.0032.28
Bailey, Ariana, J,136915976.743578.270.000.002398.47
Hernandez, Anne, B,112407586.233399.990.002369.961816.28
Black, Willie,1817239.980.000.000.0039.98
Hu, Lisa, L,2111834.980.000.000.0034.98
Brown, Nicole,113348154.023399.990.002334.972419.06
Zhang, Brent, L,181737189.350.000.002443.354746.00
Romero, Jerome,113378162.003374.990.002388.962398.05
Ruiz, Theodore,200523214.03699.100.002514.930.00
Taylor, Joseph, T,122895645.860.000.002049.103596.76
Tang, Kurt, G,138475888.243578.270.000.002309.97
Perez, Manuel, C,137777147.073578.270.000.003568.80
McDonald, Jenny,1654353.960.000.000.0053.96
Madan, Edgar, M,27131603.490.000.000.00603.49
Nath, Clayton,147935948.240.003578.270.002369.97
Munoz, Billy, J,141506705.590.003578.27777.342349.98
Raji, Nina, W,294802442.030.000.000.002442.03
Munoz, Stacy,12310103.960.000.000.00103.96
Sara, Toni, E,141466750.560.003578.27827.332344.96
Gray, Natalie, L,141655910.550.003578.270.002332.28
Blanco, Clinton, J,141958316.290.003578.270.004738.02
Harrison, Reginald, M,237741234.450.000.000.001234.45
Zimmerman, Curtis, T,147026729.570.003578.27777.342373.96
Wu, Jaclyn,2403513.980.000.000.0013.98
Liang, Heather, E,205523034.070.00699.100.002334.97
Ramos, Anne, R,113518068.030.003374.992294.992398.05
Raman, Meredith,113818161.020.003399.992341.972419.06
Vazquez, Lee,148436690.580.003578.270.003112.31
Zhao, Dennis,201733181.330.00699.100.002482.23
Arthur, Ronald, D,147765908.250.003578.270.002329.98
Chen, Alejandro,149476658.580.003578.270.003080.31
Martin, Joseph,113886986.750.003374.992342.921268.84
Nath, Colin, N,113988114.040.003399.992294.992419.06
Stewart, Brianna, L,205583019.090.00699.100.002319.99
Scott, Dalton,149755957.220.003578.270.002378.95
Rana, Marie, A,273086.280.000.000.006.28
Roberts, Gabrielle, E,294321307.310.000.000.001307.31
Tang, Casey,150465943.250.003578.270.002364.98
Sun, Heather,287292452.040.000.000.002452.04
Patel, Roy, A,149286706.570.003578.270.003128.30
Munoz, Daisy,150815900.550.003578.270.002322.28
Raman, Tammy,1212681.760.000.000.0081.76
Liu, Willie,205613139.090.00699.100.002439.99
Lopez, Dominique, S,150776673.530.003578.270.003095.26
Serrano, Jonathon, F,239541178.450.000.000.001178.45
Suarez, Julio, J,150586639.580.003578.270.003061.31
Butler, Eduardo, G,13533137.940.000.000.00137.94
Kapoor, Marco,1951286.260.000.000.0086.26
Weadock, Kelly, J,2090969.970.000.000.0069.97
Rana, Heidi, M,2247598.960.000.000.0098.96
Cai, Lacey, L,1273342.970.000.000.0042.97
Subram, Allen,1789529.980.000.000.0029.98
Sanz, Frank, T,208512518.970.000.00782.991735.98
Gao, Jessie,205643059.080.00699.100.002359.98
Sanz, Robin, L,150875917.240.003578.270.002338.97
Prasad, Martin,150895895.240.003578.270.002316.97
Navarro, Shannon, R,151068421.280.003578.270.004843.01
Subram, Levi,156195908.250.003578.270.002329.98
Goel, Deborah, S,114898127.510.003374.992359.462393.06
Perez, Andre,114918158.010.003374.992329.982453.04
Anand, Nicolas, P,205673074.080.00699.100.002374.98
Robinson, Brandon, J,156615208.040.003578.270.001629.77
Henderson, Julian, J,156918341.290.003578.270.004763.02
Luo, Calvin, T,191721609.410.001000.440.00608.97
Sanchez, Edgar,116046786.120.002049.102343.962393.06
Lin, Erica, E,160333743.390.002181.560.001561.83
Foster, Alexia,115686789.460.002071.422319.992398.05
Torres, Deb,115505241.430.002049.103192.330.00
Deng, Tonya, O,1793664.970.000.000.0064.97
Zhou, Lisa, L,13809113.960.000.000.00113.96
Gill, Marvin, M,178216.280.000.000.006.28
Shan, Cedric, H,237751155.480.000.000.001155.48
Patterson, Margaret, J,1350743.970.000.000.0043.97
Anand, Colleen, N,126476886.600.000.002049.104837.50
Nath, Lindsay,2184124.990.000.000.0024.99
Ward, Alex, I,14542115.250.000.000.00115.25
Rai, Kristin, C,1256974.980.000.000.0074.98
Perez, Frederick,160533752.380.002181.560.001570.82
Beck, Carl, M,163112988.320.002181.56806.760.00
Henderson, Dakota, M,164063110.050.002181.56928.490.00
Xie, Colleen, C,121335830.680.002071.422441.931317.33
Raje, Brendan,162504511.540.002181.560.002329.98
Huang, Colin,207123261.330.00782.990.002478.34
Bryant, Noah,164173001.040.002181.560.00819.48
Navarro, Joy,164103242.770.002443.350.00799.42
Ruiz, Erika, J,191921682.410.001000.440.00681.97
Raje, Julie, H,122146803.920.002049.100.004754.82
Munoz, Kristine,164463093.030.002181.560.00911.47
Kapoor, Brenda, C,208342566.950.00782.991783.960.00
Ross, Ryan,164283021.020.002181.560.00839.46
Subram, Jermaine,287312452.040.000.000.002452.04
Jai, Damien,14806242.940.000.000.00242.94
Xie, Franklin, A,177472743.530.000.002181.56561.97
Jai, Casey, C,2256093.970.000.000.0093.97
Subram, Cesar, L,1147569.460.000.000.0069.46
Henderson, Marissa,13816260.830.000.000.00260.83
Ruiz, Derrick, C,126346787.760.000.004490.482297.28
Edwards, Julia, M,1620096.950.000.0039.9856.97
Zhao, Valerie, R,1349348.960.000.0033.9814.98
Sara, Arthur, D,237531193.450.000.000.001193.45
Lopez, Courtney,208392511.260.000.002511.260.00
Beck, Cristina, J,122845625.250.000.003295.262329.99
Jones, Chloe,208382541.940.000.002541.940.00
Liu, Vincent,208482558.460.000.002558.460.00
Hu, Micah, A,165413028.020.000.002181.56846.46

Generated 2025-11-02 04:06:21.432 UTC