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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Ward, Natalie, J,132412325.960.000.000.002325.96
Alexander, Jordan,2141259.980.000.0059.980.00
Gray, Jesse,14626197.040.000.000.00197.04
Suarez, Juan, R,167631700.990.000.000.001700.99
Patterson, Abigail, H,144784795.010.000.000.004795.01
Ross, Jose,2744178.980.000.0078.980.00
Simmons, James,198844588.450.003399.990.001188.46
Prasad, Molly,243924329.610.003578.270.00751.34
Lewis, Morgan,17410168.740.000.000.00168.74
Washington, Hannah, A,291307.280.000.007.280.00
Green, Gabrielle, M,2181564.470.000.000.0064.47
Kelly, Haley,15511128.560.000.000.00128.56
Hughes, Edward,200234530.470.003374.990.001155.48
Cooper, Angela,195261179.470.000.000.001179.47
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Perez, Angel, S,213362628.350.000.002071.42556.93
Ross, Natalie, J,12916261.220.000.000.00261.22
Barnes, Ian, M,16106133.540.000.000.00133.54
Long, Jordan,199884555.470.003399.990.001155.48
Kelly, Angel, E,15418232.230.000.000.00232.23
Torres, Mariah,16380195.950.000.000.00195.95
Thomas, Edward, E,19147133.710.000.000.00133.71
Morris, Chase, F,26789699.100.00699.100.000.00
Phillips, James, G,16846180.950.000.00123.9856.97
Price, Caroline,180511735.980.000.000.001735.98
Bailey, Olivia,238924.990.000.000.004.99
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Stewart, Destiny,13144281.470.000.00134.98146.49
Baker, Eduardo,180921789.450.000.000.001789.45
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Flores, Megan, N,230746021.820.003578.270.002443.55
Reed, Marcus,14582111.790.000.0014.9896.81
Price, Lauren, J,14079184.740.000.0037.29147.45
Griffin, Jordan,13095328.890.000.0069.97258.92
Foster, Eric,229765971.330.003578.270.002393.06
Smith, Lucas, P,1809064.910.000.000.0064.91
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Ramirez, Brian, M,116182369.960.000.002369.960.00
Ortega, Byron,233064828.110.003578.270.001249.84
Williams, Edward, D,14274121.560.000.000.00121.56
Patterson, Eduardo,11142866.810.000.0072.26794.55
Bell, Timothy, J,2810178.980.000.0078.980.00
Griffin, Maria,1840763.250.000.000.0063.25
Johnson, Anthony, D,270224.990.000.000.004.99
Mitchell, Evan, R,247314.990.000.000.004.99
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Diaz, Elijah,200004495.480.003374.990.001120.49
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Griffin, Seth, R,17585164.460.000.0078.9885.48
Lobao, Alexandre,1892691.950.000.0091.950.00
Shan, Benjamin,235663578.270.003578.270.000.00
Walker, Isabella,243864143.740.003578.27565.470.00
Taylor, Taylor,159054899.020.000.000.004899.02
Patterson, Eric, A,2738478.980.000.000.0078.98
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Baker, Sean, T,247782858.490.002181.56676.930.00
Nath, Carl, H,29001624.970.000.000.00624.97
Roberts, Carlos,2319639.980.000.000.0039.98
Garcia, Cameron,186411120.490.000.000.001120.49
Long, Caleb, P,250462181.560.002181.560.000.00
Perry, Jackson, J,213064.990.000.000.004.99
Xu, Louis,2010466.530.000.0066.530.00
Bryant, Connor,238424828.110.003578.270.001249.84
Garcia, Carmen, J,247812181.560.002181.560.000.00
Turner, Sean,227324133.240.003578.270.00554.97
Hill, Carlos,12919257.880.000.00158.9398.95
White, Cameron,238304802.110.003578.270.001223.84
Green, Sophia, E,249772181.560.002181.560.000.00
Bell, Chase,180911750.980.000.000.001750.98
Gonzalez, Morgan,130651700.990.000.000.001700.99
Foster, Olivia,238063578.270.003578.270.000.00
Thomas, Charles,250942443.350.002443.350.000.00
Brooks, Steven, C,14877889.470.000.000.00889.47
Jones, Natalie, A,11845197.200.000.0082.26114.94
Long, Kaitlyn,233964891.610.003578.270.001313.34
Gray, Brianna,249603008.820.002443.35565.470.00
Hayes, Brittany,13941286.820.000.000.00286.82
Parker, Katherine,13268289.700.000.0068.97220.73
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Sanders, Paige,252872983.340.002443.350.00539.99
Henderson, Ashley,111851381.370.000.00232.801148.57
Flores, Gabriel,271117.280.000.000.007.28
Campbell, Evan, W,243424828.110.003578.270.001249.84
Jai, Adam,250952443.350.002443.350.000.00
Edwards, Elijah, D,281577.280.000.000.007.28
Hughes, Luis,130841798.960.000.000.001798.96
Martinez, Jill,242354829.390.003578.270.001251.12
White, Jennifer, S,27027782.990.00782.990.000.00
Thompson, Xavier, R,15761192.410.000.000.00192.41
Richardson, Evan, J,15488165.300.000.000.00165.30
Sanders, Xavier,1672173.750.000.000.0073.75
Gray, Alexandria, E,253632443.350.002443.350.000.00
Collins, Luis, J,227655978.610.003578.270.002400.34
Brown, Dylan, J,124492351.960.000.000.002351.96
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Murphy, Dalton, N,27043782.990.00782.990.000.00
Perez, Dalton,110911125.360.000.00213.86911.50
Rubio, Javier, E,1972664.240.000.0064.240.00
Perry, Jonathan, T,27026699.100.00699.100.000.00
Cox, Lucas, J,253932443.350.002443.350.000.00
Sanchez, Stephanie,1786756.970.000.000.0056.97
Martinez, Joseph, E,2921459.980.000.0059.980.00
Allen, Aaron, A,200753399.990.003399.990.000.00
Blanco, Randall,263211554.410.000.001000.44553.97
Turner, Morgan,11823178.470.000.000.00178.47
Anderson, David, A,2209761.960.000.0061.960.00
Patterson, Maria, G,1333094.950.000.000.0094.95
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Smith, Katherine, J,13197105.190.000.000.00105.19
Flores, Emily,13206163.190.000.0069.9793.22
Yang, Thomas, A,14108839.480.000.000.00839.48
Hughes, Isabella,2304851.460.000.000.0051.46
Brooks, Evan,2340139.980.000.000.0039.98
Morris, Jessica,289678.990.000.008.990.00
Long, Morgan, H,213522625.390.000.002071.42553.97
Li, Kevin, S,2518813.980.000.000.0013.98
Butler, Isabel,16241126.960.000.000.00126.96
Taylor, Tyler, A,12032614.960.000.00614.960.00
Watson, Emma,17481126.940.000.000.00126.94
Brown, Anthony, J,19399151.430.000.000.00151.43
Gonzalez, Molly,1637021.980.000.000.0021.98
Jackson, Brianna,1537797.910.000.0074.9822.93
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Lewis, Brandon, A,2903769.990.000.000.0069.99
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Green, Xavier,2356739.980.000.000.0039.98
Parker, Natalie, A,251043018.330.002443.350.00574.98
Barnes, Jeremy,2144654.980.000.000.0054.98
Diaz, Luis, D,11203801.770.000.00183.97617.80
Baker, Isaiah,12106169.540.000.000.00169.54
Lopez, Carlos,186171147.770.000.000.001147.77
Price, Jeremy,259892744.520.000.002181.56562.96
Roberts, Noah, S,2704268.490.000.000.0068.49
Morgan, Juan, C,1882191.970.000.000.0091.97
Murphy, Shelby,244894.990.000.000.004.99
Cooper, Christina, C,265121000.440.000.001000.440.00
Hughes, Zachary,12203157.910.000.000.00157.91
Green, Marcus, C,15974208.410.000.0091.95116.46
Watson, Olivia, S,1386093.850.000.0014.9878.87
Cox, Julia, A,206703228.570.000.002049.101179.47
Perry, Christian,246714354.600.003578.270.00776.33
Rogers, Andrea, L,14328308.660.000.00112.95195.71
Anderson, Emma, A,185801170.480.000.000.001170.48
Diaz, Hunter, S,27242782.990.000.00782.990.00
Shan, Gabriel, T,2773169.990.000.000.0069.99
Robinson, Joseph,2814194.480.000.0094.480.00
Wright, Jackson,11698225.950.000.000.00225.95
Stewart, Andrea, M,27252782.990.000.00782.990.00
Butler, Jonathan,261804.990.000.000.004.99
Johnson, Xavier, R,2325539.980.000.0039.980.00
Yuan, Carly,19839194.960.000.000.00194.96
Butler, Ana,260403018.330.000.002443.35574.98
Gray, Cody, C,144594775.010.000.000.004775.01
Walker, Ian,16771104.550.000.0054.5849.97
Gonzales, Luis,15856116.250.000.0037.2778.98
Thompson, Devin,207084406.400.000.002071.422334.98
Russell, Samuel, V,11652310.930.000.000.00310.93
Campbell, Angel, D,195461174.480.000.000.001174.48
King, Aaron, L,117394758.030.000.002359.982398.05
Phillips, Kaylee,211384371.380.000.002049.102322.28
Russell, Oscar, A,12140118.170.000.000.00118.17
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Carter, Bailey,213322616.860.000.002616.860.00
Ward, Ian,12056213.920.000.000.00213.92
Adams, Jennifer,153624745.020.000.000.004745.02
Thomas, Samantha,2169093.970.000.000.0093.97
Campbell, Adam, A,214002688.890.000.002071.42617.47
Evans, James, C,206654408.560.000.002049.102359.46
Taylor, Edward, C,17442319.880.000.00230.9088.98
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Jones, Zachary, J,27285782.990.000.00782.990.00
Thomas, Jeremiah,183721760.470.000.000.001760.47
Nelson, Jose,19217185.020.000.0091.9593.07
Reed, Catherine, M,203807.280.000.000.007.28
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Reed, Michelle,2804669.990.000.000.0069.99
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Turner, Blake,12136131.740.000.000.00131.74
Kelly, Bryan,213492989.380.000.002989.380.00
Rogers, Sean, G,18685124.460.000.000.00124.46
Diaz, Brandon,236764.990.000.004.990.00
Ross, Alexia, S,13231247.900.000.000.00247.90
Luo, Franklin, J,2202759.980.000.000.0059.98
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Stewart, Melissa,2517336.960.000.000.0036.96
Ramirez, Sydney,267007.280.000.000.007.28
Hall, Jan, M,11740334.120.000.00235.1598.97
Johnson, Madison, L,15530846.460.000.000.00846.46
Torres, Victoria,17551160.920.000.000.00160.92
Hernandez, Haley, L,11769478.950.000.000.00478.95
Edwards, Angel, J,2912469.990.000.000.0069.99
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Simmons, Anna, K,124512367.920.000.000.002367.92
Harris, Emily, P,1986298.480.000.000.0098.48
Carter, Katherine,11861286.300.000.000.00286.30
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Martin, Samuel,15874225.440.000.0069.99155.45
Smith, Alexandra,2829261.960.000.000.0061.96
Clark, Emily, R,120862294.990.000.000.002294.99
Srini, Evelyn,16855150.950.000.000.00150.95
James, Maria,1624391.970.000.0069.9921.98
Edwards, Connor,16950211.010.000.000.00211.01
Rodriguez, Richard,12969180.790.000.000.00180.79
White, Miguel, S,13988195.520.000.000.00195.52
Hill, Eric, G,2525667.930.000.0067.930.00
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Moreno, Marie,2773969.990.000.000.0069.99
Flores, Emma, P,15543180.940.000.000.00180.94
Bryant, Rachel,220197.280.000.007.280.00
Murphy, Juan, T,246463578.270.003578.270.000.00
Taylor, Natalie, M,14338828.740.000.000.00828.74
Lee, Kayla, M,2078115.230.000.000.0015.23
Li, Jordan,17026261.390.000.00261.390.00
Li, Connor,201863191.910.002071.420.001120.49
Martin, John, A,144364776.010.000.000.004776.01
Collins, Hailey,11709325.890.000.0021.49304.40
Wang, Austin, A,1463284.970.000.009.9974.98
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Parker, Kaylee, M,2773878.980.000.000.0078.98
Simmons, Adam,253274.990.000.000.004.99
Turner, Andrea, A,202093268.550.002049.100.001219.45
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Srini, Ruben,18078200.940.000.0071.97128.97
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Martin, Morgan,248322181.560.002181.560.000.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Perry, Dalton, A,16149192.040.000.000.00192.04
Richardson, Charles, I,121144719.020.000.002325.962393.06
Lazecky, Petr,258642443.350.002443.350.000.00
Lal, Caleb, R,1586874.460.000.000.0074.46
Jones, Alexander, I,2002180.960.000.000.0080.96
Perez, Charles,266937.280.000.007.280.00
Carter, Luis, E,258832443.350.002443.350.000.00
Foster, Kayla,1969371.950.000.000.0071.95
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Davis, Dylan,15556588.960.000.00588.960.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Ward, Stephanie, A,27429782.990.000.00782.990.00
Ross, Antonio,18322148.890.000.000.00148.89
Alexander, Angelica,2271471.950.000.000.0071.95
Young, Savannah,259712749.320.002181.560.00567.76
Winston, Ethan, R,216222612.060.000.002049.10562.96
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Foster, Caleb,27112114.460.000.000.00114.46
Williams, Morgan, C,203733226.900.002071.420.001155.48
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Gomez, Briana, A,2878443.980.000.000.0043.98
Thompson, Kayla, D,12363273.900.000.0049.97223.93

Generated 2025-10-31 21:09:08.921 UTC