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

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hayes, Dalton, C,188822322.280.000.000.002322.28
Blue, Paige,2170313.980.000.000.0013.98
Evans, Alexandra,2432268.490.000.000.0068.49
Watson, Devin, A,18875114.950.000.000.00114.95
Chen, Ethan,2054756.970.000.000.0056.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
Robinson, Ian, D,138522294.990.000.000.002294.99
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Butler, Cassidy, L,21792114.460.000.000.00114.46
Howard, Erin, L,183621725.210.000.000.001725.21
Brooks, Steven, C,14877889.470.000.000.00889.47
Gutierrez, Neil, L,214897.280.000.000.007.28
Roberts, Amanda,171752334.980.000.000.002334.98
Sanchez, Stephanie,1786756.970.000.000.0056.97
Brooks, Evan,2340139.980.000.000.0039.98
Jackson, Victoria,270194.990.000.000.004.99
Moore, Ian, L,2463939.980.000.000.0039.98
Baker, Allison,2649558.980.000.000.0058.98
Edwards, Hunter,2422067.930.000.000.0067.93
Nath, Carl, H,29001624.970.000.000.00624.97
Bailey, Maria, C,1915034.980.000.000.0034.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
Martin, Katherine, J,2027339.980.000.000.0039.98
Ortega, Sheila, M,2763239.980.000.000.0039.98
Sara, Ivan, L,2509067.930.000.000.0067.93
Ward, Destiny,16128539.990.000.000.00539.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Ward, Eduardo, I,139162354.980.000.000.002354.98
Blanco, Armando, F,139182397.950.000.000.002397.95
Johnson, Madison, L,15530846.460.000.000.00846.46
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Hughes, Austin, P,183681754.980.000.000.001754.98
Griffin, James,28189567.760.000.000.00567.76
Thompson, Lucas, O,212774.990.000.000.004.99
Jackson, Andrew,2047985.480.000.000.0085.48
Rogers, Olivia,12020804.470.000.000.00804.47
Lewis, Rachel, J,14900839.480.000.000.00839.48
Li, Thomas,181162376.960.000.000.002376.96
Gonzales, Gavin,2448813.980.000.000.0013.98
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Johnson, Ian, E,2173283.470.000.000.0083.47
Kapoor, Preston,2143156.970.000.000.0056.97
Williams, Sydney, J,15334848.470.000.000.00848.47
Adams, Katherine, M,235184.990.000.000.004.99
Taylor, Tyler, A,12032614.960.000.00614.960.00
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Johnson, Xavier, R,2325539.980.000.0039.980.00
Brown, Dylan, J,124492351.960.000.000.002351.96
Zhang, Heather,166543056.320.000.00751.342304.98
Hall, Fernando,2210090.950.000.000.0090.95
Martinez, Kristina, S,2134529.930.000.000.0029.93
Scott, Sean, F,2475539.980.000.000.0039.98
Foster, Isabel, M,2174571.950.000.000.0071.95
Russell, Arianna,22728149.930.000.00149.930.00
Stewart, Olivia, B,1874923.780.000.000.0023.78
Lee, Don,188392384.970.000.000.002384.97
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Nelson, Henry,193941155.480.000.000.001155.48
Hall, Eduardo,16847189.940.000.000.00189.94
Perry, Benjamin,291652407.040.000.002407.040.00
Hill, Eric, G,2525667.930.000.0067.930.00
Bryant, Rachel,220197.280.000.007.280.00
Hayes, Gavin, A,194001179.470.000.000.001179.47
Powell, Ian,2608564.470.000.000.0064.47
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Davis, Dylan,15556588.960.000.00588.960.00
Hayes, Logan, J,19026113.240.000.0037.2775.97
Hughes, Caroline, C,2830278.980.000.0078.980.00
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Stewart, Melissa,2517336.960.000.000.0036.96
Smith, Chloe,17619163.920.000.000.00163.92
Flores, Brittany,169062359.980.000.000.002359.98
Williams, Destiny, S,15881564.990.000.00564.990.00
Robinson, Zachary, L,137092332.280.000.000.002332.28
Richardson, Brian,2860878.980.000.000.0078.98
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
James, Morgan, E,2324539.980.000.000.0039.98
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Nelson, James, L,245257.280.000.007.280.00
Hernandez, Sierra,27393123.980.000.00123.980.00
Stewart, Allison, R,18826166.430.000.0069.9996.44
Alexander, Angelica,2271471.950.000.000.0071.95
Diaz, Faith, M,2236356.970.000.000.0056.97
Gray, Mariah,222787.280.000.007.280.00
Adams, Gabriel, S,195271219.450.000.000.001219.45
Adams, Carlos,1982236.960.000.000.0036.96
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Campbell, Lucas,2932953.990.000.000.0053.99
Alexander, Caroline,176541759.970.000.000.001759.97
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Simmons, David, E,120172339.970.000.002339.970.00
Edwards, Logan,250024.990.000.000.004.99
Cox, Arianna, D,1892789.250.000.000.0089.25
Watson, Erin, B,227724.990.000.004.990.00
Smith, Nathan,217647.280.000.007.280.00
Van, Bobby,27757132.970.000.00132.970.00
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Barnes, Dalton, C,178581700.990.000.000.001700.99
Wilson, Eduardo,15323804.470.000.000.00804.47
Griffin, Miguel,2146476.970.000.000.0076.97
Henderson, Justin, P,235917.280.000.000.007.28
Clark, Destiny, L,28600119.980.000.000.00119.98
Russell, Richard,2763322.260.000.000.0022.26
Cannata, Gabrielle, C,217254.990.000.000.004.99
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Wood, Brittany,2877753.990.000.000.0053.99
Moore, Chloe, L,2626913.980.000.000.0013.98
Harris, Samantha, A,244874.990.000.000.004.99
Washington, Hailey, S,2588559.980.000.000.0059.98
Henderson, Abigail,2044139.980.000.000.0039.98
Russell, Megan,16220562.960.000.000.00562.96
Shan, Christian, L,2308439.980.000.000.0039.98
Walker, Emma, M,2520998.960.000.000.0098.96
Torres, Victoria,17551160.920.000.000.00160.92
Taylor, Zachary, M,27082782.990.000.00782.990.00
Simmons, Anna, K,124512367.920.000.000.002367.92
Kumar, Austin,204834400.060.000.002049.102350.96
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Wilson, Christian,27085782.990.000.00782.990.00
Kelly, Trinity,2609515.230.000.000.0015.23
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Deng, Wayne,2145336.960.000.0036.960.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Richardson, Erin, R,1633188.850.000.0038.8849.97
Cox, Julia, A,206703228.570.000.002049.101179.47
Brown, Morgan,2919778.980.000.000.0078.98
Phillips, Jack, R,259952443.350.000.002443.350.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Simmons, Adam,253274.990.000.000.004.99
Stewart, Cody, A,212843223.580.000.002049.101174.48
Ross, Kelly,2607676.960.000.000.0076.96
Ward, Nicole, L,212724435.380.000.002071.422363.96
Patterson, Aaron, W,191131184.460.000.000.001184.46
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Stewart, Garrett, O,15762564.480.000.000.00564.48
Foster, Deb,215012661.400.000.002661.400.00
Foster, Caleb,27112114.460.000.000.00114.46
Coleman, Vanessa,215892589.090.000.002049.10539.99
Thompson, Kayla, D,12363273.900.000.000.00273.90
Ward, Juan, H,215952649.560.000.002049.10600.46
Luo, Donna, E,248054.990.000.000.004.99
Campbell, Alex,119844730.320.000.002329.982400.34
Brooks, Allison,146054750.010.000.000.004750.01
Anderson, Destiny,12895336.650.000.0037.27299.38
Diaz, Richard, A,2668264.470.000.000.0064.47
Griffin, Jack, L,1768632.280.000.000.0032.28
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Carter, Savannah, M,120902350.960.000.000.002350.96
Roberts, Hunter,282607.280.000.000.007.28
Adams, Miguel,11659213.520.000.000.00213.52
Perry, Lauren,248164.990.000.000.004.99
Powell, Blake, J,2237139.980.000.000.0039.98
Bradley, Nathaniel,169551760.470.000.000.001760.47
Hayes, Oscar,2652729.260.000.000.0029.26
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Hall, Luke, E,14745902.460.000.000.00902.46
Mehta, Carmen, C,2743694.480.000.000.0094.48
Gonzalez, James, M,188421155.480.000.000.001155.48
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Luo, Franklin, J,2202759.980.000.000.0059.98
Gill, Robyn, J,127651750.980.000.001750.980.00
Jai, Edwin,169211754.980.000.000.001754.98
Ramirez, Melanie, V,163632481.820.000.002481.820.00
White, Edward, J,15847205.460.000.000.00205.46
Harris, Noah,292562393.060.000.002393.060.00
Edwards, Angel, J,2912469.990.000.000.0069.99
Torres, Dalton,235037.280.000.007.280.00
Harris, Matthew,14330806.760.000.000.00806.76
Price, Rachel, D,2532889.970.000.000.0089.97
Thomas, Megan,2907169.990.000.000.0069.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Bell, Christina,2609939.980.000.000.0039.98
Cook, Joan,235544.990.000.000.004.99
Bryant, Nathan,2145059.980.000.000.0059.98
Morris, Mason, J,22349124.990.000.000.00124.99
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Flores, Julia, E,172631700.990.000.000.001700.99
Kumar, Zachary,254334.990.000.000.004.99
Ward, Emma, W,2179659.980.000.000.0059.98
Simmons, Jose,2464739.980.000.000.0039.98
Wilson, Madison, H,1982821.980.000.000.0021.98
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Alexander, Edward, E,18524195.950.000.000.00195.95
Carter, Elijah,216182611.070.000.002611.070.00
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Patterson, Grace, M,27560782.990.000.00782.990.00
Powell, Sydney, M,14886539.990.000.00539.990.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Taylor, Marcus, A,18944146.940.000.000.00146.94
King, Jordan, C,110202316.970.000.002316.970.00
Torres, Christina, M,20746119.950.000.000.00119.95
Washington, Riley, L,185441155.480.000.001155.480.00
Simmons, Caleb, M,121934833.030.000.000.004833.03
Morgan, Brianna, D,111362380.470.000.002380.470.00
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Davis, Richard, R,15549574.980.000.00574.980.00
Sanders, Sean,14341175.150.000.000.00175.15
Jackson, Edward,290422420.340.000.002420.340.00
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Griffin, Haley, L,1892582.180.000.000.0082.18
Richardson, Lauren, C,14867839.480.000.000.00839.48
Taylor, Natalie, M,14338828.740.000.000.00828.74
Sanchez, Grace,120802354.990.000.000.002354.99
Martin, John, A,144364776.010.000.000.004776.01
Jones, Kayla, C,1854194.260.000.000.0094.26
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Taylor, Taylor,159054899.020.000.000.004899.02
Lal, Caleb, R,1586874.460.000.000.0074.46
Wang, Zachary,2214489.970.000.000.0089.97
Nelson, Sean,11841307.970.000.000.00307.97
Ward, Cole,214907.280.000.000.007.28
Foster, Kayla,1969371.950.000.000.0071.95
Ross, Kaitlyn,16121614.470.000.000.00614.47
Gutierrez, Jerome,127832420.460.000.000.002420.46
Gray, Isabella,168203217.790.000.000.003217.79
Scott, Gabrielle,270614.990.000.000.004.99
Jones, Charles,22882101.450.000.000.00101.45
Phillips, Miguel,2049812.940.000.000.0012.94
Anderson, Jasmine, A,235534.990.000.000.004.99
James, Christina,17409219.920.000.000.00219.92
Sánchez, Angela, C,176551750.980.000.000.001750.98
Allen, Luke,113162349.980.000.002349.980.00
James, Bryce,13466133.450.000.000.00133.45
Alexander, Luke,290432447.050.000.002447.050.00
Johnson, Jacob, I,28069553.970.000.000.00553.97
Howard, Natalie,1349154.960.000.0014.9839.98
White, Greg, C,174032322.280.000.000.002322.28
Thompson, Tyler,2750269.990.000.0069.990.00
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Thomas, Jessica,1684894.480.000.0094.480.00
Thomas, Zachary, D,28045119.980.000.000.00119.98
Coleman, Luke, A,11723152.550.000.0069.9882.57
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Sanchez, Jared, J,2585064.470.000.000.0064.47
Rivera, Sara,187852350.960.000.000.002350.96
Peterson, Morgan, J,168341750.980.000.000.001750.98
Diaz, Trevor, B,2051954.960.000.000.0054.96
Phillips, Haley, B,2807939.980.000.000.0039.98
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Lewis, Ethan,27998144.470.000.000.00144.47
Wilson, Emily,174002331.950.000.000.002331.95
Foster, Isabelle,2637739.980.000.000.0039.98
Baker, Eduardo,180921789.450.000.000.001789.45
Ma, Tiffany,2157739.980.000.000.0039.98
Watson, Victoria,16125588.960.000.000.00588.96
Butler, Jonathan,261804.990.000.000.004.99
Sanders, Zoe, L,248254.990.000.000.004.99
Luo, Jodi,2921368.490.000.000.0068.49
Anderson, Ryan, W,132712319.990.000.000.002319.99
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Reed, Morgan, E,2877923.970.000.000.0023.97
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Carter, Jose, H,12532235.720.000.000.00235.72
Lal, Jack, R,185251735.980.000.000.001735.98
Baker, Mason, A,132702394.950.000.000.002394.95
Gonzalez, Molly,1637021.980.000.000.0021.98
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Roberts, Noah, S,2704268.490.000.000.0068.49
Brown, Christian,227554.990.000.000.004.99
Perry, James,192051249.840.000.000.001249.84
Davis, Jonathan,2925913.980.000.000.0013.98
Butler, Jackson, J,183241735.980.000.000.001735.98
Jones, Alexander, I,2002180.960.000.000.0080.96
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Li, Brandon,2933973.960.000.000.0073.96
Collins, Eduardo,139872329.990.000.000.002329.99
Lee, Samantha, B,2737878.980.000.000.0078.98
White, Emma, N,16090604.960.000.000.00604.96
Morgan, Isabella, L,28602144.470.000.000.00144.47
Williams, Joshua,260514.990.000.000.004.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Torres, Abigail,253674.990.000.000.004.99
Prasad, Erick, E,28786127.950.000.000.00127.95
Russell, Ian, T,2474613.980.000.0013.980.00
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Watson, Janet, S,2320859.980.000.000.0059.98
Howard, Brianna, D,246304.990.000.000.004.99
Rubio, Ruben, D,1887186.960.000.0086.960.00
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Ramirez, Brian, M,116182369.960.000.002369.960.00
Ward, Kaylee, A,244154.990.000.004.990.00
Henderson, Luke,19200109.240.000.000.00109.24
Patterson, Natalie,16123629.970.000.000.00629.97
Zhang, Nathan, L,2910478.980.000.000.0078.98
Yang, Aaron, C,2519654.980.000.000.0054.98
Roberts, Robert, R,1898656.970.000.0056.970.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Perez, Amber, D,13318214.260.000.00116.9197.35
Rodriguez, Destiny, J,227397.280.000.007.280.00
Collins, Alex, S,287812.290.000.000.002.29
Hughes, Jasmine,276284.990.000.000.004.99
Henderson, Logan, C,2236656.970.000.000.0056.97
Ross, Miranda,145984839.000.000.000.004839.00
McDonald, Aaron, J,27734119.980.000.000.00119.98
Thames, Bernard,2380368.490.000.000.0068.49
Anderson, David, A,2209761.960.000.0061.960.00
Russell, Gail, L,212634.990.000.000.004.99
Allen, Allison, A,1975737.270.000.000.0037.27
Hughes, Destiny, P,28027119.980.000.000.00119.98
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Flores, Nathan, C,2463713.980.000.000.0013.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Lee, James, J,2881769.990.000.0069.990.00
Scott, Eric,282484.990.000.004.990.00
Foster, Emma,15468436.350.000.00159.99276.36
Hughes, Luis,130841798.960.000.000.001798.96
Coleman, Stephanie,2226489.970.000.000.0089.97
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Collins, Jose,2474839.980.000.0039.980.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Hall, Taylor, J,169951735.980.000.000.001735.98
Jones, Michael, A,2210771.970.000.000.0071.97
Wang, Benjamin, R,274547.280.000.000.007.28
Wang, Austin, A,1463284.970.000.009.9974.98
Nelson, Kevin,1476584.970.000.000.0084.97
Reed, Melanie, A,28160574.980.000.000.00574.98
Adams, Julia, N,2607359.980.000.000.0059.98
Edwards, Hailey,242584.990.000.000.004.99
Smith, Megan, J,2671668.970.000.000.0068.97
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Perez, Timothy, L,227304.990.000.000.004.99
James, Zoe, R,14611304.550.000.000.00304.55
Nath, Kenneth, W,170372334.970.000.000.002334.97
Sandberg, Chase,2190475.970.000.000.0075.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Roberts, Rebecca,2800094.480.000.000.0094.48
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Gonzales, Jordan,2368113.980.000.000.0013.98
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Reed, Megan, A,181181750.980.000.000.001750.98
Moreno, Lance, A,2922939.980.000.000.0039.98
Flores, Miguel,1975077.250.000.000.0077.25
Edwards, Elijah, D,281577.280.000.000.007.28
Foster, Abigail,1982346.470.000.000.0046.47
Young, Courtney,176222374.980.000.000.002374.98
Foster, Alyssa, I,14875839.480.000.000.00839.48
Alexander, Julian,132172351.960.000.000.002351.96
Alvarez, Melody,2507068.490.000.000.0068.49
Lee, Kayla, M,2078115.230.000.000.0015.23
Rogers, Bryce,174022304.980.000.000.002304.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Collins, Jonathan,16849119.980.000.000.00119.98
Hall, Wyatt,2382713.980.000.000.0013.98
Mitchell, Evan, R,247314.990.000.000.004.99
Flores, Luke, L,247337.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Bell, Chase,180911750.980.000.000.001750.98
Bryant, Dakota, L,176132401.950.000.000.002401.95
Martin, Tyler, L,2772469.990.000.000.0069.99
Jones, Alexandra, B,2020245.950.000.000.0045.95
Garcia, Kayla, L,2130881.460.000.000.0081.46
Richardson, Devin, G,2131836.960.000.000.0036.96
Rivera, Hailey, R,2079239.980.000.000.0039.98
Shan, Gabriel, T,2773169.990.000.000.0069.99
Stewart, Makayla,16649115.940.000.000.00115.94
Thomas, Jeremiah,183721760.470.000.000.001760.47
Patterson, Austin, O,270247.280.000.000.007.28
Zhang, Connor, R,138532329.980.000.000.002329.98
Walker, Jacob, N,29027574.980.000.000.00574.98
Nath, Yolanda, A,2462513.980.000.000.0013.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
White, Judith, R,148851155.480.000.000.001155.48
Srini, Evelyn,16855150.950.000.000.00150.95
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Perez, Katherine, J,2207924.270.000.000.0024.27
Kelly, Bailey, R,28284563.770.000.000.00563.77
Li, Eugene, A,15283865.950.000.000.00865.95
Hall, Jason, A,29351119.980.000.000.00119.98
Washington, Adam, G,2543713.980.000.000.0013.98
Campbell, Natalie, L,115122319.990.000.000.002319.99
_SUM1806517.5065197.22487005.99323518.76930795.53

Generated 2025-11-04 04:13:54.808 UTC