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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Perry, Ryan,132494795.340.000.000.004795.34
Griffin, Cassidy,264961000.440.000.001000.440.00
Davis, Thomas,167641760.470.000.000.001760.47
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Parker, Kaylee, M,2773878.980.000.000.0078.98
Watson, Devin, A,18875114.950.000.000.00114.95
Walker, Brandon, J,159164793.270.000.000.004793.27
White, Abigail, T,15866145.820.000.0038.88106.94
Hughes, Luis,130841798.960.000.000.001798.96
Nelson, Kevin,1476584.970.000.000.0084.97
Morgan, Timothy,14633242.500.000.0071.58170.92
Hill, Haley, J,161033142.320.000.00792.342349.98
Collins, Luis, J,227655978.610.003578.270.002400.34
She, Alisha, G,247574343.590.003578.270.00765.32
Sanders, Megan, A,15376136.240.000.000.00136.24
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Ortega, Sheila, M,2763239.980.000.000.0039.98
Nelson, James, L,245257.280.000.007.280.00
Powell, Spencer,14904468.120.000.000.00468.12
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Lee, Don,188392384.970.000.000.002384.97
Diaz, Trevor, B,2051954.960.000.000.0054.96
Fernandez, Darren,2899278.980.000.000.0078.98
Flores, Hannah,1952540.230.000.000.0040.23
Diaz, Hunter, S,27242782.990.000.00782.990.00
Watson, Janet, S,2320859.980.000.000.0059.98
Lopez, Carlos,186171147.770.000.000.001147.77
Watson, Emma,17481126.940.000.000.00126.94
Ross, Natalie, J,12916261.220.000.000.00261.22
Scott, Adam,15863243.010.000.000.00243.01
Martinez, Joseph, E,2921459.980.000.0059.980.00
Carter, Jason,11724210.090.000.00113.8696.23
Campbell, Natalie, L,115122319.990.000.000.002319.99
Moore, Logan,2634889.970.000.0089.970.00
Sanders, Alexandra,259112181.560.000.002181.560.00
Zhang, Heather,166543056.320.000.00751.342304.98
Thomas, Megan,2907169.990.000.000.0069.99
Ward, Jade, D,14661195.020.000.000.00195.02
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Stewart, Alex, M,2008463.150.000.000.0063.15
Adams, Carlos,1982236.960.000.000.0036.96
Blanco, Armando, F,139182397.950.000.000.002397.95
Butler, Morgan, E,2050068.490.000.000.0068.49
Stewart, Cindy,14496804.480.000.000.00804.48
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Rogers, Amanda, A,13920266.970.000.000.00266.97
Mitchell, Caleb, K,268064.990.000.000.004.99
Green, Xavier,2356739.980.000.000.0039.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Price, Devin, M,18758158.510.000.0073.5584.96
Rodriguez, Destiny, J,227397.280.000.007.280.00
Washington, Miranda,152014793.020.000.000.004793.02
Baker, Eduardo,180921789.450.000.000.001789.45
Ortega, Javier, P,127852294.990.000.000.002294.99
Williams, Morgan, C,203733226.900.002071.420.001155.48
Phillips, Miguel,2049812.940.000.000.0012.94
Lal, Jack, R,185251735.980.000.000.001735.98
Bell, Chase,180911750.980.000.000.001750.98
Murphy, Chase, J,2472958.980.000.000.0058.98
Washington, Aaron, L,246494.990.000.000.004.99
Foster, Isabelle,2637739.980.000.000.0039.98
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Nath, Carl, H,29001624.970.000.000.00624.97
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Gomez, Renee, L,253712181.560.002181.560.000.00
Henderson, Luke,19200109.240.000.000.00109.24
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Robinson, Dylan, L,1472481.530.000.000.0081.53
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Thomas, Victoria, A,15536249.530.000.000.00249.53
Collins, Eduardo,139872329.990.000.000.002329.99
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Price, Rachel, D,2532889.970.000.000.0089.97
Wilson, Tyler, L,15879196.930.000.000.00196.93
Taylor, Tyler, A,12032614.960.000.00614.960.00
Williams, Sydney, J,15334848.470.000.000.00848.47
Suri, Carolyn, S,12972175.710.000.000.00175.71
Anderson, Ryan, W,132712319.990.000.000.002319.99
Rogers, Sara,198744544.450.003374.990.001169.46
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Alexander, Jason,2932849.990.000.000.0049.99
Murphy, Juan, T,246463578.270.003578.270.000.00
Lal, Robert, L,14084138.680.000.000.00138.68
Walker, Ian,16771104.550.000.0054.5849.97
Chow, Candice,1923260.960.000.000.0060.96
Moreno, Lance, A,2922939.980.000.000.0039.98
Sanchez, Grace,120802354.990.000.000.002354.99
Smith, Zachary, W,2378358.980.000.0058.980.00
Townsend, Bryan,14077180.730.000.000.00180.73
Sanz, Lori, L,238654891.610.003578.270.001313.34
Hayes, Hannah, J,2165656.970.000.000.0056.97
Butler, Ana,260403018.330.000.002443.35574.98
Martin, Katherine, J,2027339.980.000.000.0039.98
Turner, Samuel,2742069.990.000.0069.990.00
Green, Gabrielle, M,2181564.470.000.000.0064.47
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Collins, Lucas, T,219214142.753578.270.000.00564.48
Morgan, Isaiah,18978118.730.000.000.00118.73
Taylor, Taylor,159054899.020.000.000.004899.02
Long, Natalie,14363192.340.000.000.00192.34
Bradley, Alexandria,176911779.470.000.000.001779.47
Peterson, Morgan, J,168341750.980.000.000.001750.98
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Hill, Eric, G,2525667.930.000.0067.930.00
Smith, Megan, J,2671668.970.000.000.0068.97
Lewis, Isabella,2624267.930.000.000.0067.93
Parker, Amanda,1808151.970.000.000.0051.97
Jackson, Edward,290422420.340.000.002420.340.00
Peterson, Isabella,2808039.980.000.0039.980.00
Perry, Eric,18314115.730.000.0056.9758.76
Hughes, Luke, I,270141274.080.00699.100.00574.98
Powell, Angela, R,12970471.110.000.000.00471.11
James, Christina,17409219.920.000.000.00219.92
Turner, Amanda, L,203183241.900.002071.420.001170.48
Robinson, Madison, W,183772394.970.000.000.002394.97
Evans, Alexandra,2432268.490.000.000.0068.49
Lee, John,19801193.010.000.000.00193.01
Thompson, Isabella,18756128.410.000.000.00128.41
Sanders, Zoe, L,248254.990.000.000.004.99
Reed, Michelle,2804669.990.000.000.0069.99
Roberts, Amanda,171752334.980.000.000.002334.98
Reed, Melanie, A,28160574.980.000.000.00574.98
Rodriguez, Richard,12969180.790.000.000.00180.79
Stewart, Destiny,13144281.470.000.00134.98146.49
Perry, Melissa,221284142.230.003578.270.00563.96
Morris, Paige, W,220414167.233578.270.000.00588.96
Carter, Bailey,213322616.860.000.002616.860.00
Jackson, Andrew,2047985.480.000.000.0085.48
Sanchez, Alex, K,131014736.030.000.000.004736.03
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Howard, Alyssa, A,11513863.950.000.000.00863.95
Li, Connor,201863191.910.002071.420.001120.49
Perez, Charles,266937.280.000.007.280.00
Price, Riley, R,139094764.020.000.000.004764.02
Washington, Kayla, E,14655174.960.000.0069.97104.99
Bailey, Hailey, R,262704.990.000.000.004.99
Foster, Paige,2742894.480.000.000.0094.48
Alexander, Julian,132172351.960.000.000.002351.96
Ross, Aaron, N,118882376.960.000.002376.960.00
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Morgan, Isabella, L,28602144.470.000.000.00144.47
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Ye, Alisha, J,220084141.233578.270.000.00562.96
Russell, Elijah, M,118354772.300.000.002319.262453.04
Ross, David, M,171431763.970.000.000.001763.97
Dominguez, Erika, C,21251191.270.000.000.00191.27
Martin, Brianna, M,235834829.390.003578.270.001251.12
Flores, Luke, L,247337.280.000.000.007.28
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Robinson, Ian, D,138522294.990.000.000.002294.99
Turner, Blake,12136131.740.000.000.00131.74
Evans, Jordan,2920939.980.000.0039.980.00
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Wright, Katelyn, A,14502122.260.000.0014.98107.28
Li, Brandon,2933973.960.000.000.0073.96
Wang, Austin, A,1463284.970.000.009.9974.98
Sanders, Isaiah,2587339.980.000.000.0039.98
Clark, Anthony,27071782.990.00782.990.000.00
Jones, Michael, A,2210771.970.000.000.0071.97
Rogers, Andrea, L,14328308.660.000.00112.95195.71
Gomez, Briana, A,2878443.980.000.000.0043.98
Prasad, Donald,15413318.920.000.00123.98194.94
Stewart, Sara,17347119.720.000.000.00119.72
Diaz, Alyssa,139084715.330.000.000.004715.33
Walker, Jasmine,134604693.040.000.000.004693.04
Barnes, Elizabeth, J,249397.280.000.000.007.28
Bell, Gabrielle,223735976.320.003578.270.002398.05
Reed, Bryan,18884133.930.000.000.00133.93
Nelson, Jose,19217185.020.000.0091.9593.07
Richardson, Lauren, C,14867839.480.000.000.00839.48
Jones, Madison,246614181.760.003578.27603.490.00
Howard, Brianna, D,246304.990.000.000.004.99
Patterson, Austin, O,270247.280.000.000.007.28
Harris, Edward,27062782.990.00782.990.000.00
Jones, Dalton, T,189512334.970.000.000.002334.97
Allen, Mason,176252431.950.000.000.002431.95
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Ross, Rachel, C,206693169.590.000.002049.101120.49
Thomas, David,168363193.790.000.000.003193.79
Hayes, Carson, A,124472331.950.000.000.002331.95
Martin, Noah, A,1765775.970.000.0075.970.00
Kelly, Julia,2379867.930.000.0067.930.00
Robinson, Joseph,2814194.480.000.0094.480.00
Ward, Emma, W,2179659.980.000.000.0059.98
Johnson, Andrew, F,262942443.350.000.002443.350.00
Young, Jenna, W,163652490.180.000.000.002490.18
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Gonzalez, Molly,1637021.980.000.000.0021.98
Edwards, Angel, J,2912469.990.000.000.0069.99
Brooks, Steven, C,14877889.470.000.000.00889.47
Harris, Seth, M,161402528.330.000.002528.330.00
Robinson, Julia,28121119.980.000.000.00119.98
Campbell, Gabriella,188411145.480.000.000.001145.48
Powell, Miranda, J,153044843.000.000.000.004843.00
Luo, Donna, E,248054.990.000.000.004.99
Edwards, Eric,2462768.490.000.000.0068.49
Hughes, Brittany,14387898.460.000.000.00898.46
Jai, Jose,12944164.210.000.0039.99124.22
Hughes, Edward,200234530.470.003374.990.001155.48
Hernandez, Sierra,27393123.980.000.00123.980.00
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Griffin, Julian, M,113284718.040.000.002319.992398.05
Thomas, Thomas,216292624.080.000.002049.10574.98
Russell, Jacqueline,18391100.960.000.0078.9821.98
Scott, Haley,13701154.540.000.000.00154.54
Xu, Louis,2010466.530.000.0066.530.00
Campbell, Timothy,2584513.980.000.000.0013.98
Powell, Ian,2608564.470.000.000.0064.47
Sanchez, Jared, J,2585064.470.000.000.0064.47
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Turner, Mary,220154.990.000.000.004.99
Coleman, Ian,2127639.980.000.000.0039.98
Bailey, Richard, N,220504160.533578.270.000.00582.26
Foster, Jose, C,2878534.990.000.000.0034.99
Alexander, Luke,290432447.050.000.002447.050.00
Garcia, Anna, B,15572104.550.000.000.00104.55
Washington, Hannah, A,291307.280.000.007.280.00
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Wilson, Fernando,16643126.960.000.000.00126.96
Smith, Hannah, J,2526554.980.000.0054.980.00
Cook, Megan, J,2029956.970.000.000.0056.97
Harris, Jacob, G,2367939.980.000.0039.980.00
Moore, Hunter,14897196.270.000.0071.58124.69
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Taylor, Zachary, M,27082782.990.000.00782.990.00
Walker, Hunter,271007.280.000.000.007.28
Howard, Alexandra,207363194.580.000.002049.101145.48
Bell, Danielle,140414765.020.000.000.004765.02
Gill, Beth,199975814.980.003374.990.002439.99
Perry, Oscar,227856029.570.003578.272451.300.00
Yang, Justin, S,153634719.040.000.000.004719.04
Collins, Nathan, F,197041143.460.000.000.001143.46
Baker, Mason, A,132702394.950.000.000.002394.95
Walker, Emma, M,2520998.960.000.000.0098.96
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Jai, Luis, A,18320185.920.000.000.00185.92
Long, Morgan, H,213522625.390.000.002071.42553.97
Gonzalez, Morgan,130651700.990.000.000.001700.99
Stewart, Marcus, R,2063221.980.000.000.0021.98
Coleman, Isabel, S,12530337.900.000.00123.98213.92
James, Bryce,13466133.450.000.000.00133.45
Russell, Rachel, C,2158124.270.000.0024.270.00
Collins, Sierra,185491169.460.000.001169.460.00
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Washington, Emma,191231170.480.000.000.001170.48
Butler, Cassidy, L,21792114.460.000.000.00114.46
Thomas, Logan, A,14091251.200.000.0053.99197.21

Generated 2025-11-01 08:53:28.798 UTC