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

390 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Luo, Alisha,245342533.930.000.002533.930.00
Carlson, Kristine, C,2875323.780.000.0023.780.00
Prasad, Veronica, J,241991155.480.000.000.001155.48
Serrano, Sheila, C,210182515.250.000.00782.991732.26
Rivera, Seth,17879119.950.000.000.00119.95
Thompson, Nathan, T,2552338.980.000.000.0038.98
Sanz, Ebony, I,207113240.320.00782.990.002457.33
Goel, Tasha, R,1947823.780.000.000.0023.78
Raman, Joel,163173001.040.002181.560.00819.48
Chen, Jeffery, C,168277205.360.000.002443.354762.01
Kumar, Grant, A,255101212.950.000.000.001212.95
Chander, Sheena, L,163084551.520.002181.560.002369.96
Anand, Lindsey, K,225921754.980.000.000.001754.98
Wu, Crystal, W,2267229.480.000.000.0029.48
Alonso, Hector, L,1213497.450.000.000.0097.45
Chandra, Donald,114857048.300.003399.992398.471249.84
Gomez, Kristi,269113.990.000.003.990.00
Vance, Regina, M,149846699.570.003578.270.003121.30
Sharma, Barbara, D,2242158.980.000.000.0058.98
Guo, Crystal,19379103.460.000.000.00103.46
Prasad, Rebekah, A,1591983.970.000.000.0083.97
Griffin, Ashley,248652478.340.000.000.002478.34
Luo, Alvin,236352452.340.000.002452.340.00
Shen, Kara, C,2362869.970.000.000.0069.97
Zhu, Lisa, R,150596793.540.003578.270.003215.27
Patel, Chelsea, P,199384.990.000.000.004.99
She, Omar, K,1544812.940.000.000.0012.94
Ramos, Pedro, P,2941627.770.000.000.0027.77
Guo, Kelvin, H,1770537.260.000.0029.987.28
She, Kelvin, T,2700238.980.000.0038.980.00
Lu, Colin, H,2106969.970.000.000.0069.97
Nara, Alisha, D,26959563.770.000.000.00563.77
Goel, Deborah, S,114898127.510.003374.992359.462393.06
Sanchez, Brett,126085689.880.000.002049.103640.78
Ye, Kelli,1947074.980.000.000.0074.98
Holt, Dale, C,236182481.820.000.002481.820.00
Browning, Marie,26372548.980.000.000.00548.98
Romero, Jerome,113378162.003374.990.002388.962398.05
Hayes, Seth, C,1775779.970.000.000.0079.97
Sanz, Mallory,14938107.970.000.0078.9828.99
Torres, Teresa, M,1618839.980.000.000.0039.98
Raje, Christine, W,172036952.530.000.002181.564770.97
Xie, Terry,208852518.970.000.00782.991735.98
King, Jack, H,1770256.760.000.000.0056.76
Martin, Orlando, C,16300111.950.000.000.00111.95
He, Wesley, I,178493025.530.000.002181.56843.97
Townsend, Trinity, L,12367160.450.000.0049.99110.46
Weadock, Kelly, J,2090969.970.000.000.0069.97
Gutierrez, Kristy,241381194.970.000.000.001194.97
Jai, Kelvin,257962475.950.000.000.002475.95
Chandra, Whitney,1571251.570.000.000.0051.57
He, Cedric, W,252984.990.000.000.004.99
Jimenez, Frank,210672483.980.000.00782.991700.99
Patel, Manuel, M,2088969.970.000.000.0069.97
Castro, Jacquelyn,210932515.250.000.002515.250.00
She, Ramon,180003080.290.000.002443.35636.94
Chande, Christy,26214553.970.000.000.00553.97
Mitchell, Jose, F,2456813.980.000.000.0013.98
Thompson, Noah, L,14547192.950.000.000.00192.95
Torres, Ian, V,172076979.560.000.002181.564798.00
Rubio, Ross,215401602.470.000.00782.99819.48
Pal, Cedric,2323539.980.000.0039.980.00
Jones, Lucas,271586.280.000.000.006.28
Zhang, Brent, L,181737189.350.000.002443.354746.00
Campbell, Katherine, P,2844821.490.000.000.0021.49
Washington, Haley, F,239041198.970.000.000.001198.97
Andersen, Dale, B,1499269.990.000.000.0069.99
Gray, Natalie, L,141655910.550.003578.270.002332.28
Jai, Kate,1470624.990.000.000.0024.99
Beck, Carl, M,163112988.320.002181.56806.760.00
Fernandez, Bruce, E,2688838.980.000.000.0038.98
Wu, Jenny, S,239441155.480.000.000.001155.48
Jai, April,156605169.070.003578.270.001590.80
Liang, Crystal, J,115497023.770.003399.992309.971313.81
Coleman, Gabriel, B,1770637.930.000.000.0037.93
Foster, Mary,241121155.480.000.000.001155.48
Ruiz, Audrey,126456847.760.000.002071.424776.34
Lal, Ashlee, A,284172426.000.000.000.002426.00
Xu, Shawn,1932827.280.000.000.0027.28
Raman, Ebony,1934821.490.000.0021.490.00
Diaz, Julio, J,2409439.980.000.0039.980.00
Martin, Jacquelyn, M,1776337.930.000.000.0037.93
Goel, Shawn, L,190584524.480.000.002181.562342.92
Harris, Jonathan,26220539.990.000.000.00539.99
Tang, Nichole, C,156305136.370.003578.27806.76751.34
Tang, Carly, A,224701735.980.000.000.001735.98
Torres, Cheryl, T,25727539.990.000.00539.990.00
Serrano, Ricky,2793838.980.000.000.0038.98
Simpson, Lindsay, E,25746561.480.000.00561.480.00
Gutierrez, Craig,190494838.300.000.002443.352394.95
Perez, Manuel, C,137777147.073578.270.000.003568.80
Cooper, Mariah, J,279012433.040.000.000.002433.04
Garcia, Arthur, T,2941353.990.000.000.0053.99
Garcia, Carla,1417275.740.000.000.0075.74
Prasad, Frederick,1781087.940.000.0073.9613.98
Mitchell, Logan, R,168287182.660.000.002443.354739.31
Nason, Kirk, J,128745638.540.000.002071.423567.12
Deng, Misty,148615976.740.003578.270.002398.47
Zhang, Cedric, D,26966588.960.000.000.00588.96
Brooks, Christina, W,2249648.970.000.000.0048.97
Suarez, Sheila,2888411.940.000.000.0011.94
Sánchez, Cesar, W,239881179.470.000.000.001179.47
She, Carl, A,123176823.420.000.006823.420.00
He, Clarence,16591137.960.000.000.00137.96
Rubio, Micheal, K,126225135.410.000.002049.103086.31
Torres, Shannon,126125657.910.000.002049.103608.81
Gill, Cheryl, R,2841060.470.000.0060.470.00
Sara, Bruce,223111739.460.000.000.001739.46
Ruiz, Ruben, A,2005582.970.000.000.0082.97
Lal, Gilbert,245772487.330.000.000.002487.33
Sr., Cai, Ramón, S,16599149.460.000.000.00149.46
Smith, Hunter, L,2150724.990.000.0024.990.00
Xu, Jodi,1646047.260.000.000.0047.26
Kumar, Corey,153548297.290.003578.270.004719.02
James, Arianna, A,2579913.980.000.0013.980.00
Carlson, Jerome, J,21817791.470.000.000.00791.47
Moreno, Briana, L,287342419.060.000.000.002419.06
Garcia, Tabitha,27778539.990.000.000.00539.99
Garcia, Bruce, B,1803749.480.000.000.0049.48
Fernandez, Heidi, L,2279824.990.000.000.0024.99
Li, Laura, O,209332518.970.000.00782.991735.98
Sanz, Randall, D,2253998.960.000.000.0098.96
Hernandez, Jonathon, F,156996969.570.002181.560.004788.01
Fernandez, Kari,13788200.810.000.000.00200.81
Butler, Eduardo, G,13533137.940.000.000.00137.94
Anderson, Samuel, D,14199118.940.000.000.00118.94
Sanz, Kendra,177533080.290.000.002443.35636.94
Tang, Brad,254891147.770.000.000.001147.77
Pal, Corey,257742537.320.000.000.002537.32
Diaz, Jimmy, D,2547438.980.000.000.0038.98
Anand, Wayne, H,226861243.440.000.001243.440.00
Gomez, Melody,258052501.310.000.000.002501.31
Kapoor, Carolyn, M,1645947.260.000.007.2839.98
Navarro, Shannon, R,151068421.280.003578.270.004843.01
Sanz, Pedro,181686907.550.000.002181.564725.99
Navarro, Micheal,2362578.960.000.000.0078.96
Cox, Taylor,1143681.760.000.000.0081.76
Zeng, Christy, L,1544177.270.000.000.0077.27
Blanco, Jessie, R,236082510.940.000.002510.940.00
Russell, Christian, S,2282634.980.000.0034.980.00
Wu, Dawn, T,114936958.800.003399.992329.981228.83
Lee, Jacob,135515622.920.000.002049.103573.82
Roberts, Nathan,2947060.470.000.000.0060.47
Pal, Rafael, J,177152831.530.000.002831.530.00
McDonald, Deborah, R,162753282.830.002443.350.00839.48
Ye, Jamie, C,163293272.090.002443.350.00828.74
Zhou, Martha, M,14804138.960.000.000.00138.96
Malhotra, Raymond, T,132516844.420.000.002049.104795.32
Rubio, Casey, A,241524.990.000.000.004.99
Van, Bryant,135624369.090.000.002049.102319.99
Anderson, Benjamin,2080932.280.000.000.0032.28
Lopez, James, E,2080627.280.000.000.0027.28
Rana, Cesar, L,1904429.930.000.000.0029.93
Prasad, Sergio, J,192901605.400.000.001000.44604.96
Stone, Stephanie, S,1906029.930.000.0029.930.00
Ramos, Orlando,2415429.480.000.000.0029.48
Lu, Bianca,132526820.460.000.002071.424749.04
Perez, Bruce, R,1693594.960.000.000.0094.96
Rai, Alisha,26848607.960.000.000.00607.96
Zhou, Claudia, M,112477131.513374.990.002340.231416.29
Hernandez, Maria,149506709.590.003578.270.003131.32
Martinez, George, L,20570114.960.000.000.00114.96
Navarro, Lee,25659567.760.000.000.00567.76
Xie, Carly, R,132536774.450.000.002071.424703.03
Garcia, Emmanuel, T,122636829.380.000.002071.424757.96
Lopez, Courtney,208392511.260.000.002511.260.00
Long, Miguel,2485339.980.000.000.0039.98
Sanz, Naomi,1284039.980.000.0039.980.00
Rana, Andre,27904156.760.000.00156.760.00
Dominguez, Jésus,1708775.210.000.000.0075.21
Dominguez, Albert,27125607.960.000.000.00607.96
Alvarez, Daisy, P,2281969.970.000.000.0069.97
Morris, Savannah,135858368.293578.270.000.004790.02
Taylor, Charles,137927216.083578.270.000.003637.81
Campbell, Jackson,115756806.120.002049.102294.992462.03
Sun, Alisha,1804864.970.000.000.0064.97
Kapoor, Marco,1951286.260.000.000.0086.26
Liu, Alan, V,1646444.970.000.000.0044.97
Phillips, Gabriel, R,2944388.980.000.000.0088.98
Roberts, Mackenzie,2359942.930.000.000.0042.93
Ortega, Robyn,241041155.480.000.000.001155.48
Lopez, Bryant,242184.990.000.000.004.99
Munoz, Meghan, P,27810578.460.000.000.00578.46
Andersen, Bethany,2532439.980.000.0039.980.00
Madan, Troy,254671151.760.000.000.001151.76
Patterson, Melanie,2889869.460.000.0069.460.00
Xu, Terrence, L,2374339.980.000.0039.980.00
Sanders, Jessica,1765038.980.000.000.0038.98
Nara, Casey, E,178122983.330.000.002181.56801.77
Jai, Kelli,225304.990.000.000.004.99
James, Gabriella, S,225941709.980.000.000.001709.98
Zeng, Martha, J,17844196.260.000.007.28188.98
Mehta, Kristina, R,201653191.420.00699.100.002492.32
Deng, Brendan,25726663.440.000.00663.440.00
Gutierrez, Robin,211042566.950.000.00782.991783.96
Suarez, Julio, J,150586639.580.003578.270.003061.31
Sanchez, Heidi,28438574.980.000.000.00574.98
Anand, Dustin,14535123.470.000.00123.470.00
Nara, Roger,26928597.950.000.000.00597.95
Shan, Willie,170982768.530.000.002768.530.00
Anand, Colleen, N,126476886.600.000.002049.104837.50
Zeng, Alan, M,223211700.990.000.000.001700.99
Suri, Tabitha,279576.280.000.000.006.28
Ruiz, Kendra,255981151.760.000.000.001151.76
Romero, Joe, J,179432781.540.000.002181.56599.98
Hall, Julia, R,2733711.940.000.000.0011.94
Munoz, Roberto,17628106.240.000.007.2898.96
Carlson, Lee, S,2107937.270.000.000.0037.27
Huang, Colin,207123261.330.00782.990.002478.34
Alonso, Micheal, W,19307148.980.000.000.00148.98
Raman, Francisco, M,2402013.980.000.000.0013.98
Hu, Candice,27818607.960.000.000.00607.96
Torres, Rodney, L,225201775.470.000.000.001775.47
Martinez, David, R,208692542.960.000.00782.991759.97
Srini, Francisco, H,1260245.260.000.008.9936.27
Jenkins, Nathan, M,122865254.880.000.002849.412405.47
Gonzalez, Stefanie, J,287092419.060.000.002419.060.00
Mrs., West, Alyssa,2321939.980.000.000.0039.98
Raje, Jerry, E,21848564.990.000.000.00564.99
Shan, Jerry,193823443.790.000.003443.790.00
Nath, Sheena,2580039.980.000.000.0039.98
Richardson, Ian,114147191.770.003399.992398.971392.81
Rai, Colin, W,245732563.350.000.000.002563.35
Vance, Kaitlin,2938323.780.000.000.0023.78
Ramos, Daisy,14552103.970.000.000.00103.97
Kapoor, Brenda, C,208342566.950.00782.991783.960.00
He, Arturo,293692422.540.000.000.002422.54
Munoz, Lori, M,226391155.480.000.001155.480.00
Romero, Roy, C,208592508.970.000.00782.991725.98
Ruiz, Roy, L,287042419.060.000.000.002419.06
Suarez, Albert, W,2095032.280.000.000.0032.28
Zeng, Sandra,25608539.990.000.00539.990.00
Garcia, Ryan, J,156928392.300.003578.270.004814.03
Rubio, Rebekah,2469929.480.000.000.0029.48
Guo, Wesley,164703021.040.002181.560.00839.48
Randall, Tammy, C,1379836.270.000.000.0036.27
Ma, Randy, R,2455037.270.000.0037.270.00
Scott, Kyle, D,11419231.750.000.00182.7848.97
Patterson, Jessica,171826950.600.000.002181.564769.04
Hernandez, Anne, B,112407586.233399.990.002369.961816.28
Black, Willie,1817239.980.000.000.0039.98
Zeng, Kelli, M,2282578.960.000.000.0078.96
Srini, Virginia,200483142.45699.100.000.002443.35
Dominguez, Victor, K,14784156.250.000.000.00156.25
Zhang, Trisha,1815682.260.000.000.0082.26
Nath, Leonard, L,126376845.120.000.002049.104796.02
Lal, Alvin,240581164.470.000.000.001164.47
Black, Roger, J,284162442.030.000.000.002442.03
Harrison, Melody,2846860.470.000.000.0060.47
Alvarez, Deanna, K,2472015.230.000.000.0015.23
Sharma, Nina,237601183.470.000.000.001183.47
Mehta, George, L,2056627.280.000.000.0027.28
Munoz, Arthur, L,226081744.970.000.000.001744.97
Raje, Maurice,1482129.990.000.0029.990.00
Kumar, Maurice, L,226001735.980.000.000.001735.98
Shen, Maurice, L,26938722.770.000.000.00722.77
Ramos, Kari, D,247021174.480.000.000.001174.48
Butler, Natalie,2640138.980.000.0038.980.00
Zhou, Curtis,2550538.980.000.000.0038.98
Cox, Cole, M,253156.280.000.000.006.28
Simmons, Wyatt, V,226041735.980.000.000.001735.98
Andersen, Nichole,126536860.090.000.002049.104810.99
Nath, Colin, N,113988114.040.003399.992294.992419.06
Lu, Clayton, L,2361334.980.000.000.0034.98
Shen, Julie,225051735.980.000.000.001735.98
Carlson, Tyrone, S,226624.990.000.000.004.99
Gill, Darren, M,1140834.470.000.0034.470.00
Yuan, Gregory,21822564.990.000.000.00564.99
Nara, Damien, W,2687738.980.000.000.0038.98
Jenkins, Kayla, A,147775923.230.003578.270.002344.96
Diaz, Erik, S,1156534.990.000.000.0034.99
Carlson, Robyn, M,141838321.310.003578.270.004743.04
Lal, Lindsay, H,2055764.970.000.000.0064.97
Rana, Heidi, M,2247598.960.000.000.0098.96
Rivera, Chase,28511562.960.000.000.00562.96
Gomez, Kristine, E,186273027.320.000.002443.35583.97
Alvarez, Roberto,28387583.970.000.000.00583.97
Dominguez, Natasha,2376929.480.000.0029.480.00
Hernandez, Tyrone, C,122715683.180.000.003340.262342.92
Martinez, Andre,165886994.580.000.002181.564813.02
Chen, Marshall, E,190374858.340.000.002443.352414.99
Taylor, Michael,27907578.460.000.000.00578.46
Ramos, Erik, M,253121198.970.000.000.001198.97
Arun, Andre, E,122875720.370.000.003331.922388.45
Liang, Jeffery,15711126.560.000.000.00126.56
Diaz, Stephanie,156947.280.000.000.007.28
She, Gilbert,1950553.470.000.000.0053.47
Prasad, Virginia,179333103.310.000.002443.35659.96
Raman, Andre, D,2407939.980.000.000.0039.98
Davis, Edward,2889621.490.000.0021.490.00
Mehta, Ruth,157026917.540.002181.560.004735.98
Alexander, Justin, M,122725139.730.000.002822.762316.97
Howard, Makayla,1625126.970.000.000.0026.97
Rodriguez, Noah, J,2232513.980.000.000.0013.98
Shan, Tommy, H,226141155.480.000.001155.480.00
She, Clayton,13785121.830.000.000.00121.83
Romero, Reginald, F,128544367.020.000.002049.102317.92
Sun, Stacey, S,193613478.780.000.003478.780.00
Zhu, Stacey, E,226361700.990.000.000.001700.99
Chandra, Regina, M,15057114.960.000.000.00114.96
Munoz, Walter,210562547.950.000.002547.950.00
Green, Luke, R,2839223.780.000.0023.780.00
Wu, Ramon, M,2795538.980.000.000.0038.98
Goel, Latoya, C,112397511.553374.990.002353.951782.61
Raman, Lydia,26868539.990.000.000.00539.99
Ramos, Darren,25470162.990.000.000.00162.99
Lu, Mandy,1498836.270.000.000.0036.27
Romero, Melinda,12260241.760.000.00182.7858.98
Lu, Erica,27009574.980.000.000.00574.98
Nath, Lindsay,2184124.990.000.000.0024.99
Blanco, Jaime,2252839.980.000.000.0039.98
Fernandez, Meagan, C,194483543.880.000.003543.880.00
Li, Susan,278392419.060.000.002419.060.00
Sun, Vincent, F,165857192.390.000.002443.354749.04
Wang, Christy,1949831.270.000.000.0031.27
Li, Jeffery,179693040.310.000.002443.35596.96
Alvarez, Neil, C,224671732.260.000.000.001732.26
Griffin, Jeremiah,181586869.610.000.002181.564688.05
Sai, Jillian,225181735.980.000.000.001735.98
Xu, Derek, M,208242512.960.00782.991729.970.00
Sutton, Marshall,208623240.320.000.00782.992457.33
Yang, Bianca, E,287322419.060.000.000.002419.06
Luo, Alejandro, K,123166799.450.000.006799.450.00
Sandoval, Jill,1414390.580.000.000.0090.58
Gao, Ernest,2782827.770.000.0027.770.00
Beck, Bradley, L,2238868.490.000.0068.490.00
Blue, Oscar, L,27008616.950.000.000.00616.95
Patel, Bruce,271653.990.000.000.003.99
Johnson, Lucas,1350948.960.000.000.0048.96
Blanco, Beth,2944425.480.000.000.0025.48
Raje, Bridget, A,194333478.780.000.003478.780.00
Gao, Margaret,16401102.250.000.000.00102.25
Subram, Meagan, W,1157334.990.000.000.0034.99
Ortega, Hector, E,160543759.360.002181.560.001577.80
Tang, Alvin, L,2167842.930.000.0042.930.00
Kapoor, Jillian, R,1570178.860.000.000.0078.86
Lal, Jerry, L,2782234.470.000.000.0034.47
Edwards, Edward,147005904.230.003578.270.002325.96
Liang, Sandra, J,20949154.980.000.000.00154.98
Shan, Alicia,279646.280.000.000.006.28
Moreno, Kellie, T,163183021.020.002181.560.00839.46
Navarro, Gary, E,135614393.360.000.002049.102344.26
Chande, Tamara, L,28693574.980.000.000.00574.98
Mr., Saravan, K.,14974158.950.000.000.00158.95
Raji, Jenny,2187072.960.000.000.0072.96
Yuan, Katie,194593478.780.000.003478.780.00
Patterson, Emma, J,149416865.570.003578.270.003287.30
Weber, Stanley, E,12311116.430.000.000.00116.43
Cai, Lacey, L,1273342.970.000.000.0042.97
Shan, Nichole, K,1946124.990.000.000.0024.99
Sanders, Richard, D,2151132.270.000.000.0032.27
Fernandez, Clifford, E,2102638.980.000.000.0038.98
Blanco, Rebekah,1814950.230.000.000.0050.23
Lin, Rosa,128564460.380.000.002071.422388.96
Zhang, Jake,226161735.980.000.000.001735.98
Taylor, Joseph, T,122895645.860.000.002049.103596.76
Ortega, Kendra,2559238.980.000.000.0038.98
Townsend, Roberto,193593478.780.000.003478.780.00
Ramos, Julio,1255125.480.000.000.0025.48
Ross, Gabrielle, J,192531540.430.001000.440.00539.99
Suri, Joe,2102837.270.000.000.0037.27
Chande, Lacey, A,2455558.950.000.000.0058.95
Xie, Brad, D,193021577.390.000.001000.44576.95
Smith, Destiny,224281739.460.000.000.001739.46
Martinez, Tabitha,26865123.990.000.00123.990.00
Arun, Chelsea, M,255111134.470.000.000.001134.47
Srini, Ebony, A,179592748.830.000.002181.56567.27
Goel, Tracy, J,1817821.980.000.000.0021.98
Evans, Isaac, A,1718677.270.000.000.0077.27
Schmidt, Michele, M,215451631.460.000.00782.99848.47
Perez, Fernando,2784827.770.000.000.0027.77
Shan, Sharon, A,242111170.480.000.000.001170.48
Xu, Erica, M,208633261.330.000.00782.992478.34
Reed, Rachel, E,126446838.120.000.002049.104789.02
Suri, Andre, D,241891174.480.000.000.001174.48
Williams, Emma, K,16325171.270.000.000.00171.27
Kumar, Peter,2691558.980.000.000.0058.98
Wagner, Deb, R,240301170.480.000.000.001170.48
Wang, Franklin, S,2938627.770.000.0027.770.00
Randall, Kristi,1366514.980.000.000.0014.98
Johnsen, Rebekah, J,199194.990.000.000.004.99
Rai, Kristin, C,1256974.980.000.000.0074.98
Rana, Cassandra,134076904.100.000.002049.104855.00
Schmidt, Theresa,2185424.990.000.000.0024.99
Rai, Alicia, M,2891427.770.000.000.0027.77
Jiménez, Arthur, K,209822546.960.000.002546.960.00
Gonzalez, Tammy, J,25657609.450.000.000.00609.45
Hayes, Marcus, A,156575251.340.003578.270.001673.07
Zeng, Valerie,179772966.030.000.002181.56784.47
Gutierrez, Marie, F,294311249.840.000.001249.840.00

Generated 2025-11-03 01:49:11.475 UTC