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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Richardson, Charles, I,121144719.020.000.002325.962393.06
Reed, Mariah,263731565.910.000.001000.44565.47
Barnes, Blake, A,178651789.970.000.000.001789.97
Smith, Zachary, W,2378358.980.000.0058.980.00
Chen, Jonathan, G,13096200.690.000.000.00200.69
Diaz, Trevor, B,2051954.960.000.000.0054.96
Alexander, Gavin, K,2932249.990.000.000.0049.99
Perry, Brandon,22095141.980.000.000.00141.98
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Smith, Austin,13707149.050.000.000.00149.05
Allen, Madeline,2924068.970.000.000.0068.97
Lee, Don,188392384.970.000.000.002384.97
Howard, Erin, L,183621725.210.000.000.001725.21
Ward, Lucas, N,183631700.990.000.000.001700.99
Miller, Eduardo,14561158.840.000.0049.97108.87
Foster, Isabelle,2637739.980.000.000.0039.98
Gomez, Briana, A,2878443.980.000.000.0043.98
Smith, Noah,13175166.920.000.000.00166.92
Baker, Eduardo,180921789.450.000.000.001789.45
Long, Rachel,2828339.980.000.000.0039.98
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Evans, Alexandra,2432268.490.000.000.0068.49
Bailey, Maria, C,1915034.980.000.000.0034.98
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Perez, Timothy, L,227304.990.000.000.004.99
Baker, Gabriella,174041709.980.000.000.001709.98
Ramirez, Emma,29072128.970.000.000.00128.97
Martin, Christian, V,19709197.250.000.000.00197.25
Collins, Eduardo,139872329.990.000.000.002329.99
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Ross, Kelly,2607676.960.000.000.0076.96
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Nelson, James, L,245257.280.000.007.280.00
Stewart, Alexandria,174761700.990.000.000.001700.99
Russell, Katherine,2877169.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Foster, Caleb,27112114.460.000.000.00114.46
Diaz, Faith, M,2236356.970.000.000.0056.97
Roberts, Hunter,282607.280.000.000.007.28
Perry, Lauren,248164.990.000.000.004.99
Carter, Jonathan,14578848.470.000.000.00848.47
Adams, Gabriel, S,195271219.450.000.000.001219.45
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Kumar, Cameron, S,185711120.490.000.001120.490.00
Robinson, Lauren,2719668.490.000.000.0068.49
Sanders, Lucas, W,268024.990.000.000.004.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Robinson, Madison, W,183772394.970.000.000.002394.97
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Cook, Joan,235544.990.000.000.004.99
Cox, Sara, P,2775869.990.000.000.0069.99
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Torres, Christina, M,20746119.950.000.000.00119.95
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Lee, Samantha, B,2737878.980.000.000.0078.98
White, Emma, N,16090604.960.000.000.00604.96
Chandra, Allen,2932753.990.000.000.0053.99
Nelson, Katherine,2802178.980.000.000.0078.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Campbell, Natalie, L,115122319.990.000.000.002319.99
James, Julia,2497567.930.000.000.0067.93
Reed, Gabriella, A,2743778.980.000.000.0078.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Kumar, Austin,204834400.060.000.002049.102350.96
Perez, Savannah, J,17036176.950.000.0056.97119.98
Hill, Sydney,264821000.440.000.001000.440.00
Rubio, Ruben, D,1887186.960.000.0086.960.00
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Ross, Jose,2744178.980.000.0078.980.00
Butler, Ana,260403018.330.000.002443.35574.98
Harris, Jacob, G,2367939.980.000.0039.980.00
James, Timothy,213312670.890.000.002670.890.00
Moore, Logan,2634889.970.000.0089.970.00
Washington, Taylor,212664525.070.000.002049.102475.97
Chen, Luis, G,2125294.450.000.0094.450.00
Stewart, Cody, A,212843223.580.000.002049.101174.48
Bell, Timothy, J,2810178.980.000.0078.980.00
Collins, Connor, J,27270782.990.000.00782.990.00
Harris, Natalie,2368259.980.000.0059.980.00
Ward, Juan, H,215952649.560.000.002049.10600.46
Chen, Ethan,2054756.970.000.000.0056.97
Hayes, Carson, A,124472331.950.000.000.002331.95
Stewart, Lucas, J,2934198.970.000.000.0098.97
Robinson, William,20103103.480.000.000.00103.48
Thomas, Zachary, D,28045119.980.000.000.00119.98
Lal, Robert, L,14084138.680.000.000.00138.68
Martin, Kellie, R,28195574.980.000.000.00574.98
Diaz, Thomas, O,16020595.960.000.000.00595.96
Phillips, Aaron, R,2494739.980.000.000.0039.98
Flores, Brittany,169062359.980.000.000.002359.98
Alexander, Logan, E,191161183.470.000.000.001183.47
Gonzales, Kayla,214947.280.000.000.007.28
Russell, Chloe, M,12763589.960.000.000.00589.96
Robinson, Zachary, L,137092332.280.000.000.002332.28
Roberts, Robert, R,1898656.970.000.0056.970.00
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Lobao, Alexandre,1892691.950.000.0091.950.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Xu, Louis,2010466.530.000.0066.530.00
Diaz, Alyssa,139084715.330.000.000.004715.33
Peterson, Steven, L,234497.280.000.007.280.00
Perry, Natalie,1712669.990.000.000.0069.99
Brooks, Steven, C,14877889.470.000.000.00889.47
Mitchell, Caleb, K,268064.990.000.000.004.99
Roberts, Amanda,171752334.980.000.000.002334.98
Parker, Caleb, A,2631813.980.000.000.0013.98
Chen, Jack, E,17579151.430.000.000.00151.43
Garcia, Christian, J,164913106.330.000.00751.342354.99
McDonald, Aaron, J,27734119.980.000.000.00119.98
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Rubio, Javier, E,1972664.240.000.0064.240.00
Alexander, Julia, J,15291889.470.000.000.00889.47
Prasad, Summer, M,2214339.980.000.0039.980.00
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Anderson, David, A,2209761.960.000.0061.960.00
Coleman, Dylan,27403132.970.000.000.00132.97
Sanchez, Stephanie,1786756.970.000.000.0056.97
Stewart, Allison, R,18826166.430.000.0069.9996.44
Washington, Ryan,2833294.480.000.000.0094.48
Hall, Jan, M,11740334.120.000.00235.1598.97
Richardson, Arianna, C,1205534.980.000.0034.980.00
Jai, Edwin,169211754.980.000.000.001754.98
Scott, Eric,282484.990.000.004.990.00
Phillips, Devin,18759112.060.000.000.00112.06
Johnson, Xavier, R,2325539.980.000.0039.980.00
Flores, Julia, E,172631700.990.000.000.001700.99
Gray, Cody, C,144594775.010.000.000.004775.01
Morgan, Marcus, W,289682.290.000.000.002.29
Baker, Allison,2649558.980.000.000.0058.98
Barnes, Elizabeth, J,249397.280.000.000.007.28
Young, Courtney,176222374.980.000.000.002374.98
Ward, Emma, W,2179659.980.000.000.0059.98
Ward, Mariah, J,2158044.910.000.000.0044.91
Long, Sydney,279217.280.000.000.007.28
Reed, Michelle,2804669.990.000.000.0069.99
Wilson, Madison, H,1982821.980.000.000.0021.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Alexander, Edward, E,18524195.950.000.000.00195.95
Collins, Jose,2474839.980.000.0039.980.00
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Jackson, Brianna,1537797.910.000.0074.9822.93
Peterson, Christina,2897694.480.000.000.0094.48
Alexander, Julian,132172351.960.000.000.002351.96
Barnes, Emily, G,15996564.990.000.000.00564.99
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Bell, Christina,2609939.980.000.000.0039.98
Rogers, Bryce,174022304.980.000.000.002304.98
James, Adrian, C,253404.990.000.000.004.99
Parker, Kaylee, M,2773878.980.000.000.0078.98
Barnes, Dalton, C,178581700.990.000.000.001700.99
Wang, Karen, P,1955331.970.000.000.0031.97
Wilson, Eduardo,15323804.470.000.000.00804.47
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Thomas, Richard,27557782.990.000.00782.990.00
Ramirez, Richard, C,282397.280.000.007.280.00
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Anderson, Daniel,20694146.970.000.00146.970.00
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Hayes, Gavin, A,194001179.470.000.000.001179.47
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Powell, Ian,2608564.470.000.000.0064.47
Morgan, Brianna, D,111362380.470.000.002380.470.00
Andersen, Latoya, J,290578.990.000.000.008.99
Russell, Elijah, M,118354772.300.000.002319.262453.04
Foster, Jessica,2606951.460.000.0051.460.00
Davis, Richard, R,15549574.980.000.00574.980.00
Butler, Jackson, J,183241735.980.000.000.001735.98
Lal, Caleb, R,1586874.460.000.000.0074.46
Moore, Jessica, J,2008576.760.000.000.0076.76
Foster, Carson, L,16959135.350.000.0085.4849.87
Russell, Melanie, B,15478182.830.000.00167.8514.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Collins, Amanda,2078339.980.000.000.0039.98
Ross, Kaitlyn,16121614.470.000.000.00614.47
Wood, Brittany,2877753.990.000.000.0053.99
Collins, Isaac,260777.280.000.000.007.28
Miller, Kayla, A,236734.990.000.000.004.99
Flores, Madison,14416769.490.000.000.00769.49
Washington, Alexis,1978146.260.000.007.2838.98
Allen, Luke,113162349.980.000.002349.980.00
Alexander, Luke,290432447.050.000.002447.050.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Diaz, Hailey, W,116932294.990.000.002294.990.00
Anderson, Jasmine, A,235534.990.000.000.004.99
Henderson, Hailey, C,171481775.470.000.000.001775.47
Coleman, Samuel, N,17450123.980.000.000.00123.98
Russell, Caleb,23552103.480.000.000.00103.48
Adams, Julia, N,2607359.980.000.000.0059.98
Smith, Megan, J,2671668.970.000.000.0068.97
Howard, Natalie,1349154.960.000.0014.9839.98
Martin, Madison, C,2049271.970.000.0071.970.00
Carter, Isaac,137191129.480.000.000.001129.48
Prasad, Erick, E,28786127.950.000.000.00127.95
King, Gabrielle,263504.990.000.000.004.99
Williams, Austin,2035432.220.000.000.0032.22
Butler, Cassidy, L,21792114.460.000.000.00114.46
Phillips, Haley, B,2807939.980.000.000.0039.98
White, Greg, C,174032322.280.000.000.002322.28
Hall, Natalie, A,230704.990.000.004.990.00
Evans, Maria,22544127.280.000.00127.280.00
Collins, Allison,28581119.980.000.000.00119.98
Price, Caroline,180511735.980.000.000.001735.98
Ma, Tiffany,2157739.980.000.000.0039.98
Blue, Paige,2170313.980.000.000.0013.98
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Martin, Tyler, L,2772469.990.000.000.0069.99
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Raje, Mindy, A,16083561.970.000.000.00561.97
Edwards, Amber, B,2051776.970.000.000.0076.97
Williams, Destiny, S,15881564.990.000.00564.990.00
Li, Brandon,2933973.960.000.000.0073.96
Stewart, Makayla,16649115.940.000.000.00115.94
Martin, Katherine, J,2027339.980.000.000.0039.98
Richardson, Devin, G,2131836.960.000.000.0036.96
Wright, Katelyn, A,14502122.260.000.0014.98107.28
Simmons, Adam,253274.990.000.000.004.99
Hayes, Jason,261764.990.000.000.004.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Stewart, Garrett, O,15762564.480.000.000.00564.48
Luo, Donna, E,248054.990.000.000.004.99
Brooks, Allison,146054750.010.000.000.004750.01
Diaz, Gabrielle,14893839.480.000.000.00839.48
Adams, Carlos,1982236.960.000.000.0036.96
Kelly, Julia,2379867.930.000.0067.930.00
Gill, Robyn, J,127651750.980.000.001750.980.00
Anderson, Tyler, E,131481137.430.000.001137.430.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Harris, Noah,292562393.060.000.002393.060.00
Peterson, Melissa, S,249954.990.000.000.004.99
Martin, Joshua, A,276077.280.000.000.007.28
Perez, Barry, M,2728269.990.000.000.0069.99
Coleman, Ian,2127639.980.000.000.0039.98
Thompson, Lucas, O,212774.990.000.000.004.99
Jackson, Andrew,2047985.480.000.000.0085.48
Li, Thomas,181162376.960.000.000.002376.96
Watson, Erin, B,227724.990.000.000.004.99
Smith, Eduardo,2069139.980.000.000.0039.98
Barnes, Kayla,2425639.980.000.000.0039.98
Murphy, Brianna, K,2834269.990.000.000.0069.99
Ross, David, M,171431763.970.000.000.001763.97
Henderson, Justin, P,235917.280.000.000.007.28
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Torres, Abigail,253674.990.000.000.004.99
Russell, Richard,2763322.260.000.000.0022.26
_SUM1806517.5061618.95486836.72314943.78943118.05

Generated 2024-11-10 07:08:23.336 UTC