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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Green, Gabrielle, M,2181564.470.000.000.0064.47
Harris, Samantha, A,244874.990.000.000.004.99
Young, Kaylee, S,13756298.490.000.0058.47240.02
Morris, Chase, F,26789699.100.00699.100.000.00
Richardson, Evan, J,15488165.300.000.000.00165.30
Adams, Kyle, E,1881269.990.000.0069.990.00
Powell, Elijah, E,231135997.330.003578.270.002419.06
Richardson, Brian,2860878.980.000.000.0078.98
Lewis, Brandon, A,2903769.990.000.000.0069.99
Torres, Haley, W,232834828.110.003578.270.001249.84
Lee, Alexander, S,18356149.910.000.000.00149.91
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Powell, Jonathan,238584712.740.003578.271134.470.00
Griffin, Jack, L,1768632.280.000.000.0032.28
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Shan, Benjamin,235663578.270.003578.270.000.00
Bailey, Lauren,15864103.550.000.000.00103.55
Wilson, Daniel, K,142814746.300.000.000.004746.30
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Barnes, Jeremy,2144654.980.000.000.0054.98
Henderson, Abigail,2044139.980.000.000.0039.98
Bryant, Isabelle,233974828.110.003578.270.001249.84
Sanders, Hailey,19647282.040.000.000.00282.04
Price, Oscar, G,11833240.010.000.000.00240.01
Thompson, Jose,237314828.110.003578.270.001249.84
Reed, Isaac, D,260747.280.000.000.007.28
Jones, Charles,22882101.450.000.000.00101.45
Martinez, Jill,242354829.390.003578.270.001251.12
Nelson, Kevin,1476584.970.000.000.0084.97
Carter, Jesse, E,22141166.280.000.000.00166.28
Thompson, Abigail,243324816.090.003578.270.001237.82
Jai, Edwin,169211754.980.000.000.001754.98
Hall, Kaylee, E,1975137.270.000.000.0037.27
Flores, Xavier,238664828.110.003578.270.001249.84
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Luo, Franklin, J,2202759.980.000.000.0059.98
Williams, Ethan,243094793.120.003578.270.001214.85
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Moore, Jonathan,2047896.460.000.000.0096.46
Perry, Jonathan, T,27026699.100.00699.100.000.00
Coleman, Dylan,27403132.970.000.000.00132.97
Campbell, Lucas,2932953.990.000.000.0053.99
Bennett, Seth,244933578.270.003578.270.000.00
Young, Jenna, W,163652490.180.000.000.002490.18
Alexander, Julia, J,15291889.470.000.000.00889.47
Allen, Aaron, A,200753399.990.003399.990.000.00
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Anand, Brendan, L,1984721.980.000.000.0021.98
Murphy, Juan, T,246463578.270.003578.270.000.00
Rodriguez, Richard,12969180.790.000.000.00180.79
Moore, Wyatt, F,189712351.960.000.000.002351.96
Garcia, Victoria, V,245013578.270.003578.270.000.00
Bell, Christina,2609939.980.000.000.0039.98
Clark, Emily, R,120862294.990.000.000.002294.99
Hayes, Austin,202083219.580.002049.100.001170.48
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Watson, Marcus,2271585.480.000.000.0085.48
Li, Connor,201863191.910.002071.420.001120.49
Walker, Thomas,1307193.980.000.000.0093.98
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Baker, Sean, T,247782858.490.002181.56676.930.00
Moore, Anthony, M,2473039.980.000.000.0039.98
Rowe, Todd,14586233.940.000.000.00233.94
Thomas, Charles,250942443.350.002443.350.000.00
Evans, Alexandra,2432268.490.000.000.0068.49
Peterson, Xavier, R,2645639.980.000.000.0039.98
Adams, Haley, M,247862443.350.002443.350.000.00
Perez, Timothy, L,227304.990.000.000.004.99
Wilson, Eduardo,15323804.470.000.000.00804.47
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Zhang, Robert,188551155.480.000.000.001155.48
Martinez, Carol, D,17656578.460.000.000.00578.46
Gomez, Renee, L,253712181.560.002181.560.000.00
Foster, Kayla,1969371.950.000.000.0071.95
Griffin, Haley, L,1892582.180.000.000.0082.18
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Brooks, Victoria, H,16479158.510.000.000.00158.51
Lal, Caleb, R,1586874.460.000.000.0074.46
Parker, Natalie, A,251043018.330.002443.350.00574.98
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Blue, Paige,2170313.980.000.000.0013.98
Clark, Anthony,27071782.990.00782.990.000.00
Alexander, Sarah,1941129.990.000.000.0029.99
Lal, Kyle,17360122.180.000.000.00122.18
Howard, Isaiah,259813018.330.002443.350.00574.98
Wood, Brittany,2877753.990.000.000.0053.99
Allen, Sean, L,12097159.220.000.000.00159.22
Wright, Robert, C,158894848.030.000.000.004848.03
Gonzales, Emily, P,21777180.980.000.000.00180.98
Watson, Devin, A,18875114.950.000.000.00114.95
Coleman, Lucas, A,27060782.990.00782.990.000.00
Shan, Chad, M,2462112.940.000.000.0012.94
Robinson, Dylan, L,1472481.530.000.000.0081.53
Harris, Edward,27062782.990.00782.990.000.00
She, Shawn, J,16902141.980.000.000.00141.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Williams, Morgan, C,203733226.900.002071.420.001155.48
Ward, Natalie, J,132412325.960.000.000.002325.96
Blue, Melanie, L,178611749.960.000.000.001749.96
Flores, Stephanie,259922721.550.000.002181.56539.99
Patterson, Abigail, H,144784795.010.000.000.004795.01
Collins, Isaac,260777.280.000.000.007.28
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Phillips, Andrea,1857383.740.000.000.0083.74
Rivera, Amanda,11131115.920.000.000.00115.92
Bennett, Maria, G,229837.280.000.000.007.28
Brooks, Steven, C,14877889.470.000.000.00889.47
Davis, Thomas,167641760.470.000.000.001760.47
Perry, Ryan,132494795.340.000.000.004795.34
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Torres, Xavier,16840176.950.000.000.00176.95
Morris, Richard,2007039.980.000.000.0039.98
Edwards, Elijah, D,281577.280.000.000.007.28
Green, Mackenzie, C,280737.280.000.000.007.28
Powell, Jack, J,1841156.960.000.000.0056.96
Phillips, Luis, G,207347.280.000.000.007.28
Brown, Julia,18065155.470.000.000.00155.47
Moreno, Renee, C,12936265.220.000.000.00265.22
Howard, Brianna, D,246304.990.000.000.004.99
Lewis, Morgan,17410168.740.000.000.00168.74
Thomas, Thomas,216292624.080.000.002049.10574.98
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Roberts, Rebecca,2800094.480.000.000.0094.48
Hughes, Samantha,2721564.470.000.000.0064.47
Brooks, Evan,2340139.980.000.000.0039.98
Bradley, Jocelyn,230227.280.000.000.007.28
Taylor, Zachary, M,27082782.990.000.00782.990.00
Jackson, Victoria,270194.990.000.000.004.99
Davis, Austin, E,133664749.040.000.000.004749.04
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Walker, Richard, T,19640224.550.000.000.00224.55
King, Gabrielle,263504.990.000.000.004.99
Taylor, Victoria,260132443.350.000.002443.350.00
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Moreno, Lance, A,2922939.980.000.000.0039.98
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Barnes, Ian, M,16106133.540.000.000.00133.54
Gutierrez, Neil, L,214897.280.000.000.007.28
Stewart, Cody, A,212843223.580.000.002049.101174.48
Lewis, Zachary, L,14760167.260.000.000.00167.26
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Ward, Nicole, L,212724435.380.000.002071.422363.96
Russell, Caleb,23552103.480.000.000.00103.48
Roberts, Amanda,171752334.980.000.000.002334.98
Davis, Emily,27267782.990.000.00782.990.00
Powell, Katherine, C,14574177.600.000.000.00177.60
Flores, Hannah,1952540.230.000.000.0040.23
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Adams, Julia, N,2607359.980.000.000.0059.98
Martin, Thomas, A,169521735.980.000.000.001735.98
Carter, Bailey,213322616.860.000.002616.860.00
Smith, Megan, J,2671668.970.000.000.0068.97
Sharma, Kathryn,20740140.940.000.000.00140.94
Simmons, Haley, T,262022749.320.000.002181.56567.76
Cooper, Brian, L,13760128.840.000.000.00128.84
Stewart, Amanda, M,1531094.440.000.000.0094.44
Long, Morgan, H,213522625.390.000.002071.42553.97
Alvarez, Melody,2507068.490.000.000.0068.49
Scott, Allison,14497804.480.000.000.00804.48
Coleman, Ashley,27297782.990.000.00782.990.00
Scott, Mason,2355139.980.000.000.0039.98
Ashe, Alexis, S,194141145.480.000.000.001145.48
Baker, Ian, V,262002756.540.000.002181.56574.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Green, Kaylee, C,2618567.970.000.000.0067.97
Deng, Damien, A,16873578.460.000.000.00578.46
Roberts, Carlos,2319639.980.000.000.0039.98
Russell, Chloe, M,12763589.960.000.000.00589.96
Washington, Elijah, L,250164.990.000.000.004.99
Russell, Gail, L,212634.990.000.000.004.99
Chen, Jack, E,17579151.430.000.000.00151.43
Walker, Emma, M,2520998.960.000.000.0098.96
White, James,253317.280.000.000.007.28
Anderson, Ryan, W,132712319.990.000.000.002319.99
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Washington, Ryan,2833294.480.000.000.0094.48
Cooper, Angela,195261179.470.000.000.001179.47
Torres, Erin,1218287.250.000.0037.2949.96
Flores, Gabriel,271117.280.000.000.007.28
Thomas, Ian,191181120.490.000.000.001120.49
Hall, Luke, E,14745902.460.000.000.00902.46
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Hayes, Dalton, C,188822322.280.000.000.002322.28
Powell, Caleb, G,216132610.580.000.002049.10561.48
Rivera, Sara,187852350.960.000.000.002350.96
Parker, Kaylee, M,2773878.980.000.000.0078.98
Brooks, Mariah,216202620.400.000.002071.42548.98
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Edwards, Alexandra,133582386.940.000.000.002386.94
Thomas, Richard,27557782.990.000.00782.990.00
Gonzales, Jordan,2368113.980.000.000.0013.98
Gonzalez, Morgan,130651700.990.000.000.001700.99
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Howard, Alyssa, A,11513863.950.000.000.00863.95
Parker, Jordan,216212616.860.000.002049.10567.76
Bell, Garrett, J,14265161.230.000.000.00161.23
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Garcia, Lucas,27545782.990.000.00782.990.00
Phillips, Haley, B,2807939.980.000.000.0039.98
Howard, Erin, L,183621725.210.000.000.001725.21
Blue, Marcus, L,27550782.990.000.00782.990.00
Sanders, Angel,16219553.970.000.000.00553.97
Evans, Elijah, S,2588439.980.000.000.0039.98
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Gonzales, Jose,2201439.980.000.000.0039.98
Coleman, Stephanie,2226489.970.000.000.0089.97
Morgan, Brianna, D,111362380.470.000.002380.470.00
Ward, Mariah, J,2158044.910.000.000.0044.91
Brown, Dylan, J,124492351.960.000.000.002351.96
Griffin, Julian, M,113284718.040.000.002319.992398.05
Baker, Eduardo,180921789.450.000.000.001789.45
Foster, Isabelle,2637739.980.000.000.0039.98
Russell, Jacqueline,18391100.960.000.0078.9821.98
Griffin, Melissa, L,287807.950.000.000.007.95
Ma, Tiffany,2157739.980.000.000.0039.98
Sanders, Xavier,1672173.750.000.000.0073.75
Wang, Benjamin, R,274547.280.000.000.007.28
Hall, Taylor, J,169951735.980.000.000.001735.98
Clark, Lauren,170341750.980.000.000.001750.98
Gray, Seth, M,2008785.480.000.000.0085.48
Jones, Michael, A,2210771.970.000.000.0071.97
Ward, Devin, J,15378170.910.000.0076.9593.96
Wang, Karen, P,1955331.970.000.000.0031.97
Nelson, Henry,193941155.480.000.000.001155.48
White, Tyler,14291258.440.000.0049.97208.47
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Green, Xavier,2356739.980.000.000.0039.98
Brooks, Bryce,12061140.170.000.00112.2527.92
Stewart, Marcus, R,2063221.980.000.000.0021.98
Bailey, Maria, C,1915034.980.000.000.0034.98
Garcia, Christian, J,164913106.330.000.00751.342354.99
Martin, Tyler, L,2772469.990.000.000.0069.99
Reed, Morgan, E,2877923.970.000.000.0023.97
Russell, Melanie, B,15478182.830.000.00167.8514.98
Allen, Mason,176252431.950.000.000.002431.95
Baker, Gabriella,174041709.980.000.000.001709.98
Flores, Caleb, S,12165280.640.000.00243.3737.27
Hall, Wyatt,2382713.980.000.000.0013.98
Bryant, Dakota, L,176132401.950.000.000.002401.95
Thomas, Jessica,1684894.480.000.0094.480.00
Li, Rafael, M,217527.280.000.000.007.28
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Miller, Eduardo,14561158.840.000.0049.97108.87
Ortega, Sheila, M,2763239.980.000.000.0039.98
Collins, Jonathan,16849119.980.000.000.00119.98
Butler, Trevor,2741569.990.000.0069.990.00
Adams, Jennifer,153624745.020.000.000.004745.02
Stewart, Gabriella,2803469.990.000.000.0069.99
Peterson, Jessica, M,11868247.010.000.0061.97185.04

Generated 2025-11-02 03:16:39.339 UTC