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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Allen, Sean, L,12097159.220.000.000.00159.22
Taylor, Brianna,17027230.900.000.00145.4285.48
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Bradley, Nathaniel,169551760.470.000.000.001760.47
Reed, Gabriella, A,2743778.980.000.000.0078.98
Barnes, Haley, J,2133939.980.000.0039.980.00
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Griffin, Miguel,2146476.970.000.000.0076.97
Torres, Pedro, E,16958168.020.000.00153.0414.98
Harris, Matthew,14330806.760.000.000.00806.76
Walker, John, M,2858969.990.000.000.0069.99
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Cooper, Brianna,2592513.980.000.000.0013.98
Sanders, Zoe, L,248254.990.000.000.004.99
Gonzales, Brittany,217104187.233578.270.000.00608.96
Morris, Mason, J,22349124.990.000.000.00124.99
Flores, Julia, E,172631700.990.000.000.001700.99
Mehta, Carmen, C,2743694.480.000.000.0094.48
Brooks, Paige,222325985.310.003578.270.002407.04
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Hall, Amber,20106131.950.000.000.00131.95
Prasad, Erick, E,28786127.950.000.000.00127.95
Evans, Maria,22544127.280.000.00127.280.00
Young, Jenna, W,163652490.180.000.000.002490.18
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Long, Jordan,199884555.470.003399.990.001155.48
Martinez, Jill,242354829.390.003578.270.001251.12
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Lee, Ethan, J,223597.280.000.000.007.28
Sanders, Mason, G,2345939.980.000.000.0039.98
Simmons, Dakota, T,14110819.460.000.000.00819.46
Morris, Haley, A,2354848.970.000.000.0048.97
Deng, Wayne,2145336.960.000.0036.960.00
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Hughes, Isabella,2304851.460.000.000.0051.46
Martin, Gina, E,11078793.270.000.00158.36634.91
Robinson, Sarah, A,2702859.980.000.000.0059.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Shan, Benjamin,235663578.270.003578.270.000.00
Rogers, Olivia,12020804.470.000.000.00804.47
Brown, Samantha, G,2514739.980.000.000.0039.98
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Flores, Eduardo, S,2896962.980.000.000.0062.98
Perry, Ryan,132494795.340.000.000.004795.34
Russell, Chloe, M,12763589.960.000.000.00589.96
Bell, Chase,180911750.980.000.000.001750.98
Flores, Gabriel,271117.280.000.000.007.28
Ramos, Kristi,151764703.030.000.000.004703.03
Turner, Mary,220154.990.000.000.004.99
Thompson, Lucas, O,212774.990.000.000.004.99
Brown, Morgan,2919778.980.000.000.0078.98
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Ware, Dennis, L,237254828.110.003578.270.001249.84
Lee, John,19801193.010.000.000.00193.01
Patterson, Eduardo,11142866.810.000.0072.26794.55
Jai, Connor, D,27253782.990.000.00782.990.00
Kumar, Austin,204834400.060.000.002049.102350.96
Adams, Katherine, M,235184.990.000.000.004.99
Lal, Robert, L,14084138.680.000.000.00138.68
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Davis, Marcus, T,17337123.910.000.0086.9536.96
Price, Isabelle,201825749.970.003374.990.002374.98
Reed, Megan, A,181181750.980.000.000.001750.98
Jenkins, Samantha,113311290.330.000.00410.31880.02
Barnes, Dalton, C,178581700.990.000.000.001700.99
Hernandez, Jamie,27283119.980.000.00119.980.00
Murphy, Dalton, N,27043782.990.00782.990.000.00
Rogers, Jared, J,12166162.220.000.000.00162.22
Brown, Dalton, N,218134118.263578.270.000.00539.99
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Smith, Noah,13175166.920.000.000.00166.92
Coleman, Samuel, N,17450123.980.000.000.00123.98
Moore, Wyatt, F,189712351.960.000.000.002351.96
White, Emma, N,16090604.960.000.000.00604.96
Zhang, Robert,188551155.480.000.000.001155.48
Cooper, Stephanie,249762181.560.002181.560.000.00
Sanchez, Grace,120802354.990.000.000.002354.99
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Flores, Logan, K,14631848.470.000.000.00848.47
Allen, Mason,176252431.950.000.000.002431.95
Alexander, Sarah,1941129.990.000.000.0029.99
Chen, David,2720839.980.000.000.0039.98
Murphy, Emma,198445807.930.003374.990.002432.94
Edwards, Logan,250024.990.000.000.004.99
Gray, Sara,292472447.050.000.002447.050.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Evans, Elijah, S,2588439.980.000.000.0039.98
Stewart, Alex, M,2008463.150.000.000.0063.15
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Wright, Jennifer,2650559.980.000.0059.980.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Turner, Kaylee, M,16213154.540.000.000.00154.54
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Gill, Beth,199975814.980.003374.990.002439.99
Thompson, Madison, L,187882351.960.000.000.002351.96
Ward, Angela, M,2775669.990.000.000.0069.99
Lee, William,13185149.840.000.0069.9779.87
Washington, Emma,191231170.480.000.000.001170.48
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Adams, Haley, M,247862443.350.002443.350.000.00
Thomas, William, A,216142589.090.000.002049.10539.99
Long, Caleb, P,250462181.560.002181.560.000.00
Turner, Wyatt,200345769.960.003399.990.002369.97
Yang, Thomas, A,14108839.480.000.000.00839.48
King, Aaron, L,117394758.030.000.002359.982398.05
Thomas, Edward, E,19147133.710.000.000.00133.71
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Rogers, Carlos,19645134.440.000.000.00134.44
Flores, Luke, L,247337.280.000.000.007.28
Zhao, Karen, L,254082735.530.002181.560.00553.97
Williams, Austin,2035432.220.000.000.0032.22
King, Caleb, J,2898678.980.000.000.0078.98
Nelson, Sierra,161322459.620.000.002459.620.00
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Zhang, Connor, R,138532329.980.000.000.002329.98
Perez, Amber, D,13318214.260.000.00116.9197.35
Evans, Jesse,2191639.980.000.000.0039.98
Hall, Jason, A,29351119.980.000.000.00119.98
Wang, Karen, P,1955331.970.000.000.0031.97
Lee, Emma,16948176.430.000.000.00176.43
Garcia, Anna, B,15572104.550.000.000.00104.55
Li, Eugene, A,15283865.950.000.000.00865.95
Brown, Dylan, J,124492351.960.000.000.002351.96
Campbell, Natalie, L,115122319.990.000.000.002319.99
Martin, Brianna, M,235834829.390.003578.270.001251.12
Hughes, Eduardo,15564188.520.000.000.00188.52
Price, Caroline,180511735.980.000.000.001735.98
Williams, Sydney, J,15334848.470.000.000.00848.47
Thompson, Devin,207084406.400.000.002071.422334.98
Rivera, Allison, M,13751224.910.000.000.00224.91
Taylor, Natalie, M,14338828.740.000.000.00828.74
Bailey, Jessica, L,12945218.440.000.000.00218.44
Foster, Paige,2742894.480.000.000.0094.48
Diaz, Alyssa,139084715.330.000.000.004715.33
Morgan, Brianna, D,111362380.470.000.002380.470.00
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
White, Edward, J,15847205.460.000.000.00205.46
Wang, Benjamin, R,274547.280.000.000.007.28
Murphy, Maria,160113657.260.000.000.003657.26
Williams, Destiny, S,15881564.990.000.00564.990.00
Moreno, Marie,2773969.990.000.000.0069.99
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Thomas, Logan, A,14091251.200.000.0053.99197.21
Rogers, Faith,2468259.980.000.000.0059.98
Taylor, Victoria,260132443.350.000.002443.350.00
Perry, Olivia,203754438.380.000.002071.422366.96
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Clark, Lauren,170341750.980.000.000.001750.98
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Martin, Joshua, A,276077.280.000.007.280.00
Stewart, Destiny,13144281.470.000.00134.98146.49
White, Emily, M,159174679.060.000.000.004679.06
Martin, Xavier,222335997.330.003578.270.002419.06
Bryant, Gabriel,2765669.990.000.000.0069.99
Alexander, Angelica,2271471.950.000.000.0071.95
Henderson, Olivia,188591155.480.000.000.001155.48
Diaz, Jason,17374206.630.000.0089.46117.17
Stewart, Olivia, B,1874923.780.000.000.0023.78
Anderson, Jasmine, A,235534.990.000.000.004.99
Allen, Madeline,2924068.970.000.000.0068.97
Jones, Kayla, C,1854194.260.000.000.0094.26
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Moore, Hunter,14897196.270.000.0071.58124.69
Alexander, Taylor,17482146.940.000.0076.9769.97
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Garcia, Lucas,27545782.990.000.00782.990.00
Rubio, Ruben, D,1887186.960.000.0086.960.00
Parker, James,11808610.190.000.00186.77423.42
Moore, Jessica, J,2008576.760.000.000.0076.76
Stewart, Cody, A,212843223.580.000.002049.101174.48
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Morris, Richard,2007039.980.000.000.0039.98
Lu, Alejandro,2562039.980.000.000.0039.98
Foster, Samuel, M,18523160.940.000.00128.9731.97
Blue, Makayla,1900029.990.000.000.0029.99
Jones, Charles,22882101.450.000.000.00101.45
Russell, Oscar, A,12140118.170.000.000.00118.17
Brooks, Victoria, H,16479158.510.000.000.00158.51
Sanchez, Katherine, S,24399132.940.000.00132.940.00
James, Morgan, E,2324539.980.000.000.0039.98
Watson, Janet, S,2320859.980.000.000.0059.98
Hill, Jordan, J,16005198.730.000.00102.2796.46
Nelson, Kevin,1476584.970.000.000.0084.97
Luo, Franklin, J,2202759.980.000.000.0059.98
Foster, Carson, L,16959135.350.000.00120.3714.98
Alexander, Nathan, A,187951198.970.000.000.001198.97
Foster, Isabel, M,2174571.950.000.000.0071.95
Reed, Judith, D,2534759.980.000.000.0059.98
Cooper, Ariana,17348205.420.000.000.00205.42
Edwards, Hunter,2422067.930.000.000.0067.93
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Wilson, Madison, H,1982821.980.000.000.0021.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Wilson, Tyler, L,15879196.930.000.000.00196.93
Griffin, Cassidy,264961000.440.000.001000.440.00
Kumar, Elijah,15197156.920.000.000.00156.92
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Washington, Adam, G,2543713.980.000.000.0013.98
Gonzales, Jordan,2368113.980.000.000.0013.98
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Ward, Emma, W,2179659.980.000.000.0059.98
Wilson, Christian,27085782.990.000.00782.990.00
Allen, Jack, M,291372419.060.000.002419.060.00
Sánchez, Angela, C,176551750.980.000.000.001750.98
Ruiz, Philip,1807781.460.000.000.0081.46
Davis, Ethan,136604750.010.000.000.004750.01
Collins, Alex, S,287812.290.000.000.002.29
Hall, Jan, M,11740334.120.000.00235.1598.97
Kelly, Angel, E,15418232.230.000.000.00232.23
Richardson, Olivia,204683169.590.000.002049.101120.49
Henderson, Abigail,2044139.980.000.000.0039.98
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Kelly, Julia,2379867.930.000.0067.930.00
Cook, Seth,2301064.470.000.000.0064.47
Baker, Allison,2649558.980.000.000.0058.98
Long, Sydney,279217.280.000.000.007.28
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Lopez, Jack, I,2904751.460.000.000.0051.46
Torres, Victoria,17551160.920.000.000.00160.92
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Russell, Xavier,12964119.950.000.000.00119.95
Russell, Melanie, B,15478182.830.000.00167.8514.98
Collins, Isaac,260777.280.000.000.007.28
Jackson, Brianna,1537797.910.000.0074.9822.93
James, Adrian, C,253404.990.000.000.004.99
Ward, Natalie, J,132412325.960.000.000.002325.96
Taylor, Marcus, A,18944146.940.000.000.00146.94
Williams, Ryan, R,222475978.610.003578.270.002400.34
Sanders, Alexandra,259112181.560.000.002181.560.00
Ross, Xavier, A,12202171.470.000.0049.97121.50
Robinson, Madison, W,183772394.970.000.000.002394.97
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Reed, Melanie, A,28160574.980.000.000.00574.98
Martin, John, A,144364776.010.000.000.004776.01
Thomas, Ian,191181120.490.000.000.001120.49
Walker, Isabella,243864143.740.003578.27565.470.00
Davis, Thomas,167641760.470.000.000.001760.47
Watson, Devin, A,18875114.950.000.000.00114.95
Johnson, Christopher,119794813.760.000.002352.212461.55
James, Jeremiah, S,11661287.700.000.000.00287.70
Brown, Fernando,1900191.950.000.0069.9721.98
Reed, Marcus,14582111.790.000.0014.9896.81
Long, Natalie,14363192.340.000.000.00192.34
Lazecky, Petr,258642443.350.002443.350.000.00
Malhotra, Brenda,133912405.470.000.000.002405.47

Generated 2025-11-02 04:21:40.377 UTC