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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Phillips, Jack, R,259952443.350.000.002443.350.00
Stewart, Garrett, O,15762564.480.000.000.00564.48
White, Christopher, R,260492181.560.000.002181.560.00
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Butler, Ana,260403018.330.000.002443.35574.98
Diaz, Faith, M,2236356.970.000.000.0056.97
Thompson, Devin,207084406.400.000.002071.422334.98
Walker, Richard, T,19640224.550.000.000.00224.55
Washington, Taylor,212664525.070.000.002049.102475.97
Sanchez, Shelby,16021539.990.000.000.00539.99
Patterson, Alexis,213484392.020.000.002049.102342.92
Deng, Wayne,2145336.960.000.0036.960.00
Collins, Connor, J,27270782.990.000.00782.990.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Wright, Jackson,11698225.950.000.000.00225.95
Peterson, Mason, A,185701174.480.000.001174.480.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Evans, Alexandra,2432268.490.000.000.0068.49
Gonzales, Luis,15856116.250.000.0037.2778.98
Perez, Timothy, L,227304.990.000.000.004.99
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Roberts, Hunter,282607.280.000.000.007.28
Ward, Stephanie, A,27429782.990.000.00782.990.00
Foster, Paige,2742894.480.000.000.0094.48
King, Aaron, L,117394758.030.000.002359.982398.05
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Isla, Julian, A,13732108.960.000.004.99103.97
Mitchell, Bailey, B,267067.280.000.007.280.00
Bailey, Mariah, L,2724354.980.000.000.0054.98
Ward, Natalie, J,132412325.960.000.000.002325.96
Thomas, William, A,216142589.090.000.002049.10539.99
Washington, Emma,191231170.480.000.000.001170.48
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Price, Rachel, D,2532889.970.000.000.0089.97
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Harris, Joshua, L,2028095.940.000.0030.9764.97
Washington, Alexia,27613782.990.000.00782.990.00
Brooks, Steven, C,14877889.470.000.000.00889.47
Bryant, Zachary,216552648.070.000.002648.070.00
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Washington, Riley, L,185441155.480.000.001155.480.00
Edwards, Elijah, D,281577.280.000.000.007.28
Robinson, Sarah, A,2702859.980.000.000.0059.98
Gill, Robyn, J,127651750.980.000.001750.980.00
Zeng, Jake,18054106.930.000.000.00106.93
Anderson, Tyler, E,131481137.430.000.001137.430.00
Turner, Blake,12136131.740.000.000.00131.74
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Sharma, Jackson,16876151.840.000.000.00151.84
Miller, Jill,129142329.980.000.000.002329.98
Nelson, Sierra,161322459.620.000.002459.620.00
Harris, Noah,292562393.060.000.002393.060.00
Diaz, Jason,17374206.630.000.0089.46117.17
Chandra, Allen,2932753.990.000.000.0053.99
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Nelson, Katherine,2802178.980.000.000.0078.98
Nelson, Jordan, H,201304.990.000.004.990.00
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Martin, Madison, C,2049271.970.000.0071.970.00
Watson, Erin, B,227724.990.000.004.990.00
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Smith, Eduardo,2069139.980.000.0039.980.00
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Van, Bobby,27757132.970.000.00132.970.00
Shan, Logan,1867760.960.000.0029.9930.97
Powell, Sydney, M,14886539.990.000.00539.990.00
Wright, Jennifer,2650559.980.000.0059.980.00
Wang, Zachary,2214489.970.000.000.0089.97
Cooper, Brianna,2592513.980.000.000.0013.98
Srini, Ruben,18078200.940.000.0071.97128.97
Coleman, Joan, W,2669964.470.000.000.0064.47
Hughes, Antonio, P,15913712.270.000.00712.270.00
Parker, Morgan, S,1677236.960.000.0014.9821.98
Sanchez, Katherine, S,24399132.940.000.00132.940.00
Hughes, Justin, M,181222439.990.000.000.002439.99
Brooks, Evan,2340139.980.000.000.0039.98
Stewart, Julia, L,129022329.980.000.000.002329.98
Jackson, Victoria,270194.990.000.000.004.99
Perez, Jordan, A,292674.990.000.000.004.99
Alvarez, Melody,2507068.490.000.000.0068.49
Powell, Lauren, E,1966275.970.000.000.0075.97
Scott, Mason,2355139.980.000.000.0039.98
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Sanders, Mason, G,2345939.980.000.000.0039.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Jones, Joshua,184012294.990.000.000.002294.99
Stewart, Marcus, R,2063221.980.000.000.0021.98
Washington, Miranda,152014793.020.000.000.004793.02
Martin, Tyler, L,2772469.990.000.000.0069.99
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Allen, Mason,176252431.950.000.000.002431.95
Washington, Robert, J,14906143.950.000.000.00143.95
Ortega, Sheila, M,2763239.980.000.000.0039.98
Robinson, William,20103103.480.000.000.00103.48
Nath, Yolanda, A,2462513.980.000.000.0013.98
Hall, Noah, A,1525175.250.000.000.0075.25
White, Judith, R,148851155.480.000.000.001155.48
Lewis, Ryan, A,203124.990.000.000.004.99
Davis, Jonathan,2925913.980.000.000.0013.98
Bryant, Nathan,2145059.980.000.000.0059.98
Perez, Katherine, J,2207924.270.000.000.0024.27
Hall, Kyle, J,1749169.970.000.000.0069.97
Lee, Samantha, B,2737878.980.000.000.0078.98
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Morgan, Isabella, L,28602144.470.000.000.00144.47
Davis, Marcus, T,17337123.910.000.0086.9536.96
Simmons, Jose,2464739.980.000.000.0039.98
Lewis, Brandon, A,2903769.990.000.000.0069.99
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Wilson, Daniel, K,142814746.300.000.000.004746.30
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Luo, Franklin, J,2202759.980.000.000.0059.98
Hall, Jan, M,11740334.120.000.00235.1598.97
Butler, Benjamin, C,189722369.970.000.000.002369.97
Parker, Caleb, A,2631813.980.000.000.0013.98
Adams, Kyle, E,1881269.990.000.0069.990.00
Hayes, Hannah, J,2165656.970.000.000.0056.97
Blue, Melanie, L,178611749.960.000.000.001749.96
Collins, Isaac,260777.280.000.000.007.28
James, Richard, D,15760109.230.000.003.99105.24
Thomas, David,168363193.790.000.000.003193.79
Rivera, Amanda,11131115.920.000.000.00115.92
Harris, Samuel, M,2477159.980.000.0059.980.00
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Smith, Zachary, W,2378358.980.000.0058.980.00
Cox, Arianna, D,1892789.250.000.000.0089.25
Morris, Mason, J,22349124.990.000.000.00124.99
Ward, Emma, W,2179659.980.000.000.0059.98
Scott, Allison,14497804.480.000.000.00804.48
Ashe, Alexis, S,194141145.480.000.000.001145.48
Green, Kaylee, C,2618567.970.000.000.0067.97
Russell, Chloe, M,12763589.960.000.000.00589.96
Hayes, Dalton, C,188822322.280.000.000.002322.28
Foster, Carson, L,16959135.350.000.00120.3714.98
Hill, Timothy,14871848.470.000.000.00848.47
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Howard, Erin, L,183621725.210.000.000.001725.21
Foster, Isabelle,2637739.980.000.000.0039.98
Ma, Tiffany,2157739.980.000.000.0039.98
Henderson, Abigail,2044139.980.000.000.0039.98
Jones, Charles,22882101.450.000.000.00101.45
Carter, Jesse, E,22141166.280.000.000.00166.28
Collins, Jonathan,16849119.980.000.000.00119.98
Stewart, Gabriella,2803469.990.000.000.0069.99
Taylor, Taylor,159054899.020.000.000.004899.02
Jones, Alexandra, B,2020245.950.000.000.0045.95
Chen, Jack, E,17579151.430.000.000.00151.43
Cooper, Angela,195261179.470.000.000.001179.47
Thomas, Ian,191181120.490.000.000.001120.49
Gonzalez, Morgan,130651700.990.000.000.001700.99
Perry, Eric,18314115.730.000.0056.9758.76
Stewart, Amanda, M,1531094.440.000.000.0094.44
Howard, Alyssa, A,11513863.950.000.000.00863.95
Evans, Elijah, S,2588439.980.000.000.0039.98
Coleman, Stephanie,2226489.970.000.000.0089.97
Brown, Dylan, J,124492351.960.000.000.002351.96
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Johnson, Madison, L,15530846.460.000.000.00846.46
Hall, Taylor, J,169951735.980.000.000.001735.98
Jones, Michael, A,2210771.970.000.000.0071.97
Nelson, Henry,193941155.480.000.000.001155.48
Green, Xavier,2356739.980.000.000.0039.98
Alexander, Gavin, K,2932249.990.000.000.0049.99
Griffin, James,28189567.760.000.000.00567.76
Campbell, Angel, D,195461174.480.000.000.001174.48
Walker, Destiny, M,169961754.980.000.000.001754.98
Hayes, Gavin, A,194001179.470.000.000.001179.47
Clark, Zachary, J,2389358.980.000.000.0058.98
Raje, Mindy, A,16083561.970.000.000.00561.97
James, Emma,127812329.980.000.000.002329.98
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Ross, Kelly,2607676.960.000.000.0076.96
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Torres, Abigail,253674.990.000.000.004.99
Williams, Destiny, S,15881564.990.000.00564.990.00
Richardson, Erin, R,1633188.850.000.0038.8849.97
Blue, Paige,2170313.980.000.000.0013.98
Watson, Devin, A,18875114.950.000.000.00114.95
Bradley, Nathaniel,169551760.470.000.000.001760.47
Nelson, James, L,245257.280.000.007.280.00
Gonzales, Paige,2170291.940.000.0039.9851.96
Brown, Julia,18065155.470.000.000.00155.47
Lewis, Morgan,17410168.740.000.000.00168.74
Roberts, Rebecca,2800094.480.000.000.0094.48
Sharma, Kathryn,20740140.940.000.000.00140.94
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Gray, Mariah,222787.280.000.007.280.00
Cook, Joan,235544.990.000.000.004.99
Moreno, Lance, A,2922939.980.000.000.0039.98
Gutierrez, Neil, L,214897.280.000.000.007.28
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Roberts, Amanda,171752334.980.000.000.002334.98
Flores, Hannah,1952540.230.000.000.0040.23
Smith, Hannah, J,2526554.980.000.0054.980.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Simmons, David, E,120172339.970.000.002339.970.00
Torres, Dalton,235037.280.000.007.280.00
Anderson, Madison, G,2835978.980.000.000.0078.98
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Russell, Richard,2763322.260.000.000.0022.26
Cannata, Gabrielle, C,217254.990.000.000.004.99
Clark, Destiny, L,28600119.980.000.000.00119.98
Johnson, Jonathan,220597.280.000.000.007.28
Anderson, Ryan, W,132712319.990.000.000.002319.99
Parker, Kaylee, M,2773878.980.000.000.0078.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Bailey, Maria, C,1915034.980.000.000.0034.98
Reed, Morgan, E,2877923.970.000.000.0023.97
Baker, Gabriella,174041709.980.000.000.001709.98
Bryant, Dakota, L,176132401.950.000.000.002401.95
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Baker, Mason, A,132702394.950.000.000.002394.95
Stewart, Alexandria,174761700.990.000.000.001700.99
Hayes, Jason,261764.990.000.000.004.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Diaz, Gabrielle,14893839.480.000.000.00839.48
Sanchez, Rachel, C,267304.990.000.000.004.99
Yuan, Brendan, S,247444.990.000.000.004.99
Li, Eugene, A,15283865.950.000.000.00865.95
Hall, Jason, A,29351119.980.000.000.00119.98
Thompson, Lucas, O,212774.990.000.000.004.99
Henderson, Austin,2764354.980.000.000.0054.98
Jackson, Andrew,2047985.480.000.000.0085.48
Ross, Seth, M,184332329.980.000.000.002329.98
Li, Thomas,181162376.960.000.000.002376.96
White, Emma, N,16090604.960.000.000.00604.96
Hall, Jose, J,17601225.420.000.00155.4569.97
Richardson, Lauren, C,14867839.480.000.000.00839.48
Foster, Caleb,27112114.460.000.000.00114.46
Smith, Nathan,217647.280.000.007.280.00
Clark, Joseph, D,153954780.020.000.000.004780.02
Perry, Samuel,18811100.960.000.00100.960.00
Luo, Donna, E,248054.990.000.000.004.99
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Jai, Samuel, L,1635887.950.000.0039.9947.96
Harris, Seth, M,161402528.330.000.002528.330.00
Rogers, Shelby,11712127.800.000.0042.5985.21
Lewis, Christopher,1875586.960.000.0086.960.00
Watson, Cole, A,217684118.263578.270.000.00539.99
Parker, Blake,15008170.530.000.0074.9895.55
James, Sara,198023374.993374.990.000.000.00
Washington, Vanessa,238194802.110.003578.270.001223.84
Edwards, Eric,2462768.490.000.000.0068.49
Patterson, Eduardo,11142866.810.000.0072.26794.55

Generated 2025-11-01 06:31:29.877 UTC