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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Washington, Taylor,212664525.070.000.002049.102475.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
Baker, Gabriella,174041709.980.000.000.001709.98
Brooks, Lucas, S,16089342.030.000.000.00342.03
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Jai, Connor, D,27253782.990.000.00782.990.00
Scott, Adam,15863243.010.000.000.00243.01
Shan, Benjamin,235663578.270.003578.270.000.00
Bell, Danielle,140414765.020.000.000.004765.02
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Reed, Catherine, M,203807.280.000.000.007.28
Washington, Alexis,1978146.260.000.007.2838.98
Adams, Gabriel, S,195271219.450.000.000.001219.45
Alexander, Edward, E,18524195.950.000.000.00195.95
Martin, Xavier,222335997.330.003578.270.002419.06
Smith, Nathan,217647.280.000.000.007.28
Coleman, Jose, S,253494.990.000.000.004.99
Bailey, Jessica, L,12945218.440.000.000.00218.44
Hall, Lauren, A,19648100.840.000.000.00100.84
Miller, Katherine, B,27102782.990.000.00782.990.00
Lopez, Isaiah,18968151.430.000.000.00151.43
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Baker, Sean, T,247782858.490.002181.56676.930.00
Collins, Isaac,260777.280.000.000.007.28
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Alexander, Aidan,17387148.190.000.0056.9791.22
Henderson, Caroline,2008256.970.000.000.0056.97
Allen, Sean, L,12097159.220.000.000.00159.22
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Rogers, Olivia,12020804.470.000.000.00804.47
Cook, Joan,235544.990.000.000.004.99
Brooks, Paige,222325985.310.003578.270.002407.04
Torres, Dalton,235037.280.000.000.007.28
Li, Jordan,17026261.390.000.00171.9389.46
Chen, Ethan,2054756.970.000.000.0056.97
Bradley, Alexandria,176911779.470.000.000.001779.47
Ye, Alisha, J,220084141.233578.270.000.00562.96
Perez, Jordan, A,292674.990.000.000.004.99
Perez, Sydney, C,221174158.240.003578.270.00579.97
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Taylor, Brianna,17027230.900.000.0051.96178.94
Young, Savannah,259712749.320.000.002181.56567.76
Moore, Chloe, L,2626913.980.000.000.0013.98
Martin, Joshua, A,276077.280.000.000.007.28
Wilson, Grace,17539205.920.000.000.00205.92
Johnson, Jonathan,220597.280.000.000.007.28
Russell, Arianna,22728149.930.000.00149.930.00
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Cook, Bryce,2864069.990.000.000.0069.99
Stewart, Gabriella,2803469.990.000.000.0069.99
Ross, David, M,171431763.970.000.000.001763.97
Bradley, Evan,18506101.940.000.000.00101.94
Richardson, Brian,2860878.980.000.000.0078.98
Bryant, Jackson, J,2533239.980.000.000.0039.98
Miller, Eduardo,14561158.840.000.0049.97108.87
Nelson, Henry,193941155.480.000.000.001155.48
Coleman, Benjamin, F,234865343.230.003578.270.001764.96
Wright, Carol, C,12928247.410.000.0033.98213.43
Ross, Alexia, S,13231247.900.000.000.00247.90
Cox, Arianna, D,1892789.250.000.000.0089.25
Morgan, Isabella, L,28602144.470.000.000.00144.47
Cooper, Grace, C,1601294.260.000.000.0094.26
_SUM1806517.5061618.95486836.72314943.78943118.05
Coleman, Samuel, N,17450123.980.000.000.00123.98
Lal, Jack, R,185251735.980.000.000.001735.98
Rodriguez, Julia, A,264884.990.000.004.990.00
Foster, Emma,15468436.350.000.00159.99276.36
Diaz, Angela, K,27259782.990.000.00782.990.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Li, Brandon,2933973.960.000.000.0073.96
Turner, Amanda, L,203183241.900.002071.420.001170.48
Sanders, Angel,16219553.970.000.000.00553.97
Thomas, Jeremiah,183721760.470.000.000.001760.47
Moore, Jennifer, A,2175964.470.000.000.0064.47
She, Kenneth,16096212.010.000.0080.96131.05
Russell, Rachel, C,2158124.270.000.0024.270.00
Martin, Brianna, M,235834829.390.003578.270.001251.12
Jai, Kevin,1983678.960.000.0038.9839.98
Powell, Caleb, G,216132610.580.000.002049.10561.48
Rogers, Andrea, L,14328308.660.000.0049.97258.69
Thomas, Wyatt, R,12431154.540.000.000.00154.54
Brown, Samantha, G,2514739.980.000.000.0039.98
Lal, Luke, L,11019698.230.000.00139.93558.30
Thomas, Edward, E,19147133.710.000.000.00133.71
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Alexander, Julian,132172351.960.000.000.002351.96
Torres, Pedro, E,16958168.020.000.00153.0414.98
Gonzalez, Molly,1637021.980.000.000.0021.98
Hughes, Anna,197052341.970.000.000.002341.97
Bailey, Maria, C,1915034.980.000.000.0034.98
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Anderson, David, A,2209761.960.000.0061.960.00
Bailey, Lauren,15864103.550.000.000.00103.55
Kelly, Bryan,213492989.380.000.002989.380.00
Mitchell, Caleb, K,268064.990.000.000.004.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Garcia, Cameron,186411120.490.000.000.001120.49
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Griffin, Cassidy,264961000.440.000.001000.440.00
Lal, Robert, L,14084138.680.000.000.00138.68
Kumar, Cameron, S,185711120.490.000.001120.490.00
Jai, Adam,250952443.350.002443.350.000.00
Perry, James,192051249.840.000.000.001249.84
Hughes, Jasmine,276284.990.000.000.004.99
Jones, Madison,246614181.760.003578.27603.490.00
Hughes, Luis,130841798.960.000.000.001798.96
Foster, Antonio,12795108.540.000.0066.2642.28
Isla, Julian, A,13732108.960.000.004.99103.97
Mehta, Carmen, C,2743694.480.000.000.0094.48
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Perez, Angel, S,213362628.350.000.002071.42556.93
Wilson, Daniel, K,142814746.300.000.000.004746.30
Collins, Amanda,2078339.980.000.000.0039.98
Powell, Angela, R,12970471.110.000.000.00471.11
Price, Stephanie,258922443.350.002443.350.000.00
Rogers, Jade, I,14332102.250.000.000.00102.25
Hall, Kyle, J,1749169.970.000.000.0069.97
Blue, Makayla,1900029.990.000.000.0029.99
Prasad, Summer, M,2214339.980.000.0039.980.00
Anand, Brendan, L,1984721.980.000.000.0021.98
Thomas, Emily,2180339.980.000.000.0039.98
Washington, Christian, R,2668639.980.000.000.0039.98
Ward, Stephanie, A,27429782.990.000.00782.990.00
Serrano, Albert, E,133284708.020.000.000.004708.02
Foster, Aaron,155664912.470.000.000.004912.47
Evans, Luke,2917615.230.000.000.0015.23
Phillips, Devin,18759112.060.000.000.00112.06
Reed, Bryan,18884133.930.000.000.00133.93
Diaz, Alyssa,139084715.330.000.000.004715.33
Shan, Logan,1867760.960.000.0029.9930.97
Evans, Maria,22544127.280.000.00127.280.00
Long, Caleb, P,250462181.560.002181.560.000.00
Hall, Wyatt,2382713.980.000.000.0013.98
Flores, Julian,158464943.320.000.000.004943.32
Martin, Kellie, R,28195574.980.000.000.00574.98
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Torres, Taylor,16666205.440.000.00123.9881.46
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Fernandez, Cesar,200355694.980.003374.990.002319.99
Collins, Connor, J,27270782.990.000.00782.990.00
Thompson, Madison, L,187882351.960.000.000.002351.96
Lee, Alexander, S,18356149.910.000.000.00149.91
Taylor, Taylor,159054899.020.000.000.004899.02
Adams, Jennifer,153624745.020.000.000.004745.02
Adams, Kyle, E,1881269.990.000.0069.990.00
Reed, Erin, I,14353128.840.000.0074.9853.86
Hayes, Gavin, A,194001179.470.000.000.001179.47
Hayes, Logan, J,19026113.240.000.0037.2775.97
Alexander, Taylor,17482146.940.000.0076.9769.97
Moore, Logan,2634889.970.000.0089.970.00
Carter, Savannah, M,120902350.960.000.000.002350.96
Hill, Blake,11748131.540.000.000.00131.54
Washington, Elijah, L,250164.990.000.000.004.99
Russell, Oscar, A,12140118.170.000.000.00118.17
Madan, Carmen, V,155674720.270.000.000.004720.27
Hernandez, Marcus,185952329.990.000.000.002329.99
Coleman, Lucas, A,27060782.990.000.00782.990.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Harris, Edward,27062782.990.000.00782.990.00
Hughes, Antonio, P,15913712.270.000.000.00712.27
Thompson, Abigail,243324816.090.003578.270.001237.82
Simmons, Anna, K,124512367.920.000.000.002367.92
Harris, Joshua, L,2028095.940.000.0030.9764.97
Thomas, Isabella, M,27265782.990.000.00782.990.00
Perry, Samuel,18811100.960.000.0069.9930.97
Wilson, Fernando,16643126.960.000.000.00126.96
Alexander, Lauren,189502351.960.000.000.002351.96
Griffin, Jason, L,112001267.110.000.00363.80903.31
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Walker, Thomas,1307193.980.000.000.0093.98
Reed, Sean, L,145974803.310.000.000.004803.31
Campbell, Gabriella,188411145.480.000.000.001145.48
Brown, Fernando,1900191.950.000.0069.9721.98
Stewart, Allison, R,18826166.430.000.0069.9996.44
Williams, Morgan, C,203733226.900.000.002071.421155.48
Simmons, Brittany,2923139.980.000.000.0039.98
Cox, Lucas, J,253932443.350.002443.350.000.00
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Thompson, Devin,207084406.400.000.002071.422334.98
Phillips, Kyle,12158202.200.000.000.00202.20
Howard, Isaiah,259813018.330.002443.350.00574.98
Bell, Gabrielle,223735976.320.003578.270.002398.05
Davis, Nicholas,1320173.160.000.000.0073.16
Martin, Tyler, L,2772469.990.000.000.0069.99
James, Adrian, C,253404.990.000.000.004.99
Allen, Mason,176252431.950.000.000.002431.95
Thompson, Isabella,18756128.410.000.000.00128.41
Griffin, Miguel,2146476.970.000.000.0076.97
Diaz, Faith, M,2236356.970.000.000.0056.97
Green, Mackenzie, C,280737.280.000.000.007.28
Anderson, Lucas,2926639.980.000.000.0039.98
Nelson, Kevin,1476584.970.000.000.0084.97
Hughes, Edward,200234530.470.003374.990.001155.48
Johnson, Ian, E,2173283.470.000.000.0083.47
Watson, Devin, A,18875114.950.000.000.00114.95
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Price, Marissa,15826160.740.000.00120.4840.26
Murphy, Brianna, K,2834269.990.000.000.0069.99
Smith, Megan, J,2671668.970.000.000.0068.97
Jackson, Hannah, G,131432404.970.000.000.002404.97
Miller, Joseph, A,227134148.190.003578.270.00569.92
Campbell, Chloe,11212760.930.000.00231.72529.21
Peterson, Steven, L,234497.280.000.007.280.00
Baker, Mason, A,132702394.950.000.000.002394.95
Fernandez, Ruth,205463246.550.000.002049.101197.45
Flores, Brittany,169062359.980.000.000.002359.98
Clark, Zachary, J,2389358.980.000.000.0058.98
Coleman, Dylan,27403132.970.000.000.00132.97
Moreno, Marie,2773969.990.000.000.0069.99
Winston, Ethan, R,216222612.060.000.002049.10562.96
Cook, Megan, J,2029956.970.000.000.0056.97
Hall, Noah, A,1525175.250.000.000.0075.25
Harris, Emily, P,1986298.480.000.000.0098.48
Cook, Seth,2301064.470.000.000.0064.47
Wright, Kyle,2371626.970.000.000.0026.97
Howard, Morgan, T,229713578.270.003578.270.000.00
Zhang, Nathan, L,2910478.980.000.000.0078.98
Williams, Ian, M,175581750.470.000.000.001750.47
Collins, Charles, B,29041628.450.000.000.00628.45
Zeng, Jake,18054106.930.000.000.00106.93
Coleman, Ashley,27297782.990.000.00782.990.00
Perry, Brandon,22095141.980.000.000.00141.98
Wilson, Christian,27085782.990.000.00782.990.00
Walker, Richard, T,19640224.550.000.000.00224.55
Morgan, Marcus, W,289682.290.000.000.002.29
Thompson, Tyler,2750269.990.000.0069.990.00
Stewart, Julia, L,129022329.980.000.000.002329.98
Brooks, Allison,146054750.010.000.000.004750.01
Simmons, Mariah,266831270.820.00699.100.00571.72
Phillips, Miguel,2049812.940.000.000.0012.94
Ward, Devin, J,15378170.910.000.0076.9593.96
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Hall, Fernando,2210090.950.000.000.0090.95
Lewis, Zachary, L,14760167.260.000.000.00167.26
Alexander, Luke,290432447.050.000.002447.050.00
Jackson, Andrew,2047985.480.000.000.0085.48
Smith, Eduardo,2069139.980.000.000.0039.98
Garcia, Jonathan,1888386.960.000.0029.9956.97
Prasad, Molly,243924329.610.003578.270.00751.34
Turner, Andrea, A,202093268.550.002049.100.001219.45
Bryant, Kyle,231644807.100.003578.271228.830.00
Peterson, Christina,2897694.480.000.000.0094.48

Generated 2024-11-10 05:34:56.610 UTC