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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Evans, Elijah, S,2588439.980.000.000.0039.98
Smith, Alexandra,2829261.960.000.000.0061.96
Zukowski, Jake,220584118.263578.270.000.00539.99
Lewis, Zachary, L,14760167.260.000.000.00167.26
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Hughes, Luke, I,270141274.080.00699.100.00574.98
Washington, Ryan,2833294.480.000.000.0094.48
Robinson, Emily,12183228.420.000.0054.96173.46
Flores, Kevin,15878225.920.000.0069.97155.95
Martin, Tyler, L,2772469.990.000.000.0069.99
Powell, Blake, J,2237139.980.000.000.0039.98
Perry, Ryan,132494795.340.000.000.004795.34
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Smith, Lucas, P,1809064.910.000.000.0064.91
Peterson, Brian,12892419.470.000.00156.27263.20
Wilson, Andrew, R,182362414.990.000.000.002414.99
Campbell, Chloe,11212760.930.000.00231.72529.21
Nelson, Luis,234884.990.000.000.004.99
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Li, Thomas,181162376.960.000.000.002376.96
Rogers, Jade, I,14332102.250.000.000.00102.25
Brown, Nicholas, S,11506675.640.000.00121.93553.71
Lewis, Brandon, A,2903769.990.000.000.0069.99
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Scott, Eric,282484.990.000.004.990.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Hughes, Samantha,2721564.470.000.000.0064.47
Thompson, Lucas, O,212774.990.000.000.004.99
Stewart, Gabriella,2803469.990.000.000.0069.99
Collins, Jonathan,16849119.980.000.000.00119.98
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Flores, Stephanie,259922721.550.000.002181.56539.99
Wilson, Emily,174002331.950.000.000.002331.95
Sanchez, Stephanie,1786756.970.000.000.0056.97
Russell, Richard,2763322.260.000.000.0022.26
Green, Kaylee, C,2618567.970.000.000.0067.97
Scott, Adam,15863243.010.000.000.00243.01
Nath, Carl, H,29001624.970.000.000.00624.97
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Jenkins, Dakota, D,2067964.470.000.0064.470.00
Wang, Benjamin, R,274547.280.000.000.007.28
Wright, Robert, C,158894848.030.000.000.004848.03
Hill, Fernando,247634.990.000.000.004.99
Griffin, Xavier,228775962.340.003578.270.002384.07
Baker, Eduardo,180921789.450.000.000.001789.45
Moore, Jonathan,2047896.460.000.000.0096.46
Torres, Victoria,17551160.920.000.000.00160.92
Foster, Paige,2742894.480.000.000.0094.48
Rogers, Olivia,12020804.470.000.000.00804.47
Sun, Arturo, C,11498557.540.000.0072.92484.62
Butler, Isabel,16241126.960.000.000.00126.96
Johnson, James,234984.990.000.000.004.99
Perez, Sydney, C,221174158.243578.270.000.00579.97
Sanders, Mason, G,2345939.980.000.000.0039.98
Foster, Deb,215012661.400.000.002661.400.00
Taylor, Marcus, A,18944146.940.000.000.00146.94
She, Martha, E,222515971.330.003578.270.002393.06
Hall, Natalie, A,230704.990.000.004.990.00
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Jones, Zachary, J,27285782.990.000.00782.990.00
Coleman, Joan, W,2669964.470.000.000.0064.47
Flores, Megan, N,230746021.820.003578.270.002443.55
Simmons, David, E,120172339.970.000.002339.970.00
Gonzales, Nathan, M,12107222.230.000.0032.27189.96
Lal, Robert, L,14084138.680.000.000.00138.68
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Howard, Morgan, T,229713578.270.003578.270.000.00
Long, Gavin,13762186.030.000.0036.59149.44
Harris, Anthony,2144721.980.000.000.0021.98
Clark, Emily, R,120862294.990.000.000.002294.99
Washington, Elijah, L,250164.990.000.000.004.99
Morgan, Isaiah,18978118.730.000.000.00118.73
Gonzales, Brittany,217104187.233578.270.000.00608.96
Jai, Kevin,1983678.960.000.0038.9839.98
Moore, Fernando,265821000.440.000.001000.440.00
Zhang, Robert,188551155.480.000.000.001155.48
Butler, Morgan, E,2050068.490.000.000.0068.49
Bell, Timothy, J,2810178.980.000.0078.980.00
Sharma, Jackson,16876151.840.000.000.00151.84
Cook, Steven, J,27053782.990.00782.990.000.00
Adams, Kyle, E,1881269.990.000.0069.990.00
Sanchez, Grace,120802354.990.000.000.002354.99
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Sanders, Zoe, L,248254.990.000.000.004.99
Torres, Christina, M,20746119.950.000.000.00119.95
Wright, Katelyn, A,14502122.260.000.0014.98107.28
Kumar, Austin,204834400.060.000.002049.102350.96
Russell, Caleb,23552103.480.000.000.00103.48
Watson, Devin, A,18875114.950.000.000.00114.95
White, Judith, R,148851155.480.000.000.001155.48
Flores, Julian,158464943.320.000.000.004943.32
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Henderson, Caroline,2008256.970.000.000.0056.97
James, Adrian, C,253404.990.000.000.004.99
Evans, Luke,2917615.230.000.000.0015.23
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Russell, Fernando,27084782.990.000.00782.990.00
Flores, Nathan, C,2463713.980.000.000.0013.98
Sanders, Hailey,19647282.040.000.000.00282.04
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Martinez, Jonathan,1330366.250.000.000.0066.25
Lal, Jonathan,2009671.460.000.000.0071.46
Hughes, Anna,197052341.970.000.000.002341.97
Ross, Seth, M,184332329.980.000.000.002329.98
Price, Stephanie,258922443.350.002443.350.000.00
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Diaz, Brandon,236764.990.000.004.990.00
Hughes, Luis,130841798.960.000.000.001798.96
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Brooks, Lucas, S,16089342.030.000.000.00342.03
Smith, Katherine, J,13197105.190.000.000.00105.19
Russell, Samuel, V,11652310.930.000.000.00310.93
Jones, Dalton, T,189512334.970.000.000.002334.97
Smith, Andrew,1472387.570.000.0014.9872.59
Torres, Taylor,16666205.440.000.00123.9881.46
Coleman, Samuel, N,17450123.980.000.000.00123.98
Hu, Gilbert, L,2876769.990.000.000.0069.99
Ross, Kaitlyn,16121614.470.000.000.00614.47
Ward, Nicole, L,212724435.380.000.002071.422363.96
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Thomas, David,168363193.790.000.000.003193.79
Diaz, Faith, M,2236356.970.000.000.0056.97
Cooper, Stephanie,249762181.560.002181.560.000.00
Brooks, Paige,222325985.310.003578.270.002407.04
Bradley, Evan,18506101.940.000.000.00101.94
Walker, Ian,16771104.550.000.0054.5849.97
Davis, Marcus, T,17337123.910.000.0086.9536.96
Bryant, Gabriel,2765669.990.000.000.0069.99
Sanchez, Allison,1666741.720.000.000.0041.72
Turner, Kaylee, M,16213154.540.000.000.00154.54
Howard, Natalie,1349154.960.000.0014.9839.98
Perry, Jackson, J,213064.990.000.000.004.99
Rodriguez, Natalie,2077330.970.000.000.0030.97
Wilson, Christian,27085782.990.000.00782.990.00
Reed, Catherine, M,203807.280.000.000.007.28
Green, Sophia, E,249772181.560.002181.560.000.00
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Alexander, Julia, J,15291889.470.000.000.00889.47
Washington, Christian, R,2668639.980.000.000.0039.98
Bennett, Brittany, J,2233239.980.000.000.0039.98
Alexander, Sarah,1941129.990.000.000.0029.99
Murphy, Shelby,244894.990.000.000.004.99
Cox, Sara, P,2775869.990.000.0069.990.00
Ward, Natalie, J,132412325.960.000.000.002325.96
Patterson, Aaron, W,191131184.460.000.000.001184.46
Ross, Alexia, S,13231247.900.000.000.00247.90
Hughes, Caroline, C,2830278.980.000.0078.980.00
Phillips, Miguel,2049812.940.000.000.0012.94
Rodriguez, Richard,12969180.790.000.000.00180.79
Jai, Samuel, L,1635887.950.000.0039.9947.96
Stewart, Marcus, R,2063221.980.000.000.0021.98
Rubio, Kellie,27653128.970.000.000.00128.97
Foster, Abigail,1982346.470.000.000.0046.47
Parker, James,11808610.190.000.00186.77423.42
Carter, Bailey,213322616.860.000.002616.860.00
Martinez, Jill,242354829.390.003578.270.001251.12
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Griffin, Maria,1840763.250.000.000.0063.25
Johnson, Christopher,119794813.760.000.002352.212461.55
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Roberts, Amber, W,215822638.060.000.002049.10588.96
Foster, Jessica,2606951.460.000.0051.460.00
Jackson, Brianna,1537797.910.000.0074.9822.93
Evans, James, C,206654408.560.000.002049.102359.46
Ruiz, Philip,1807781.460.000.000.0081.46
Green, Eric,2738069.990.000.000.0069.99
Carter, Jesse, E,22141166.280.000.000.00166.28
Bell, Danielle,140414765.020.000.000.004765.02
Allen, Mason,176252431.950.000.000.002431.95
Miller, Chloe, V,228936056.510.003578.272478.240.00
Nelson, Katherine,2802178.980.000.000.0078.98
Smith, Eduardo,2069139.980.000.0039.980.00
Clark, Zachary, J,2389358.980.000.000.0058.98
Stewart, Jessica,16097103.550.000.0046.5856.97
Luo, Jodi,2921368.490.000.000.0068.49
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Fernandez, Ruth,205463246.550.000.002049.101197.45
Henderson, Olivia,188591155.480.000.000.001155.48
King, Aaron, L,117394758.030.000.002359.982398.05
Chen, Luis, G,2125294.450.000.0094.450.00
Gonzales, Jordan,2368113.980.000.000.0013.98
Parker, Katherine,13268289.700.000.0068.97220.73
Flores, Caleb, S,12165280.640.000.00243.3737.27
Sanders, Paige,252872983.340.002443.350.00539.99
Reed, Melanie, A,28160574.980.000.000.00574.98
Evans, Kaylee,19642133.540.000.000.00133.54
Scott, Mason,2355139.980.000.000.0039.98
Stewart, Garrett, O,15762564.480.000.000.00564.48
Lewis, Morgan,17410168.740.000.000.00168.74
Phillips, Luis, G,207347.280.000.000.007.28
Price, Mariah, C,2074549.480.000.000.0049.48
Peterson, Mason, A,185701174.480.000.001174.480.00
Srini, Evelyn,16855150.950.000.000.00150.95
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Robinson, Dylan, L,1472481.530.000.000.0081.53
Coleman, Ian,2127639.980.000.000.0039.98
Turner, Samuel,2742069.990.000.0069.990.00
Martin, Kellie, R,28195574.980.000.000.00574.98
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Gray, Jared, A,264494.990.000.004.990.00
Hayes, Jason,261764.990.000.000.004.99
Howard, Alyssa, A,11513863.950.000.000.00863.95
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Cooper, Andrea,2932378.980.000.000.0078.98
Li, Jordan,17026261.390.000.00261.390.00
Hayes, Gavin, A,194001179.470.000.000.001179.47
Anderson, David, A,2209761.960.000.0061.960.00
Thomas, Richard,27557782.990.000.00782.990.00
Brown, Fernando,1900191.950.000.0069.9721.98
Long, Chloe,167841735.980.000.000.001735.98
Sánchez, Angela, C,176551750.980.000.000.001750.98
Morris, Richard,2007039.980.000.000.0039.98
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Malhotra, Brenda,133912405.470.000.000.002405.47
Flores, Eduardo, S,2896962.980.000.000.0062.98
Flores, Logan, K,14631848.470.000.000.00848.47
Phillips, James, G,16846180.950.000.00123.9856.97
Hayes, Dalton, C,188822322.280.000.000.002322.28
Garcia, Christian, J,164913106.330.000.00751.342354.99
Allen, Allison, A,1975737.270.000.000.0037.27
Prasad, Molly,243924329.610.003578.270.00751.34
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Henderson, Stephanie, L,19224352.520.000.000.00352.52
She, Shawn, J,16902141.980.000.000.00141.98
Griffin, Miguel,2146476.970.000.000.0076.97
Hall, Wyatt,2382713.980.000.000.0013.98
Washington, Vanessa,238194802.110.003578.270.001223.84
Clark, Destiny, L,28600119.980.000.000.00119.98
Cooper, Christina, C,265121000.440.000.001000.440.00
Isla, Julian, A,13732108.960.000.004.99103.97
Stewart, Amanda, M,1531094.440.000.000.0094.44
Bennett, Maria, G,229837.280.000.000.007.28
Griffin, Cassidy,264961000.440.000.001000.440.00
Allen, Jack, M,291372419.060.000.002419.060.00
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Emma, W,2179659.980.000.000.0059.98
Butler, Jonathan,261804.990.000.000.004.99
Wood, Brittany,2877753.990.000.000.0053.99
Martin, Joshua, A,276077.280.000.007.280.00
Kumar, Zachary,254334.990.000.000.004.99
Martin, James, M,1987077.250.000.000.0077.25
Davis, Ethan,136604750.010.000.000.004750.01
Stewart, Grace, H,247737.280.000.000.007.28
Jai, Connor, D,27253782.990.000.00782.990.00
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Hill, Blake,11748131.540.000.000.00131.54
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Butler, Jackson, J,183241735.980.000.000.001735.98
Simmons, Nicole, S,2617729.480.000.000.0029.48
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Reed, Judith, D,2534759.980.000.000.0059.98
Kumar, Elijah,15197156.920.000.000.00156.92
Peterson, Morgan, J,168341750.980.000.000.001750.98
Jai, Edwin,169211754.980.000.000.001754.98

Generated 2025-11-03 12:06:29.069 UTC