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

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Russell, Arianna,22728149.930.000.00149.930.00
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Rubio, Ruben, D,1887186.960.000.0086.960.00
Reed, Michelle,2804669.990.000.000.0069.99
Morgan, Angela,24665109.970.000.000.00109.97
Griffin, Melissa, L,287807.950.000.000.007.95
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Gray, Sebastian, B,138782366.960.000.000.002366.96
Martinez, Matthew, L,16009170.450.000.000.00170.45
Green, Xavier,2356739.980.000.000.0039.98
Hall, Jose, J,17601225.420.000.00155.4569.97
Perry, Benjamin,291652407.040.000.002407.040.00
King, Caleb, J,2898678.980.000.000.0078.98
Gray, Seth, M,2008785.480.000.000.0085.48
Ramirez, Brian, M,116182369.960.000.002369.960.00
Hill, Eric, G,2525667.930.000.0067.930.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Davis, Jonathan,2925913.980.000.000.0013.98
Ward, Kaylee, A,244154.990.000.004.990.00
Bryant, Rachel,220197.280.000.007.280.00
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Campbell, Angel, D,195461174.480.000.000.001174.48
Collins, Jonathan,16849119.980.000.000.00119.98
Robinson, William,20103103.480.000.000.00103.48
Diaz, Jason,17374206.630.000.0089.46117.17
Brooks, Allison,146054750.010.000.000.004750.01
Hall, Wyatt,2382713.980.000.000.0013.98
Cox, Devin, C,134184768.050.000.000.004768.05
Jai, Luis, A,18320185.920.000.000.00185.92
James, Emma,127812329.980.000.000.002329.98
Mitchell, Evan, R,247314.990.000.000.004.99
Lewis, Ryan, A,203124.990.000.000.004.99
Hayes, Dalton, C,188822322.280.000.000.002322.28
Henderson, Olivia,188591155.480.000.000.001155.48
Flores, Luke, L,247337.280.000.000.007.28
Sanders, Hailey,19647282.040.000.000.00282.04
Carter, Katherine,11861286.300.000.000.00286.30
Shan, Christian, L,2308439.980.000.000.0039.98
Perry, Jackson, J,213064.990.000.000.004.99
Moore, Jennifer, A,2175964.470.000.000.0064.47
Nelson, Jose,19217185.020.000.0091.9593.07
Simmons, Anna, K,124512367.920.000.000.002367.92
Martin, Kellie, R,28195574.980.000.000.00574.98
Mohamed, Samantha, A,292772419.060.000.002419.060.00
White, Tyler,14291258.440.000.0049.97208.47
Lee, Samantha, B,2737878.980.000.000.0078.98
Bell, Chase,180911750.980.000.000.001750.98
Davis, Dylan,15556588.960.000.00588.960.00
Martin, Madison, C,2049271.970.000.0071.970.00
White, Emma, N,16090604.960.000.000.00604.96
Roberts, Robert, R,1898656.970.000.0056.970.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Robinson, Sarah, A,2702859.980.000.000.0059.98
Simmons, Adam,253274.990.000.000.004.99
Lopez, Bailey, R,185571179.470.000.001179.470.00
Alexander, Gavin, K,2932249.990.000.000.0049.99
Butler, Morgan, E,2050068.490.000.000.0068.49
Ross, Kelly,2607676.960.000.000.0076.96
Rodriguez, Destiny, J,227397.280.000.007.280.00
Allen, Madeline,2924068.970.000.000.0068.97
Zeng, Jake,18054106.930.000.000.00106.93
Patterson, Aaron, W,191131184.460.000.000.001184.46
Collins, Alex, S,287812.290.000.000.002.29
Long, Rachel,2828339.980.000.000.0039.98
Ross, Alexia, S,13231247.900.000.000.00247.90
Morgan, Isabella, L,28602144.470.000.000.00144.47
Hughes, Jasmine,276284.990.000.000.004.99
Flores, Brittany,169062359.980.000.000.002359.98
Butler, Trevor,2741569.990.000.0069.990.00
Stewart, Garrett, O,15762564.480.000.000.00564.48
Henderson, Logan, C,2236656.970.000.000.0056.97
Williams, Destiny, S,15881564.990.000.00564.990.00
Wood, Gavin,16964108.540.000.0093.5614.98
Foster, Caleb,27112114.460.000.000.00114.46
Jones, Alexandra, B,2020245.950.000.000.0045.95
Diaz, Alyssa,139084715.330.000.000.004715.33
Alexander, Elijah,11738331.680.000.00141.73189.95
Luo, Donna, E,248054.990.000.000.004.99
Garcia, Kayla, L,2130881.460.000.000.0081.46
Barnes, Jeremy,2144654.980.000.000.0054.98
Shan, Logan,1867760.960.000.0029.9930.97
Roberts, Hunter,282607.280.000.000.007.28
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Coleman, Miguel, D,2740069.990.000.0069.990.00
Perry, Lauren,248164.990.000.000.004.99
Anderson, David, A,2209761.960.000.0061.960.00
Ramirez, Emma,29072128.970.000.000.00128.97
Hall, Natalie, A,230704.990.000.004.990.00
Bradley, Nathaniel,169551760.470.000.000.001760.47
Shan, Gabriel, T,2773169.990.000.000.0069.99
Campbell, Timothy,2584513.980.000.000.0013.98
Barnes, Haley, J,2133939.980.000.0039.980.00
Price, Rachel, D,2532889.970.000.000.0089.97
Li, Kevin, S,2518813.980.000.000.0013.98
Nelson, James, L,245257.280.000.007.280.00
Wright, Jennifer,2650559.980.000.0059.980.00
Long, Elizabeth, F,127822400.950.000.000.002400.95
Brown, Anthony, J,19399151.430.000.000.00151.43
Hernandez, Sierra,27393123.980.000.00123.980.00
Evans, Maria,22544127.280.000.00127.280.00
Cook, Joan,235544.990.000.000.004.99
Morgan, Isaiah,18978118.730.000.000.00118.73
Gray, Mariah,222787.280.000.007.280.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Long, Chloe,167841735.980.000.000.001735.98
Chen, David,2720839.980.000.000.0039.98
Robinson, Ian, D,138522294.990.000.000.002294.99
Richardson, Lauren, C,14867839.480.000.000.00839.48
Campbell, Gabriella,188411145.480.000.000.001145.48
Collins, Charles, B,29041628.450.000.000.00628.45
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Wang, Zachary,2214489.970.000.000.0089.97
Lee, James, J,2881769.990.000.0069.990.00
Russell, Katherine,2877169.990.000.000.0069.99
Stewart, Alex, M,2008463.150.000.000.0063.15
Scott, Eric,282484.990.000.004.990.00
Moore, Jonathan,2047896.460.000.000.0096.46
Butler, Cassidy, L,21792114.460.000.000.00114.46
Foster, Emma,15468436.350.000.00159.99276.36
Price, Mariah, C,2074549.480.000.000.0049.48
Howard, Erin, L,183621725.210.000.000.001725.21
Collins, Jose,2474839.980.000.0039.980.00
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Taylor, Christian,2076456.760.000.000.0056.76
Rodriguez, Julia, A,264884.990.000.004.990.00
Phillips, Devin,18759112.060.000.000.00112.06
Smith, Justin, P,1982721.980.000.000.0021.98
Thomas, Jeremiah,183721760.470.000.000.001760.47
Peterson, Christina,2897694.480.000.000.0094.48
Jackson, Hannah, G,131432404.970.000.000.002404.97
Patterson, Austin, O,270247.280.000.000.007.28
Washington, Victoria,235577.280.000.000.007.28
Moore, Ian, L,2463939.980.000.000.0039.98
Zhang, Connor, R,138532329.980.000.000.002329.98
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Washington, Hannah, A,291307.280.000.007.280.00
Flores, Julian,158464943.320.000.000.004943.32
Simmons, David, E,120172339.970.000.002339.970.00
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Walker, Jacob, N,29027574.980.000.000.00574.98
Moore, Chloe, L,2626913.980.000.000.0013.98
Alexander, Paige, W,1860459.250.000.0037.2721.98
Adams, Kyle, E,1881269.990.000.0069.990.00
Harris, Samantha, A,244874.990.000.000.004.99
Moore, Logan,2634889.970.000.0089.970.00
Anderson, Daniel,20694146.970.000.00146.970.00
Washington, Hailey, S,2588559.980.000.000.0059.98
Hernandez, Jamie,27283119.980.000.00119.980.00
Srini, Evelyn,16855150.950.000.000.00150.95
Watson, Erin, B,227724.990.000.004.990.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Foster, Nicole, A,2349489.970.000.000.0089.97
Smith, Nathan,217647.280.000.007.280.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Howard, Danielle,28357133.490.000.000.00133.49
Van, Bobby,27757132.970.000.00132.970.00
Nath, Carl, H,29001624.970.000.000.00624.97
Richardson, Charles, I,121144719.020.000.002325.962393.06
She, Shawn, J,16902141.980.000.000.00141.98
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Flores, Miguel,1975077.250.000.000.0077.25
Yuan, Leonard, F,167911729.970.000.000.001729.97
Ramirez, Sydney,267007.280.000.000.007.28
Edwards, Elijah, D,281577.280.000.000.007.28
Henderson, Justin, P,235917.280.000.000.007.28
Williams, Edward, D,14274121.560.000.000.00121.56
Sharma, Kathryn,20740140.940.000.000.00140.94
Clark, Destiny, L,28600119.980.000.000.00119.98
Hernandez, Haley, L,11769478.950.000.000.00478.95
Stewart, Amanda, M,1531094.440.000.000.0094.44
Henderson, Abigail,2044139.980.000.000.0039.98
Scott, Haley,13701154.540.000.000.00154.54
Young, Courtney,176222374.980.000.000.002374.98
King, Gabrielle,263504.990.000.000.004.99
He, Micah,2740169.990.000.000.0069.99
Ross, Miranda,145984839.000.000.000.004839.00
Williams, Austin,2035432.220.000.000.0032.22
Martin, Brandon, S,2169139.980.000.000.0039.98
McDonald, Aaron, J,27734119.980.000.000.00119.98
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Thames, Bernard,2380368.490.000.000.0068.49
Kennedy, Bridget,2202639.980.000.000.0039.98
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Brown, Fernando,1900191.950.000.0069.9721.98
Alexander, Julian,132172351.960.000.000.002351.96
Phillips, Luis, G,207347.280.000.000.007.28
Foster, Samuel, M,18523160.940.000.00128.9731.97
Alvarez, Melody,2507068.490.000.000.0068.49
Thompson, Brianna, X,1864269.970.000.000.0069.97
Bryant, Gabriel,2765669.990.000.000.0069.99
Lee, Kayla, M,2078115.230.000.000.0015.23
Martin, Thomas, A,169521735.980.000.000.001735.98
Walker, Jasmine,134604693.040.000.000.004693.04
Rogers, Bryce,174022304.980.000.000.002304.98
Ruiz, Philip,1807781.460.000.000.0081.46
Morgan, Evan, G,14725318.830.000.0069.97248.86
Sanders, Mason, G,2345939.980.000.000.0039.98
Ward, Natalie, J,132412325.960.000.000.002325.96
Rubio, Javier, E,1972664.240.000.0064.240.00
Russell, Gail, L,212634.990.000.000.004.99
Prasad, Summer, M,2214339.980.000.0039.980.00
Bryant, Dakota, L,176132401.950.000.000.002401.95
Taylor, Lucas, V,115232376.960.000.002376.960.00
Martin, Tyler, L,2772469.990.000.000.0069.99
Price, Devin, M,18758158.510.000.0073.5584.96
Richardson, Devin, G,2131836.960.000.000.0036.96
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Rivera, Hailey, R,2079239.980.000.000.0039.98
Perez, Savannah, J,17036176.950.000.0056.97119.98
Hughes, Luis,130841798.960.000.000.001798.96
Reed, Kaylee, R,17371151.920.000.000.00151.92
Coleman, Stephanie,2226489.970.000.000.0089.97
Sara, Ivan, L,2509067.930.000.000.0067.93
Adams, Jennifer,153624745.020.000.000.004745.02
Hughes, Isabella,2304851.460.000.000.0051.46
Hall, Taylor, J,169951735.980.000.000.001735.98
Robinson, Joseph,2814194.480.000.0094.480.00
Jones, Michael, A,2210771.970.000.000.0071.97
Walker, Ian,16771104.550.000.0054.5849.97
Wang, Benjamin, R,274547.280.000.000.007.28
Foster, Edward, R,18355150.950.000.000.00150.95
Bradley, Evan,18506101.940.000.000.00101.94
Jackson, Brianna,1537797.910.000.0074.9822.93
Nath, Yolanda, A,2462513.980.000.000.0013.98
Turner, James, E,16841126.960.000.0069.9956.97
Diaz, Gabrielle,14893839.480.000.000.00839.48
Diaz, Brandon,236764.990.000.004.990.00
White, Judith, R,148851155.480.000.000.001155.48
Ward, Destiny,16128539.990.000.000.00539.99
Walker, Destiny, M,169961754.980.000.000.001754.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Clark, Zachary, J,2389358.980.000.000.0058.98
Ward, Eduardo, I,139162354.980.000.000.002354.98
Perez, Katherine, J,2207924.270.000.000.0024.27
Lal, Kyle,17360122.180.000.000.00122.18
Li, Eugene, A,15283865.950.000.000.00865.95
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Hall, Jason, A,29351119.980.000.000.00119.98
Young, Kaylee, S,13756298.490.000.0058.47240.02
Cooper, Brooke,195361120.490.000.000.001120.49
Ramirez, Richard, C,282397.280.000.007.280.00
Foster, Jose, C,2878534.990.000.000.0034.99
Hayes, Carson, A,124472331.950.000.000.002331.95
Carter, Jonathan,14578848.470.000.000.00848.47
Hall, Lauren, A,19648100.840.000.000.00100.84
Sanders, Lucas, W,268024.990.000.000.004.99
Bell, Danielle,140414765.020.000.000.004765.02
Miller, Destiny,251577.280.000.000.007.28
Price, Riley, R,139094764.020.000.000.004764.02
Murphy, Brianna, K,2834269.990.000.000.0069.99
Hall, Noah, A,1525175.250.000.000.0075.25
Miller, Jill,129142329.980.000.000.002329.98
Diaz, Thomas, O,16020595.960.000.000.00595.96
Ross, David, M,171431763.970.000.000.001763.97
Blanco, Armando, F,139182397.950.000.000.002397.95
Anderson, Madison, G,2835978.980.000.000.0078.98
Johnson, Madison, L,15530846.460.000.000.00846.46
Turner, Mary,220154.990.000.000.004.99
Thomas, David,168363193.790.000.000.003193.79
Nelson, Katherine,2802178.980.000.000.0078.98
Perez, Charles,266937.280.000.007.280.00
Nath, Alison, J,171161764.960.000.000.001764.96
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Hughes, Austin, P,183681754.980.000.000.001754.98
Griffin, James,28189567.760.000.000.00567.76
Gonzales, Kayla,214947.280.000.000.007.28
Cooper, Andrea,2932378.980.000.000.0078.98
Roberts, Wyatt,15900699.970.000.00699.970.00
Lewis, Brandon, A,2903769.990.000.000.0069.99
Wilson, Daniel, K,142814746.300.000.000.004746.30
Gonzales, Gavin,2448813.980.000.000.0013.98
Martin, Christian, V,19709197.250.000.000.00197.25
Mitchell, Bailey, B,267067.280.000.007.280.00
Alexander, Jason,2932849.990.000.000.0049.99
Rivera, Rachel, S,2899678.980.000.000.0078.98
Parker, Caleb, A,2631813.980.000.000.0013.98
Hayes, Hannah, J,2165656.970.000.000.0056.97
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Harris, Joshua, L,2028095.940.000.0030.9764.97
White, Emily, M,159174679.060.000.000.004679.06
Kapoor, Preston,2143156.970.000.000.0056.97
Williams, Sydney, J,15334848.470.000.000.00848.47
Kelly, Julia,2379867.930.000.0067.930.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Flores, Eduardo, S,2896962.980.000.000.0062.98
Brooks, Ian, W,2829064.470.000.000.0064.47
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Clark, Emily, R,120862294.990.000.000.002294.99
Watson, Marcus,2271585.480.000.000.0085.48
Moore, Anthony, M,2473039.980.000.000.0039.98
Flores, Madison,14416769.490.000.000.00769.49
Adams, Katherine, M,235184.990.000.000.004.99
Kumar, Cameron, S,185711120.490.000.001120.490.00
Robinson, Lauren,2719668.490.000.0068.490.00
Peterson, Melissa, S,249954.990.000.004.990.00
Martin, Joshua, A,276077.280.000.007.280.00
Perry, Eric,18314115.730.000.0056.9758.76
Moore, Jessica, J,2008576.760.000.000.0076.76
Perry, Justin, E,167583062.340.000.000.003062.34
Hill, Timothy,14871848.470.000.000.00848.47
Cox, Sara, P,2775869.990.000.0069.990.00
Barnes, Kayla,2425639.980.000.0039.980.00
Jenkins, Dakota, D,2067964.470.000.0064.470.00
Shan, Chad, M,2462112.940.000.000.0012.94
Torres, Xavier,16840176.950.000.000.00176.95
Green, Mackenzie, C,280737.280.000.000.007.28
Gray, Jared, A,264494.990.000.000.004.99
Srini, Ruben,18078200.940.000.000.00200.94
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Reed, Isaac, D,260747.280.000.000.007.28
Carter, Jesse, E,22141166.280.000.000.00166.28
Henderson, Hailey, C,171481775.470.000.000.001775.47
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Green, Eric,2738069.990.000.000.0069.99
Hill, Katherine, L,2670139.980.000.000.0039.98
Davis, Austin, E,133664749.040.000.000.004749.04
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
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Bryant, Jackson, J,2533239.980.000.000.0039.98
Chen, Ethan,2054756.970.000.000.0056.97
Patterson, Abigail, H,144784795.010.000.000.004795.01
Simmons, Nicole, S,2617729.480.000.000.0029.48
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
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Scott, Allison,14497804.480.000.000.00804.48
Ashe, Alexis, S,194141145.480.000.000.001145.48
Russell, Chloe, M,12763589.960.000.000.00589.96
Sanchez, Stephanie,1786756.970.000.000.0056.97
Brooks, Evan,2340139.980.000.000.0039.98
Jackson, Victoria,270194.990.000.000.004.99
Walker, Richard, T,19640224.550.000.000.00224.55
Baker, Allison,2649558.980.000.000.0058.98
Washington, Aaron, L,246494.990.000.000.004.99
Thomas, Ian,191181120.490.000.000.001120.49
Edwards, Hunter,2422067.930.000.000.0067.93
Patterson, Eric, A,2738478.980.000.000.0078.98
White, James,253317.280.000.000.007.28
Gonzalez, Morgan,130651700.990.000.000.001700.99
Flores, Gabriel,271117.280.000.000.007.28
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
Evans, Elijah, S,2588439.980.000.000.0039.98
Gonzales, Jose,2201439.980.000.000.0039.98
Ward, Mariah, J,2158044.910.000.000.0044.91
Wang, Karen, P,1955331.970.000.000.0031.97
Bennett, Brittany, J,2233239.980.000.000.0039.98
Andersen, Latoya, J,290578.990.000.000.008.99
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
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
Raje, Mindy, A,16083561.970.000.000.00561.97
Edwards, Amber, B,2051776.970.000.000.0076.97
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Johnson, Ian, E,2173283.470.000.000.0083.47
Sanchez, Shelby,16021539.990.000.000.00539.99
Foster, Paige,2742894.480.000.000.0094.48
Washington, Emma,191231170.480.000.000.001170.48
Flores, Cassidy, L,233684.990.000.000.004.99
King, Sara,2235439.980.000.000.0039.98
Chandra, Allen,2932753.990.000.000.0053.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Harris, Anthony,2144721.980.000.000.0021.98
_SUM1806517.5065197.22487005.99323518.76930795.53

Generated 2025-11-04 06:21:54.241 UTC