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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Martin, Gina, E,11078793.270.000.00158.36634.91
Serrano, Albert, E,133284708.020.000.000.004708.02
Perry, Ryan,132494795.340.000.000.004795.34
Hughes, Destiny, P,28027119.980.000.000.00119.98
Flores, Nathan, C,2463713.980.000.000.0013.98
Lee, Ethan, J,223597.280.000.000.007.28
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Hall, Amber,20106131.950.000.000.00131.95
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Shan, Benjamin,235663578.270.003578.270.000.00
Phillips, Jack, R,259952443.350.000.002443.350.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Blanco, Armando, F,139182397.950.000.000.002397.95
Morgan, Angela,24665109.970.000.000.00109.97
Butler, Trevor,2741569.990.000.0069.990.00
Hall, Wyatt,2382713.980.000.000.0013.98
Ramirez, Emma,29072128.970.000.000.00128.97
Bell, Brooke, H,2325339.980.000.000.0039.98
Anderson, Ashley,206803219.580.000.002049.101170.48
Cooper, Ariana,17348205.420.000.000.00205.42
Lopez, Bailey, R,185571179.470.000.001179.470.00
Hughes, Brittany,14387898.460.000.000.00898.46
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Walker, Jasmine,134604693.040.000.000.004693.04
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Hughes, Riley,2928449.990.000.000.0049.99
Johnson, Andrew, F,262942443.350.000.002443.350.00
King, Morgan,196811179.970.000.000.001179.97
Hall, Charles,234764.990.000.000.004.99
Stewart, Grace, H,247737.280.000.000.007.28
Martin, Nicholas,233627.280.000.000.007.28
Turner, Eduardo,158764789.020.000.000.004789.02
Diaz, Hunter, S,27242782.990.000.00782.990.00
Rogers, Olivia,12020804.470.000.000.00804.47
Lewis, Brandon, A,2903769.990.000.000.0069.99
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Russell, Caleb,23552103.480.000.000.00103.48
White, Tyler,14291258.440.000.0049.97208.47
Ramos, Derrick,18449100.940.000.0030.9769.97
Lopez, Carlos,186171147.770.000.000.001147.77
Ross, Kaitlyn,16121614.470.000.000.00614.47
Allen, Angel, G,15571101.850.000.0034.8966.96
Zhang, Connor, R,138532329.980.000.000.002329.98
Harris, Emily, P,1986298.480.000.000.0098.48
Hill, Blake,11748131.540.000.000.00131.54
Allen, Allison, A,1975737.270.000.000.0037.27
Walker, Isabella,243864143.740.003578.27565.470.00
Hill, Haley, J,161033142.320.000.00792.342349.98
Campbell, Evan, W,243424828.110.003578.270.001249.84
Lu, Alejandro,2562039.980.000.000.0039.98
Parker, Caleb, A,2631813.980.000.000.0013.98
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Hayes, Austin,202083219.580.002049.100.001170.48
Lee, Ian,19646197.040.000.000.00197.04
Roberts, Jordan, M,1680039.250.000.000.0039.25
Cooper, Amanda, P,146064716.020.000.000.004716.02
Campbell, Angel, D,195461174.480.000.000.001174.48
Washington, Alexis,1978146.260.000.007.2838.98
Garcia, Lucas,27545782.990.000.00782.990.00
Alexander, Julian,132172351.960.000.000.002351.96
Bradley, Rachel,158504813.040.000.000.004813.04
Foster, Deb,215012661.400.000.002661.400.00
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Thomas, William, A,216142589.090.000.002049.10539.99
Price, Oscar, G,11833240.010.000.000.00240.01
Price, Jocelyn, D,258752443.350.002443.350.000.00
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Li, Jordan,17026261.390.000.00171.9389.46
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Miller, Sydney, A,134404818.530.000.000.004818.53
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Diaz, Katherine, P,115262376.960.000.002376.960.00
Turner, James, E,16841126.960.000.0069.9956.97
Price, Lauren, J,14079184.740.000.0037.29147.45
Zukowski, Jake,220584118.263578.270.000.00539.99
James, Christina,17409219.920.000.000.00219.92
Ward, Natalie, J,132412325.960.000.000.002325.96
Lobao, Alexandre,1892691.950.000.0091.950.00
Price, Caroline,180511735.980.000.000.001735.98
Hall, Morgan,2172641.950.000.000.0041.95
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Long, Kaitlyn,233964891.610.003578.270.001313.34
Gonzalez, Jordan,15157213.940.000.00123.9889.96
James, Adrian, C,253404.990.000.000.004.99
Sanders, Chloe, C,231375314.250.003578.270.001735.98
Blue, Marcus, L,27550782.990.000.00782.990.00
Gonzales, Luis,15856116.250.000.0037.2778.98
Nath, Kenneth, W,170372334.970.000.000.002334.97
Anderson, David, A,2209761.960.000.0061.960.00
Luo, Franklin, J,2202759.980.000.000.0059.98
Ramos, Kristi,151764703.030.000.000.004703.03
Winston, Ethan, R,216222612.060.000.002049.10562.96
Torres, Xavier,16840176.950.000.000.00176.95
Edwards, Hailey,242584.990.000.000.004.99
Watson, Victoria,16125588.960.000.000.00588.96
Chavez, Kara, P,13285214.350.000.0012.94201.41
Lee, Samantha, B,2737878.980.000.000.0078.98
Parker, Madeline, H,221826006.320.003578.270.002428.05
Morgan, Brianna, D,111362380.470.000.002380.470.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Taylor, Victoria,260132443.350.000.002443.350.00
Carter, Jesse, E,22141166.280.000.000.00166.28
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Jackson, Charles, P,112771305.660.000.00237.821067.84
Moore, Taylor, A,199874564.450.003374.990.001189.46
Peterson, Alex, M,13423132.900.000.000.00132.90
Price, Marissa,15826160.740.000.00120.4840.26
Wang, Austin, A,1463284.970.000.009.9974.98
Hill, Carlos,12919257.880.000.00158.9398.95
Stewart, Amanda, M,1531094.440.000.000.0094.44
Anderson, Madison, G,2835978.980.000.000.0078.98
Flores, Julia, E,172631700.990.000.000.001700.99
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Foster, Olivia,238063578.270.003578.270.000.00
Hughes, Edward,200234530.470.003374.990.001155.48
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Martin, Samuel,15874225.440.000.0069.99155.45
Sharma, Samuel,27725119.980.000.000.00119.98
Brooks, Ian, W,2829064.470.000.000.0064.47
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Williams, Zachary, B,27099782.990.000.00782.990.00
James, Emma,127812329.980.000.000.002329.98
Hayes, Carson, A,124472331.950.000.000.002331.95
Thomas, Edward, E,19147133.710.000.000.00133.71
Cooper, Brianna,2592513.980.000.000.0013.98
Sharma, Kathryn,20740140.940.000.000.00140.94
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Flores, Megan, N,230746021.820.003578.270.002443.55
Adams, Connor,214232888.560.000.002049.10839.46
Thomas, David,168363193.790.000.000.003193.79
Green, Isabella,26620699.10699.100.000.000.00
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Hughes, Austin, P,183681754.980.000.000.001754.98
Foster, Aaron,155664912.470.000.000.004912.47
Thomas, Logan, A,14091251.200.000.0053.99197.21
Jai, Samuel, L,1635887.950.000.0039.9947.96
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Alexander, Edward, E,18524195.950.000.000.00195.95
Roberts, Wyatt,15900699.970.000.00699.970.00
Ward, Destiny,16128539.990.000.000.00539.99
Henderson, Logan, C,2236656.970.000.000.0056.97
Roberts, Amber, W,215822638.060.000.002049.10588.96
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Roberts, Carlos,2319639.980.000.000.0039.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Washington, Lauren, R,229985329.250.003578.271750.980.00
Moore, Anthony, M,2473039.980.000.000.0039.98
Butler, Cassidy, L,21792114.460.000.000.00114.46
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Alexander, Jordan,2141259.980.000.0059.980.00
Cooper, Angela,195261179.470.000.000.001179.47
Phillips, James, G,16846180.950.000.00123.9856.97
Foster, Trevor, J,2896469.990.000.000.0069.99
Bradley, Jocelyn,230227.280.000.000.007.28
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Diaz, Richard, A,2668264.470.000.000.0064.47
Turner, Amanda, L,203183241.900.002071.420.001170.48
Price, Miranda,26629699.10699.100.000.000.00
Peterson, Jared,11502829.370.000.00171.95657.42
Garcia, Xavier, M,2030071.970.000.000.0071.97
Thompson, Isabella,18756128.410.000.000.00128.41
James, Zoe, R,14611304.550.000.000.00304.55
Martin, Christian, V,19709197.250.000.000.00197.25
Adams, Carlos,1982236.960.000.000.0036.96
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Bennett, Antonio, C,11631707.500.000.00156.86550.64
Peterson, Morgan, J,168341750.980.000.000.001750.98
Scott, Mason,2355139.980.000.000.0039.98
Li, Eugene, A,15283865.950.000.000.00865.95
Peterson, Julia, P,16497132.710.000.000.00132.71
Morris, Jessica,289678.990.000.008.990.00
Watson, Devin, A,18875114.950.000.000.00114.95
Prasad, Summer, M,2214339.980.000.0039.980.00
Patterson, Austin, O,270247.280.000.000.007.28
Harris, Matthew,14330806.760.000.000.00806.76
James, Juan,232674862.090.003578.271283.820.00
Campbell, Lucas,2932953.990.000.000.0053.99
Hughes, Luke, I,270141274.080.00699.100.00574.98
Torres, Taylor,16666205.440.000.00123.9881.46
Powell, Blake, J,2237139.980.000.000.0039.98
Miller, Alexis, A,12196124.930.000.000.00124.93
Suri, Carolyn, S,12972175.710.000.000.00175.71
Garcia, Jonathan,1888386.960.000.0029.9956.97
Foster, Nicole, A,2349489.970.000.000.0089.97
Collins, Sierra,185491169.460.000.001169.460.00
Clark, Miguel, D,169872414.990.000.000.002414.99
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Washington, Kayla, E,14655174.960.000.0069.97104.99
Robinson, Emily,12183228.420.000.0054.96173.46
Perry, Jonathan, T,27026699.100.00699.100.000.00
Jones, Natalie, A,11845197.200.000.0082.26114.94
Shan, Christian, L,2308439.980.000.000.0039.98
Martinez, Dominique,287888.990.000.008.990.00
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Bryant, Isabelle,233974828.110.003578.270.001249.84
Smith, Alexandra,2829261.960.000.000.0061.96
Ross, Natalie, J,12916261.220.000.000.00261.22
Jackson, Hannah, G,131432404.970.000.000.002404.97
Andersen, Latoya, J,290578.990.000.000.008.99
Simmons, Mariah,266831270.820.00699.100.00571.72
Howard, Erin, L,183621725.210.000.000.001725.21
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Reed, Melanie, A,28160574.980.000.000.00574.98
Sanders, Megan, A,15376136.240.000.000.00136.24
Lee, Kayla, M,2078115.230.000.000.0015.23
Cooper, Andrea,2932378.980.000.000.0078.98
Harris, Natalie,2368259.980.000.0059.980.00
Clark, Emily, R,120862294.990.000.000.002294.99
Watson, Richard,15943365.410.000.000.00365.41
Brown, Jonathan,11875265.420.000.000.00265.42
Watson, Cole, A,217684118.263578.270.000.00539.99
Xu, Louis,2010466.530.000.0066.530.00
Turner, Blake,12136131.740.000.000.00131.74
Li, Thomas,181162376.960.000.000.002376.96
Jones, Dalton, T,189512334.970.000.000.002334.97
Edwards, Angel, J,2912469.990.000.000.0069.99
Wilson, Christian,27085782.990.000.00782.990.00
Lal, Jonathan,2009671.460.000.000.0071.46
Carter, Savannah, M,120902350.960.000.000.002350.96
Wilson, Fernando,16643126.960.000.000.00126.96
Patterson, Maria, G,1333094.950.000.000.0094.95
Green, Chloe, J,1465892.820.000.000.0092.82
Thompson, Xavier, R,15761192.410.000.000.00192.41
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Jones, Zachary, J,27285782.990.000.00782.990.00
Ross, Seth, M,184332329.980.000.000.002329.98
Perez, Charles,266937.280.000.007.280.00
Thompson, Joshua, F,259992181.560.000.002181.560.00
Johnson, Christopher,119794813.760.000.002352.212461.55
Srini, Ruben,18078200.940.000.000.00200.94
Gonzalez, James, M,188421155.480.000.000.001155.48
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Zeng, Jake,18054106.930.000.000.00106.93
Johnson, Ian, E,2173283.470.000.000.0083.47
Anderson, Emma, A,185801170.480.000.000.001170.48
Price, Mariah, C,2074549.480.000.000.0049.48
Walker, Jacob, N,29027574.980.000.000.00574.98
Murphy, Dalton, N,27043782.990.00782.990.000.00
Adams, Gabriel, S,195271219.450.000.000.001219.45
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Garcia, Victoria, V,245013578.270.003578.270.000.00
Green, Gabriella, C,2803569.990.000.000.0069.99
Evans, Gabriel,2348789.970.000.000.0089.97
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Perez, Katherine, J,2207924.270.000.000.0024.27
Wood, Alexandria, M,248242181.560.002181.560.000.00
Miller, Andrew, C,271104.990.000.000.004.99
Rivera, Allison, M,13751224.910.000.000.00224.91

Generated 2024-11-10 07:39:14.453 UTC