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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Cox, Lucas, J,253932443.350.002443.350.000.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Phillips, James, G,16846180.950.000.00180.950.00
Nath, Carl, H,29001624.970.000.000.00624.97
Davis, Marcus, T,17337123.910.000.0086.9536.96
Bell, Chase,180911750.980.000.000.001750.98
Washington, Thomas, C,2745137.430.000.000.0037.43
Hughes, Luis,130841798.960.000.000.001798.96
Clark, Anthony,27071782.990.00782.990.000.00
Richardson, Evan, J,15488165.300.000.000.00165.30
Young, Savannah,259712749.320.002181.560.00567.76
Gonzales, Jose,2201439.980.000.000.0039.98
Williams, Morgan, C,203733226.900.002071.420.001155.48
Diaz, Brandon,236764.990.000.004.990.00
King, Caleb, J,2898678.980.000.000.0078.98
Evans, Jordan,2920939.980.000.0039.980.00
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Foster, Aaron,155664912.470.000.000.004912.47
Griffin, Isabelle,249864.990.000.000.004.99
Jones, Alexandra, B,2020245.950.000.000.0045.95
Sanders, Isaiah,2587339.980.000.000.0039.98
Hall, Taylor, J,169951735.980.000.000.001735.98
Simmons, Dakota, T,14110819.460.000.00819.460.00
Nelson, Henry,193941155.480.000.000.001155.48
Alexander, Thomas,207607.280.000.000.007.28
Griffin, Melissa, L,287807.950.000.000.007.95
Cooper, Grace, C,1601294.260.000.0069.9924.27
Green, Xavier,2356739.980.000.000.0039.98
Patterson, Natalie,16123629.970.000.000.00629.97
Baker, Isaiah,12106169.540.000.000.00169.54
Rivera, Makayla, A,2878334.990.000.0034.990.00
Wang, Benjamin, R,274547.280.000.000.007.28
Hughes, Anna,197052341.970.000.000.002341.97
James, Maria,1624391.970.000.0069.9921.98
Green, Gabriella, C,2803569.990.000.0069.990.00
Bryant, Rachel,220197.280.000.007.280.00
Zhang, Nathan, L,2910478.980.000.000.0078.98
Li, Jordan,17026261.390.000.00261.390.00
Rivera, Ariana,261734.990.000.004.990.00
Adams, Kyle, E,1881269.990.000.0069.990.00
Wilson, Grace,17539205.920.000.000.00205.92
Ramirez, Richard, C,282397.280.000.007.280.00
Campbell, Gabriella,188411145.480.000.001145.480.00
Gonzalez, Molly,1637021.980.000.000.0021.98
Sanchez, Faith,270494.990.000.004.990.00
Sara, Ivan, L,2509067.930.000.000.0067.93
Reed, Mariah,263731565.910.001000.440.00565.47
Roberts, Noah, S,2704268.490.000.000.0068.49
Bell, Eduardo,27101782.990.000.00782.990.00
Powell, Ian,2608564.470.000.000.0064.47
Thomas, Isabella, M,27265782.990.000.00782.990.00
Richardson, Charles, I,121144719.020.000.002325.962393.06
Cooper, Christina, C,265121000.440.000.001000.440.00
Davis, Dylan,15556588.960.000.00588.960.00
Evans, James, C,206654408.560.000.002049.102359.46
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Thompson, Joshua, F,259992181.560.000.002181.560.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
White, Christopher, R,260492181.560.000.002181.560.00
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Henderson, Abigail,2044139.980.000.000.0039.98
Coleman, Ashley,27297782.990.000.00782.990.00
Reed, Michelle,2804669.990.000.000.0069.99
Mitchell, Maria, D,27404782.990.000.00782.990.00
Patterson, Austin, O,270247.280.000.000.007.28
Coleman, Vanessa,215892589.090.000.002049.10539.99
Ward, Eduardo, I,139162354.980.000.000.002354.98
Hayes, Carson, A,124472331.950.000.002331.950.00
Perry, James,192051249.840.000.000.001249.84
Robinson, William,20103103.480.000.00103.480.00
Cox, Devin, C,134184768.050.000.002329.992438.06
Price, Riley, R,139094764.020.000.002344.962419.06
Hall, Noah, A,1525175.250.000.0068.976.28
Diaz, Alyssa,139084715.330.000.002294.992420.34
Shan, Logan,1867760.960.000.0060.960.00
Edwards, Madeline,2077146.470.000.000.0046.47
Thomas, Benjamin, J,2129556.970.000.000.0056.97
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
Luo, Franklin, J,2202759.980.000.000.0059.98
Moore, Jonathan,2047896.460.000.000.0096.46
Price, Mariah, C,2074549.480.000.000.0049.48
Jai, Edwin,169211754.980.000.000.001754.98
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
Smith, Samuel, D,2308349.900.000.000.0049.90
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Walker, Brandon, J,159164793.270.000.000.004793.27
Hill, Haley, J,161033142.320.000.00792.342349.98
Harris, Matthew,14330806.760.000.000.00806.76
Powell, Caleb, G,216132610.580.000.002049.10561.48
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Russell, Jessica,265721000.440.000.001000.440.00
Carter, Elijah,216182611.070.000.002611.070.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
King, Jordan, C,110202316.970.000.002316.970.00
Washington, Riley, L,185441155.480.000.001155.480.00
Jackson, Edward,290422420.340.000.002420.340.00
Jai, Hunter, M,28272111.950.000.000.00111.95
Moore, Anthony, M,2473039.980.000.000.0039.98
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Flores, Madison,14416769.490.000.000.00769.49
Alexander, Julia, J,15291889.470.000.000.00889.47
Flores, Kevin,15878225.920.000.0069.97155.95
Anand, Brendan, L,1984721.980.000.000.0021.98
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Martinez, Dominique,287888.990.000.008.990.00
Gonzales, Kayla,214947.280.000.000.007.28
Cooper, Andrea,2932378.980.000.000.0078.98
Thompson, Tyler,2750269.990.000.0069.990.00
Prasad, Donald,15413318.920.000.00123.98194.94
Perry, Natalie,1712669.990.000.000.0069.99
Hayes, Hannah, J,2165656.970.000.000.0056.97
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Griffin, Miguel,2146476.970.000.000.0076.97
Hu, Gilbert, L,2876769.990.000.000.0069.99
Peterson, Morgan, J,168341750.980.000.000.001750.98
Prasad, Erick, E,28786127.950.000.000.00127.95
Lal, Kyle,17360122.180.000.000.00122.18
Russell, Ian, T,2474613.980.000.0013.980.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Thompson, Madison, L,187882351.960.000.000.002351.96
Griffin, Marcus,2075634.560.000.000.0034.56
Wood, Brittany,2877753.990.000.000.0053.99
Collins, Isaac,260777.280.000.000.007.28
Barnes, Elizabeth, J,249397.280.000.000.007.28
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Harris, Jacob, G,2367939.980.000.0039.980.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Howard, Brianna, D,246304.990.000.000.004.99
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Turner, Samuel,2742069.990.000.0069.990.00
Williams, Destiny, S,15881564.990.000.00564.990.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Raje, Mindy, A,16083561.970.000.000.00561.97
James, Emma,127812329.980.000.000.002329.98
Simmons, Anna, K,124512367.920.000.000.002367.92
Murphy, Maria,160113657.260.000.000.003657.26
Evans, Connor, J,15402131.550.000.000.00131.55
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Blanco, Armando, F,139182397.950.000.000.002397.95
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Simmons, Adam,253274.990.000.000.004.99
James, Morgan, E,2324539.980.000.000.0039.98
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Butler, Jackson, J,183241735.980.000.000.001735.98
Long, Gavin,13762186.030.000.0036.59149.44
Hughes, Austin, P,183681754.980.000.000.001754.98
Ward, Lucas, N,183631700.990.000.000.001700.99
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Walker, Richard, T,19640224.550.000.000.00224.55
Baker, Robert, A,273007.280.000.007.280.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Foster, Paige,2742894.480.000.000.0094.48
Li, Brandon,2933973.960.000.000.0073.96
Stewart, Makayla,16649115.940.000.000.00115.94
Kumar, Cameron, S,185711120.490.000.001120.490.00
Martin, Joshua, A,276077.280.000.007.280.00
Flores, Cassidy, L,233684.990.000.000.004.99
Chen, David,2720839.980.000.000.0039.98
Kumar, Elijah,15197156.920.000.000.00156.92
Russell, Katherine,2877169.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Parker, Eduardo, M,12939169.420.000.00110.2059.22
Parker, Jeremy,2866878.980.000.0078.980.00
Watson, Erin, B,227724.990.000.004.990.00
Van, Bobby,27757132.970.000.00132.970.00
Murphy, Brianna, K,2834269.990.000.000.0069.99
King, Sara,2235439.980.000.000.0039.98
Srini, Ruben,18078200.940.000.0071.97128.97
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Chen, Ethan,2054756.970.000.000.0056.97
Brown, Julia,18065155.470.000.000.00155.47
Roberts, Rebecca,2800094.480.000.000.0094.48
Johnson, Jonathan,220597.280.000.007.280.00
Sanders, Sean,14341175.150.000.000.00175.15
Nath, Alison, J,171161764.960.000.000.001764.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Gutierrez, Neil, L,214897.280.000.000.007.28
Edwards, Elijah, D,281577.280.000.000.007.28
Brooks, Evan,2340139.980.000.000.0039.98
Luo, Jodi,2921368.490.000.000.0068.49
Sanders, Mason, G,2345939.980.000.000.0039.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Allen, Mason,176252431.950.000.000.002431.95
Russell, Nicole, M,182372318.960.000.000.002318.96
Diaz, Gabrielle,14893839.480.000.000.00839.48
Davis, Jonathan,2925913.980.000.000.0013.98
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Gray, Marcus, T,183892401.450.000.000.002401.45
Henderson, Austin,2764354.980.000.000.0054.98
Jackson, Andrew,2047985.480.000.000.0085.48
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Lee, Samantha, B,2737878.980.000.000.0078.98
Morgan, Isabella, L,28602144.470.000.000.00144.47
James, Julia,2497567.930.000.000.0067.93
Ward, Kaylee, A,244154.990.000.004.990.00
Coleman, Samuel, N,17450123.980.000.000.00123.98
Russell, Caleb,23552103.480.000.000.00103.48
Edwards, Hailey,242584.990.000.000.004.99
Scott, Allison,14497804.480.000.000.00804.48
Ashe, Alexis, S,194141145.480.000.000.001145.48
Zhao, Clarence, R,1982671.970.000.0071.970.00
Xu, Louis,2010466.530.000.0066.530.00
Gonzales, Jordan,2368113.980.000.000.0013.98
Phillips, Haley, B,2807939.980.000.000.0039.98
Roberts, Jordan, M,1680039.250.000.000.0039.25
Martinez, Joseph, E,2921459.980.000.0059.980.00
Prasad, Summer, M,2214339.980.000.0039.980.00
Taylor, Lucas, V,115232376.960.000.002376.960.00
Gray, Sara,292472447.050.000.002447.050.00
Washington, Aaron, L,246494.990.000.000.004.99
Barnes, Ian, M,16106133.540.000.000.00133.54
Foster, Isabelle,2637739.980.000.000.0039.98
Ma, Tiffany,2157739.980.000.000.0039.98
Lee, James, J,2881769.990.000.0069.990.00
Scott, Eric,282484.990.000.004.990.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Martin, Kellie, R,28195574.980.000.000.00574.98
Collins, Jose,2474839.980.000.0039.980.00
Taylor, Edward, C,17442319.880.000.00230.9088.98
Jackson, Brianna,1537797.910.000.0074.9822.93
Rodriguez, Natalie,2077330.970.000.000.0030.97
Garcia, Kayla, L,2130881.460.000.000.0081.46
Jones, Michael, A,2210771.970.000.000.0071.97
Gray, Seth, M,2008785.480.000.000.0085.48
Wang, Karen, P,1955331.970.000.000.0031.97
Anderson, Daniel,20694146.970.000.00146.970.00
Gray, Isabella,168203217.790.000.000.003217.79
Moore, Jessica, J,2008576.760.000.000.0076.76
Torres, Victoria,17551160.920.000.000.00160.92
Moore, Chloe, L,2626913.980.000.000.0013.98
Washington, Hailey, S,2588559.980.000.000.0059.98
Andersen, Latoya, J,290578.990.000.000.008.99
Reed, Isaac, D,260747.280.000.000.007.28
Carter, Jesse, E,22141166.280.000.000.00166.28
Ramirez, Ian,166783162.310.000.00742.352419.96
Henderson, Hailey, C,171481775.470.000.000.001775.47
Thomas, Jeremiah,183721760.470.000.000.001760.47
Walker, Jacob, N,29027574.980.000.000.00574.98
Deng, Wayne,2145336.960.000.0036.960.00
Stewart, Melissa,2517336.960.000.000.0036.96
Henderson, Olivia,188591155.480.000.000.001155.48
Foster, Jose, C,2878534.990.000.000.0034.99
Mitchell, Bailey, B,267067.280.000.007.280.00
Blue, Paige,2170313.980.000.000.0013.98
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Jones, Alexander, I,2002180.960.000.000.0080.96
Alexander, Angelica,2271471.950.000.000.0071.95
_SUM1806517.5081404.32496236.54389766.13839110.51

Generated 2024-09-20 05:51:23.085 UTC