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

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hall, Jose, J,17601225.420.000.00155.4569.97
Allen, Luke,113162349.980.000.002349.980.00
Johnson, Madison, L,15530846.460.000.000.00846.46
Jai, Samuel, L,1635887.950.000.0039.9947.96
Foster, Kayla,1969371.950.000.000.0071.95
Smith, Justin, P,1982721.980.000.000.0021.98
Ramos, Kristi,151764703.030.000.000.004703.03
Clark, Anthony,27071782.990.00782.990.000.00
Lee, Samantha, B,2737878.980.000.000.0078.98
Garcia, Henry, B,112871009.240.000.00219.26789.98
Thompson, Brianna, X,1864269.970.000.000.0069.97
Flores, Julian,158464943.320.000.000.004943.32
Howard, Alexandra,207363194.580.000.002049.101145.48
Lee, Alexander, S,18356149.910.000.000.00149.91
Sun, Arturo, C,11498557.540.000.0012.94544.60
Zhang, Heather,166543056.320.000.00751.342304.98
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Bradley, Nathaniel,169551760.470.000.000.001760.47
Miller, Sydney, A,134404818.530.000.000.004818.53
Adams, Jennifer,153624745.020.000.000.004745.02
Jackson, Brianna,1537797.910.000.0074.9822.93
Morris, Mason, J,22349124.990.000.000.00124.99
Flores, Logan, K,14631848.470.000.000.00848.47
Sanders, Lucas, W,268024.990.000.000.004.99
Smith, Chloe,17619163.920.000.000.00163.92
Garcia, Isabella,18382204.940.000.000.00204.94
Murphy, Shelby,244894.990.000.000.004.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Perez, Amber, D,13318214.260.000.00116.9197.35
She, Kenneth,16096212.010.000.0080.96131.05
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Shan, Christian, L,2308439.980.000.000.0039.98
Wilson, Nathan, L,13936218.930.000.000.00218.93
Ortega, Javier, P,127852294.990.000.000.002294.99
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Brown, Anna,1624795.820.000.000.0095.82
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Stewart, Jessica,16097103.550.000.0046.5856.97
Green, Sophia, E,249772181.560.002181.560.000.00
Watson, Marcus,2271585.480.000.000.0085.48
Stewart, Allison, R,18826166.430.000.0069.9996.44
Hall, Morgan,2172641.950.000.000.0041.95
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Collins, Hailey,11709325.890.000.0021.49304.40
Baker, Ian, V,262002756.540.000.002181.56574.98
Li, Jordan,17026261.390.000.00261.390.00
Brooks, Lucas, S,16089342.030.000.000.00342.03
Cooper, Christina, C,265121000.440.000.001000.440.00
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Smith, Zachary, W,2378358.980.000.0058.980.00
Hill, Blake,11748131.540.000.000.00131.54
Flores, Eduardo, S,2896962.980.000.000.0062.98
Flores, Julia, E,172631700.990.000.000.001700.99
Miller, Katherine, B,27102782.990.000.00782.990.00
Nath, Carl, H,29001624.970.000.000.00624.97
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Jones, Alexandra, B,2020245.950.000.000.0045.95
Chen, James, D,11641303.200.000.0021.49281.71
Hayes, Oscar,2652729.260.000.000.0029.26
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Ward, Juan, H,215952649.560.000.002049.10600.46
Lal, Luke, L,11019698.230.000.00139.93558.30
Powell, Katherine, C,14574177.600.000.000.00177.60
Foster, Eric,229765971.330.003578.270.002393.06
Robinson, Dylan, L,1472481.530.000.000.0081.53
Stewart, Sara,17347119.720.000.000.00119.72
Smith, Katherine, J,13197105.190.000.000.00105.19
James, Julia,2497567.930.000.000.0067.93
Thomas, Charles,250942443.350.002443.350.000.00
Hall, Eduardo,16847189.940.000.000.00189.94
Butler, Cassidy, L,21792114.460.000.000.00114.46
Blanco, Randall,263211554.410.000.001000.44553.97
Rogers, Sean, G,18685124.460.000.000.00124.46
Taylor, Taylor,159054899.020.000.000.004899.02
Jackson, Hannah, G,131432404.970.000.000.002404.97
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Thompson, Jose,237314828.110.003578.270.001249.84
Ramirez, Emma,29072128.970.000.000.00128.97
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Lee, Don,188392384.970.000.000.002384.97
Reed, Erin, I,14353128.840.000.0074.9853.86
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Adams, Katherine, M,235184.990.000.000.004.99
Griffin, Jason, L,112001267.110.000.00391.08876.03
Rivera, Hailey, R,2079239.980.000.000.0039.98
Turner, Kaylee, M,16213154.540.000.000.00154.54
Ortega, Sheila, M,2763239.980.000.000.0039.98
Evans, Alexandra,2432268.490.000.000.0068.49
Alexander, Elijah,11738331.680.000.00141.73189.95
Morgan, Isaiah,18978118.730.000.000.00118.73
Cook, Seth,2301064.470.000.000.0064.47
Lobao, Alexandre,1892691.950.000.0091.950.00
Long, Gavin,13762186.030.000.000.00186.03
Long, Julia, R,228895971.330.003578.270.002393.06
Henderson, Abigail,2044139.980.000.000.0039.98
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Kumar, Elijah,15197156.920.000.000.00156.92
Gonzales, Jose,2201439.980.000.000.0039.98
Washington, Alexia,27613782.990.000.00782.990.00
Davis, Ethan,136604750.010.000.000.004750.01
Prasad, Molly,243924329.610.003578.270.00751.34
Diaz, Richard, A,2668264.470.000.000.0064.47
Murphy, Brianna, K,2834269.990.000.000.0069.99
Lee, Ethan, J,223597.280.000.000.007.28
Wu, Randy, J,116472365.940.000.002365.940.00
Hall, Fernando,2210090.950.000.000.0090.95
Thompson, Lucas, O,212774.990.000.000.004.99
Rivera, Amanda,11131115.920.000.000.00115.92
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Bailey, Mariah, L,2724354.980.000.000.0054.98
King, Morgan,196811179.970.000.000.001179.97
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Justin, P,235917.280.000.000.007.28
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Coleman, Joan, W,2669964.470.000.000.0064.47
Peterson, Christina,2897694.480.000.000.0094.48
Bryant, Jackson, J,2533239.980.000.000.0039.98
Foster, Trevor, J,2896469.990.000.000.0069.99
Washington, Hannah, A,291307.280.000.007.280.00
Diaz, Jason,17374206.630.000.0089.46117.17
Diaz, Hailey, W,116932294.990.000.002294.990.00
Long, Brandon, M,16110650.470.000.000.00650.47
Clark, Joseph, D,153954780.020.000.000.004780.02
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Hayes, Luis,12880200.730.000.000.00200.73
Martin, Joshua, A,276077.280.000.007.280.00
Stewart, Andrea, M,27252782.990.000.00782.990.00
Ward, Eduardo, I,139162354.980.000.000.002354.98
Peterson, Xavier, R,2645639.980.000.000.0039.98
Sanders, Alexandra,259112181.560.000.002181.560.00
Walker, Charles,11677298.210.000.000.00298.21
White, Emma, N,16090604.960.000.000.00604.96
Price, Caroline,180511735.980.000.000.001735.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
She, Alisha, G,247574343.590.003578.270.00765.32
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Wilson, Grace,17539205.920.000.000.00205.92
Rogers, Carlos,19645134.440.000.000.00134.44
Perry, Ana,112151155.520.000.00292.94862.58
Long, Jordan,199884555.470.003399.990.001155.48
Yuan, Carly,19839194.960.000.000.00194.96
Russell, Caleb,23552103.480.000.000.00103.48
Li, Eugene, A,15283865.950.000.000.00865.95
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Jai, Luis, A,18320185.920.000.000.00185.92
Ward, Jade, D,14661195.020.000.000.00195.02
Ramirez, Sydney,267007.280.000.000.007.28
Bryant, Dakota, L,176132401.950.000.000.002401.95
Walker, Jasmine,134604693.040.000.000.004693.04
Rivera, Makayla, A,2878334.990.000.000.0034.99
Perez, Angel, S,213362628.350.000.002071.42556.93
Perry, Benjamin,291652407.040.000.002407.040.00
Walker, Ian,16771104.550.000.0054.5849.97
Washington, Victoria,235577.280.000.000.007.28
Winston, Ethan, R,216222612.060.000.002049.10562.96
Simmons, Jose,2464739.980.000.000.0039.98
Morris, Jessica,289678.990.000.008.990.00
Barnes, Dalton, C,178581700.990.000.000.001700.99
Jones, Kayla, C,1854194.260.000.000.0094.26
Yang, Aaron, C,2519654.980.000.000.0054.98
Henderson, Olivia,188591155.480.000.000.001155.48
Bell, Garrett, J,14265161.230.000.000.00161.23
Thomas, Ian,191181120.490.000.000.001120.49
Allen, Mason,176252431.950.000.000.002431.95
Jones, Dalton, T,189512334.970.000.000.002334.97
Patterson, Alexis,213484392.020.000.002049.102342.92
Gonzales, Miranda,11660324.720.000.000.00324.72
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Gonzales, Emily, P,21777180.980.000.000.00180.98
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Bailey, Olivia,238924.990.000.000.004.99
Thomas, Emily,2180339.980.000.000.0039.98
Isla, Julian, A,13732108.960.000.004.99103.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Washington, Thomas, C,2745137.430.000.000.0037.43
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Scott, Gabrielle,270614.990.000.000.004.99
Griffin, Marcus,2075634.560.000.000.0034.56
Washington, Christian, R,2668639.980.000.000.0039.98
Bell, Gabrielle,223735976.320.003578.270.002398.05
Brooks, Bryce,12061140.170.000.00112.2527.92
Rogers, Sara,198744544.450.003374.990.001169.46
Gray, Sebastian, B,138782366.960.000.000.002366.96
Lopez, Carlos,186171147.770.000.000.001147.77
Nelson, Katherine,2802178.980.000.000.0078.98
Torres, Taylor,16666205.440.000.00123.9881.46
Thompson, Kayla, D,12363273.900.000.000.00273.90
King, Aaron, L,117394758.030.000.002359.982398.05
Collins, Xavier, C,16646250.910.000.000.00250.91
Chandra, Brandy, P,11501603.530.000.000.00603.53
Martinez, Joseph, E,2921459.980.000.0059.980.00
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Jones, Alexander, I,2002180.960.000.000.0080.96
Hernandez, Marcus,185952329.990.000.000.002329.99
Price, Marissa,15826160.740.000.00120.4840.26
Jai, Jose,12944164.210.000.000.00164.21
Green, Xavier,2356739.980.000.000.0039.98
Hall, Kaylee, E,1975137.270.000.000.0037.27
Washington, Lauren, R,229985329.250.003578.271750.980.00
Garcia, Lucas,27545782.990.000.00782.990.00
Bryant, Gabriel,2765669.990.000.000.0069.99
Rodriguez, Richard,12969180.790.000.000.00180.79
Green, Blake, P,11719287.200.000.000.00287.20
Davis, Jonathan,2925913.980.000.000.0013.98
Rubio, Kellie,27653128.970.000.000.00128.97
Reed, Megan, A,181181750.980.000.000.001750.98
Butler, Jackson, J,183241735.980.000.000.001735.98
Edwards, Madeline,2077146.470.000.000.0046.47
Richardson, Erin, R,1633188.850.000.0038.8849.97
James, Bryce,13466133.450.000.000.00133.45
Gonzales, Paige,2170291.940.000.0039.9851.96
Campbell, Evan, W,243424828.110.003578.270.001249.84
Bailey, Richard, N,220504160.533578.270.000.00582.26
Long, Xavier,112512318.960.000.000.002318.96
Murphy, Richard, M,222994145.540.003578.270.00567.27
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Adams, Connor,214232888.560.000.002049.10839.46
Anderson, Megan, A,238594153.250.003578.27574.980.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Alexander, Gavin, K,2932249.990.000.000.0049.99
Perry, Ryan,132494795.340.000.000.004795.34
Moore, Matthew, W,13267109.950.000.000.00109.95
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Wood, Brittany,2877753.990.000.000.0053.99
Blanco, Armando, F,139182397.950.000.000.002397.95
Thompson, Tyler,2750269.990.000.0069.990.00
Johnson, Edward, H,23279124.990.000.000.00124.99
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Tang, Carl,2123832.270.000.000.0032.27
Stewart, Gabriella,2803469.990.000.000.0069.99
Clark, Lauren,170341750.980.000.000.001750.98
Smith, Samuel, D,2308349.900.000.000.0049.90
Zhang, Robert,188551155.480.000.000.001155.48
Hall, Charles,234764.990.000.000.004.99
Wilson, Eduardo,15323804.470.000.000.00804.47
Parker, Caleb, A,2631813.980.000.000.0013.98
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Collins, Jonathan,16849119.980.000.000.00119.98
Yang, Jordan, K,14458133.950.000.000.00133.95
Deng, Damien, A,16873578.460.000.000.00578.46
Powell, Jordyn, K,153914828.010.000.000.004828.01
Reed, Kaylee, R,17371151.920.000.000.00151.92
Simmons, David, E,120172339.970.000.002339.970.00
Taylor, Marcus, A,18944146.940.000.000.00146.94
James, Zoe, R,14611304.550.000.000.00304.55
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Flores, Luke, L,247337.280.000.000.007.28
Bailey, Lauren,15864103.550.000.000.00103.55
Foster, Samuel, M,18523160.940.000.00128.9731.97
Reed, Sean, L,145974803.310.000.000.004803.31
Long, Kaitlyn,233964891.610.003578.270.001313.34
Cooper, Ariana,17348205.420.000.000.00205.42
Evans, Connor, J,15402131.550.000.000.00131.55
Flores, Caleb, S,12165280.640.000.00243.3737.27
Mitchell, Bailey, B,267067.280.000.007.280.00
Long, Sarah,173721729.970.000.000.001729.97
King, Jordan, C,110202316.970.000.002316.970.00
Harris, Jacob, G,2367939.980.000.0039.980.00
Washington, Adam, G,2543713.980.000.000.0013.98
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Sanders, Mason, G,2345939.980.000.000.0039.98
Perez, Sydney, C,221174158.243578.270.000.00579.97
Jai, Adam,250952443.350.002443.350.000.00
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Parker, James,11808610.190.000.000.00610.19
Simmons, Mariah,266831270.820.00699.100.00571.72
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Johnson, Xavier, R,2325539.980.000.0039.980.00
Flores, Brittany,169062359.980.000.000.002359.98
Gray, Mariah,222787.280.000.007.280.00
Martin, Lucas, L,221144183.233578.270.000.00604.96
Powell, Elijah, E,231135997.330.003578.270.002419.06
Lopez, Isaiah,18968151.430.000.000.00151.43
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Davis, Marcus, T,17337123.910.000.0086.9536.96
Allen, Sean, L,12097159.220.000.000.00159.22
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Chen, Jack, E,17579151.430.000.000.00151.43
Thompson, Madison, L,187882351.960.000.000.002351.96
Bell, Danielle,140414765.020.000.000.004765.02
Adams, Haley, M,247862443.350.002443.350.000.00
James, Richard, D,15760109.230.000.003.99105.24
Patterson, Taylor,12147271.450.000.000.00271.45
Perry, Melissa,221284142.230.003578.270.00563.96
Campbell, Chloe,11212760.930.000.00231.72529.21
Deng, Wayne,2145336.960.000.0036.960.00
Gutierrez, Jerome,127832420.460.000.000.002420.46
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Parker, Katherine,13268289.700.000.0068.97220.73
Walker, Emma, M,2520998.960.000.000.0098.96
Foster, Jessica,2606951.460.000.0051.460.00
Howard, Morgan, T,229713578.270.003578.270.000.00
Stewart, Marcus, R,2063221.980.000.000.0021.98
Thomas, Logan, A,14091251.200.000.0053.99197.21
Torres, Abigail,253674.990.000.000.004.99
Walker, Richard, T,19640224.550.000.000.00224.55
Butler, Morgan, E,2050068.490.000.000.0068.49
Thompson, Xavier, R,15761192.410.000.000.00192.41
Rogers, Bryce,174022304.980.000.000.002304.98
Hughes, Zachary,12203157.910.000.000.00157.91
Collins, Eduardo,139872329.990.000.000.002329.99
Edwards, Hailey,242584.990.000.000.004.99
Russell, Samuel, V,11652310.930.000.000.00310.93
Ashe, Alexis, S,194141145.480.000.000.001145.48
Roberts, Noah, S,2704268.490.000.000.0068.49
Phillips, Isaiah,28631144.470.000.00144.470.00
Bailey, Hailey, R,262704.990.000.000.004.99
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Kapoor, Preston,2143156.970.000.000.0056.97
Young, Courtney,176222374.980.000.000.002374.98
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Adams, Kyle, E,1881269.990.000.0069.990.00
Brown, Fernando,1900191.950.000.0069.9721.98
Harris, Anthony,2144721.980.000.000.0021.98
Wang, Austin, A,1463284.970.000.009.9974.98
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Lewis, Ethan,27998144.470.000.000.00144.47
Flores, Megan, N,230746021.820.003578.270.002443.55
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Powell, Angela, R,12970471.110.000.000.00471.11
Hughes, Isabella,2304851.460.000.000.0051.46
Hill, Jordan, J,16005198.730.000.00102.2796.46
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Martin, Katherine, J,2027339.980.000.000.0039.98
Hughes, Julia,250612443.350.002443.350.000.00
Zhang, Nathan, L,2910478.980.000.000.0078.98
Ramirez, Brian, M,116182369.960.000.002369.960.00
Cooper, Grace, C,1601294.260.000.000.0094.26
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Diaz, Alyssa,139084715.330.000.000.004715.33
Gutierrez, Neil, L,214897.280.000.000.007.28
Brooks, Victoria, H,16479158.510.000.000.00158.51
Xu, Louis,2010466.530.000.0066.530.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Watson, Devin, A,18875114.950.000.000.00114.95
Hall, Lauren, A,19648100.840.000.000.00100.84
Zukowski, Jake,220584118.263578.270.000.00539.99
Evans, Jordan,2920939.980.000.0039.980.00
Simmons, Nicole, S,2617729.480.000.000.0029.48
Smith, Andrew,1472387.570.000.0014.9872.59
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Smith, Tyler, J,2034156.970.000.000.0056.97
Hughes, Justin, M,181222439.990.000.000.002439.99
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Bradley, Alexandria,176911779.470.000.000.001779.47
Morgan, Brianna, D,111362380.470.000.002380.470.00
Ross, Xavier, A,12202171.470.000.0049.97121.50
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Lal, Caleb, R,1586874.460.000.000.0074.46
Garcia, Carmen, J,247812181.560.002181.560.000.00
Van, Bobby,27757132.970.000.000.00132.97
Roberts, Rebecca,2800094.480.000.000.0094.48
Clark, Zachary, J,2389358.980.000.000.0058.98
Taylor, Madison, A,11802215.290.000.00127.9687.33
Price, Jeremy,259892744.520.000.002181.56562.96
Thompson, Isabella,18756128.410.000.000.00128.41
Johnson, Christopher,119794813.760.000.002352.212461.55
Wilson, Madison, H,1982821.980.000.000.0021.98
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Brown, Julia,18065155.470.000.000.00155.47
Campbell, Natalie, L,115122319.990.000.000.002319.99
Wright, Jackson,11698225.950.000.000.00225.95
Robinson, Ian, D,138522294.990.000.000.002294.99
Young, Adam,12984200.200.000.0037.29162.91
Taylor, Natalie, M,14338828.740.000.000.00828.74
Davis, Richard, R,15549574.980.000.00574.980.00
Young, Jenna, W,163652490.180.000.000.002490.18
Peterson, Isabella,2808039.980.000.0039.980.00
Andersen, Latoya, J,290578.990.000.000.008.99
Morgan, Marcus, W,289682.290.000.000.002.29
Bradley, Rachel,158504813.040.000.000.004813.04
Evans, Elijah, S,2588439.980.000.000.0039.98
Martin, Noah, A,1765775.970.000.0075.970.00
Stewart, Olivia, B,1874923.780.000.000.0023.78
Miller, Alexis, A,12196124.930.000.000.00124.93

Generated 2025-11-06 12:19:45.796 UTC