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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Thompson, Madison, L,187882351.960.000.000.002351.96
Hughes, Samantha,2721564.470.000.000.0064.47
Chen, David,2720839.980.000.000.0039.98
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Wilson, Tyler, L,15879196.930.000.000.00196.93
Kumar, Elijah,15197156.920.000.000.00156.92
Griffin, Marcus,2075634.560.000.000.0034.56
Morris, Richard,2007039.980.000.000.0039.98
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Ross, Kaitlyn,16121614.470.000.000.00614.47
Powell, Jack, J,1841156.960.000.000.0056.96
Anderson, Ashley,206803219.580.000.002049.101170.48
Blue, Melanie, L,178611749.960.000.000.001749.96
Sharma, Samuel,27725119.980.000.000.00119.98
Rivera, Allison, M,13751224.910.000.000.00224.91
Reed, Isaac, D,260747.280.000.000.007.28
Sanders, Xavier,1672173.750.000.000.0073.75
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Watson, Richard,15943365.410.000.00154.98210.43
Rogers, Faith,2468259.980.000.000.0059.98
Turner, Jose,11784272.690.000.000.00272.69
Anderson, Jasmine, A,235534.990.000.000.004.99
Williams, Ian, M,175581750.470.000.000.001750.47
Flores, Emma, P,15543180.940.000.000.00180.94
Simmons, Dakota, T,14110819.460.000.000.00819.46
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Perez, Amber, D,13318214.260.000.00116.9197.35
Jenkins, Austin, D,15748296.910.000.000.00296.91
Brooks, Lucas, S,16089342.030.000.000.00342.03
Watson, Olivia, S,1386093.850.000.0014.9878.87
Powell, Katherine, C,14574177.600.000.000.00177.60
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Ross, Xavier, A,12202171.470.000.0049.97121.50
Hayes, Dalton, C,188822322.280.000.000.002322.28
Stewart, Julia, L,129022329.980.000.000.002329.98
Nath, Yolanda, A,2462513.980.000.000.0013.98
Reed, Melanie, A,28160574.980.000.000.00574.98
Robinson, Abigail, R,183792362.270.000.000.002362.27
Foster, Emma,15468436.350.000.00159.99276.36
Jones, Dalton, T,189512334.970.000.000.002334.97
Hughes, Justin, M,181222439.990.000.000.002439.99
Edwards, Angel, J,2912469.990.000.000.0069.99
Johnson, Jacob, I,28069553.970.000.000.00553.97
Perez, Jordan, A,292674.990.000.000.004.99
Clark, Emily, R,120862294.990.000.000.002294.99
Nelson, Jose,19217185.020.000.0091.9593.07
Sharma, Thomas, A,18637121.940.000.000.00121.94
Sun, Arturo, C,11498557.540.000.0072.92484.62
Turner, Kaylee, M,16213154.540.000.000.00154.54
Thomas, Emily,2180339.980.000.000.0039.98
Moreno, Marie,2773969.990.000.000.0069.99
Evans, Connor, J,15402131.550.000.000.00131.55
Washington, Elijah, L,250164.990.000.000.004.99
Bell, Christina,2609939.980.000.000.0039.98
Howard, Natalie,1349154.960.000.0014.9839.98
Martin, Jill, C,11824181.030.000.0069.97111.06
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Rodriguez, Richard,12969180.790.000.000.00180.79
Powell, Lauren, E,1966275.970.000.000.0075.97
Robinson, Madison, W,183772394.970.000.000.002394.97
Walker, Isabella,243864143.740.003578.27565.470.00
Torres, Taylor,16666205.440.000.00123.9881.46
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Garcia, Victoria, V,245013578.270.003578.270.000.00
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Perez, Barry, M,2728269.990.000.000.0069.99
Baker, Sean, T,247782858.490.002181.56676.930.00
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Rogers, Paige, H,17125539.990.000.000.00539.99
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Washington, Miranda,152014793.020.000.000.004793.02
Yuan, Brendan, S,247444.990.000.000.004.99
Griffin, Madison, A,250932181.560.002181.560.000.00
Sanchez, Allison,1666741.720.000.000.0041.72
Hall, Kaylee, E,1975137.270.000.000.0037.27
Gray, Brianna,249603008.820.002443.35565.470.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Torres, Dalton,235037.280.000.007.280.00
Flores, Jordyn,252882721.550.002181.560.00539.99
Harris, Anthony,2144721.980.000.000.0021.98
Brown, Julia,18065155.470.000.000.00155.47
Sanders, Sean,14341175.150.000.000.00175.15
Jackson, Andrew,2047985.480.000.000.0085.48
Bailey, Lauren,15864103.550.000.000.00103.55
Rogers, Olivia,12020804.470.000.000.00804.47
Flores, Julian,158464943.320.000.000.004943.32
Murphy, Chase, J,2472958.980.000.000.0058.98
Parker, Amanda,1808151.970.000.000.0051.97
Campbell, Adam, A,214002688.890.000.002071.42617.47
Richardson, Lauren, C,14867839.480.000.000.00839.48
Davis, Ethan,136604750.010.000.000.004750.01
Taylor, Taylor,159054899.020.000.000.004899.02
Allen, Sean, L,12097159.220.000.000.00159.22
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Miller, Alexis, A,12196124.930.000.000.00124.93
Collins, Hailey,11709325.890.000.0021.49304.40
Thomas, Logan, A,14091251.200.000.0053.99197.21
Johnson, Ian, E,2173283.470.000.000.0083.47
Watson, Erin, B,227724.990.000.004.990.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Smith, Nathan,217647.280.000.007.280.00
Murphy, Maria,160113657.260.000.000.003657.26
Barnes, Kayla,2425639.980.000.0039.980.00
Jenkins, Megan, R,12074261.380.000.000.00261.38
Martin, James, M,1987077.250.000.000.0077.25
Adams, Katherine, M,235184.990.000.000.004.99
Clark, Destiny, L,28600119.980.000.000.00119.98
Williams, Edward, D,14274121.560.000.000.00121.56
Wright, Jackson,11698225.950.000.000.00225.95
Torres, Abigail,253674.990.000.000.004.99
Sanchez, Grace,120802354.990.000.000.002354.99
Henderson, Luke,19200109.240.000.000.00109.24
Moreno, Meredith, D,2228589.970.000.000.0089.97
Carter, Sydney,12959203.920.000.000.00203.92
Perez, Sydney, C,221174158.243578.270.000.00579.97
Thomas, Victoria, A,15536249.530.000.000.00249.53
Williams, Ryan, R,222475978.610.003578.270.002400.34
Morgan, Isabella, L,28602144.470.000.000.00144.47
Campbell, Hunter,17422174.920.000.000.00174.92
Davis, Justin,2807412.940.000.000.0012.94
King, Morgan,196811179.970.000.000.001179.97
Suri, Carolyn, S,12972175.710.000.000.00175.71
Taylor, Ryan,170251709.980.000.000.001709.98
Davis, Thomas,167641760.470.000.000.001760.47
Wilson, Andrew, R,182362414.990.000.000.002414.99
Shan, Chad, M,2462112.940.000.000.0012.94
Townsend, Bryan,14077180.730.000.000.00180.73
Stewart, Alex, M,2008463.150.000.000.0063.15
Long, Natalie,14363192.340.000.000.00192.34
Torres, Xavier,16840176.950.000.000.00176.95
Moreno, Renee, C,12936265.220.000.000.00265.22
Moore, Matthew, W,13267109.950.000.000.00109.95
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Mitchell, Savannah,261153052.800.000.002443.35609.45
Russell, Jessica,265721000.440.000.001000.440.00
Watson, Shelby, J,14911867.970.000.000.00867.97
Thomas, William, A,216142589.090.000.002049.10539.99
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Thomas, Thomas,216292624.080.000.002049.10574.98
Powell, Miranda, J,153044843.000.000.000.004843.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Johnson, James,234984.990.000.000.004.99
Bryant, Zachary,216552648.070.000.002648.070.00
Carter, Marcus, l,2147131.970.000.000.0031.97
Washington, Riley, L,185441155.480.000.001155.480.00
Nelson, Adam, B,27402128.970.000.000.00128.97
Morgan, Brianna, D,111362380.470.000.002380.470.00
Lal, Jonathan,2009671.460.000.000.0071.46
James, Timothy,213312670.890.000.002670.890.00
Green, Gabrielle, M,2181564.470.000.000.0064.47
Chow, Candice,1923260.960.000.000.0060.96
Rogers, Sean, G,18685124.460.000.000.00124.46
Hughes, Eduardo,15564188.520.000.000.00188.52
James, Jeremiah, S,11661287.700.000.000.00287.70
Turner, James, E,16841126.960.000.0069.9956.97
Wilson, Fernando,16643126.960.000.000.00126.96
Bryant, Jackson, J,2533239.980.000.000.0039.98
Bennett, Maria, G,229837.280.000.000.007.28
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Ramos, Kristi,151764703.030.000.000.004703.03
Price, Jeremy,259892744.520.000.002181.56562.96
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Turner, Timothy, C,14641119.860.000.000.00119.86
Miller, Victoria,15816188.020.000.0081.46106.56
Peterson, Alex, M,13423132.900.000.000.00132.90
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Russell, Megan,16220562.960.000.000.00562.96
Russell, Chloe, M,12763589.960.000.000.00589.96
Walker, Emma, M,2520998.960.000.000.0098.96
Alexander, Ryan, J,14078839.480.000.00839.480.00
Chen, Jackson, S,270751371.950.00782.990.00588.96
Allen, Jack, M,291372419.060.000.002419.060.00
Perry, Melissa,221284142.230.003578.270.00563.96
Gonzales, Luis,15856116.250.000.0037.2778.98
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Stewart, Cindy,14496804.480.000.000.00804.48
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Johnson, Edward, H,23279124.990.000.000.00124.99
Ward, Jade, D,14661195.020.000.000.00195.02
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Murphy, Richard, M,222994145.540.003578.270.00567.27
Thames, Bernard,2380368.490.000.000.0068.49
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Young, Adam,12984200.200.000.00107.2692.94
White, Tyler,14291258.440.000.0049.97208.47
Coleman, Jose, S,253494.990.000.000.004.99
Hayes, Oscar,2652729.260.000.000.0029.26
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Smith, Tyler, J,2034156.970.000.000.0056.97
Rogers, Shelby,11712127.800.000.0042.5985.21
Diaz, Luke,12054402.530.000.00139.97262.56
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Bryant, Nathan,2145059.980.000.000.0059.98
Chen, James, D,11641303.200.000.0021.49281.71
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Kumar, Zachary,254334.990.000.000.004.99
Russell, Melanie, B,15478182.830.000.00167.8514.98
Gill, Beth,199975814.980.003374.990.002439.99
Campbell, Hailey,15507267.840.000.00228.9638.88
Flores, Caleb, S,12165280.640.000.00243.3737.27
Turner, Morgan,11823178.470.000.000.00178.47
Gutierrez, Jerome,127832420.460.000.000.002420.46
Thompson, Tyler,2750269.990.000.0069.990.00
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Phillips, Miguel,2049812.940.000.000.0012.94
Thomas, Jessica,1684894.480.000.0094.480.00
Morgan, Angela,24665109.970.000.000.00109.97
King, Caleb, J,2898678.980.000.000.0078.98
Nelson, Jordan, H,201304.990.000.004.990.00
Brooks, Makayla,222526047.320.003578.270.002469.05
Suarez, Juan, R,167631700.990.000.000.001700.99
Coleman, Luke, A,11723152.550.000.0069.9882.57
Watson, Emma,17481126.940.000.000.00126.94
Powell, Jordyn, K,153914828.010.000.000.004828.01
Alexander, Thomas,207607.280.000.000.007.28
Watson, Janet, S,2320859.980.000.000.0059.98
Clark, William,2902169.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Smith, Justin, P,1982721.980.000.000.0021.98
Murphy, Emma,198445807.930.003374.990.002432.94
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Parker, Madeline, H,221826006.320.003578.270.002428.05
Rogers, Sara,198744544.450.003374.990.001169.46
Moore, Taylor, A,199874564.450.003374.990.001189.46
Patterson, Natalie,16123629.970.000.000.00629.97
Blue, Makayla,1900029.990.000.000.0029.99
Morgan, Juan, C,1882191.970.000.000.0091.97
Zhang, Nathan, L,2910478.980.000.000.0078.98
Jai, Logan, H,12031769.490.000.000.00769.49
Hill, Carlos,12919257.880.000.00158.9398.95
Coleman, Logan,1868691.950.000.000.0091.95
Garcia, Isabella,18382204.940.000.000.00204.94
Martin, Nicholas,233627.280.000.000.007.28
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Zhang, Heather,166543056.320.000.00751.342304.98
Hall, Fernando,2210090.950.000.000.0090.95
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Serrano, Albert, E,133284708.020.000.000.004708.02
Kelly, Haley,15511128.560.000.000.00128.56
Stewart, Olivia, B,1874923.780.000.000.0023.78
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Lee, Don,188392384.970.000.000.002384.97
Evans, Gabriel,2348789.970.000.000.0089.97
Edwards, Mackenzie, K,2345841.950.000.000.0041.95

Generated 2025-11-03 21:11:59.843 UTC