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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Cooper, Brianna,2592513.980.000.0013.980.00
James, Timothy,213312670.890.000.002670.890.00
Cox, Katelyn, B,2174230.970.000.0030.970.00
Stewart, Cody, A,212843223.580.000.002049.101174.48
Coleman, Joan, W,2669964.470.000.0064.470.00
Ward, Nicole, L,212724435.380.000.002071.422363.96
Ward, Jade, D,14661195.020.000.0074.98120.04
Foster, Deb,215012661.400.000.002661.400.00
Brown, Fernando,1900191.950.000.0069.9721.98
Simmons, Haley, T,262022749.320.000.002181.56567.76
Hill, Jordan, J,16005198.730.000.00102.2796.46
Adams, Connor,214232888.560.000.002049.10839.46
Bryant, Brittany,2254548.970.000.000.0048.97
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Cooper, Alexandra,19541131.240.000.000.00131.24
White, James,253317.280.000.000.007.28
Harris, Destiny, M,137102341.460.000.000.002341.46
Perry, Eric,18314115.730.000.0056.9758.76
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Howard, Alyssa, A,11513863.950.000.000.00863.95
Hughes, Isabella,2304851.460.000.0051.460.00
Sharma, Kathryn,20740140.940.000.000.00140.94
Morgan, Isaiah,18978118.730.000.0081.4637.27
Sanchez, Stephanie,1786756.970.000.000.0056.97
Lee, Ethan, J,223597.280.000.007.280.00
Johnson, Cameron, R,137201155.480.000.000.001155.48
Zhang, Heather,166543056.320.000.00751.342304.98
Evans, Elijah, S,2588439.980.000.000.0039.98
Sanders, Allison, B,18852268.250.000.000.00268.25
Brown, Dylan, J,124492351.960.000.000.002351.96
Hall, Fernando,2210090.950.000.000.0090.95
Ward, Mariah, J,2158044.910.000.000.0044.91
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Baker, Allison,2649558.980.000.000.0058.98
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
Hall, Grace, A,201894.990.000.000.004.99
Lewis, Ryan, A,203124.990.000.004.990.00
Young, Courtney,176222374.980.000.000.002374.98
Thompson, Blake,18390141.960.000.000.00141.96
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Wright, Carol, C,12928247.410.000.0033.98213.43
Alexander, Julian,132172351.960.000.000.002351.96
Morris, Seth,189592341.460.000.000.002341.46
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Miller, Eduardo,14561158.840.000.0049.97108.87
Rogers, Bryce,174022304.980.000.000.002304.98
Perez, Kaitlyn, A,120812366.960.000.002366.960.00
Campbell, Angel, D,195461174.480.000.000.001174.48
Carter, Savannah, M,120902350.960.000.002350.960.00
Walker, Destiny, M,169961754.980.000.000.001754.98
Johnson, Christopher,119794813.760.000.004813.760.00
Hayes, Gavin, A,194001179.470.000.000.001179.47
Barnes, Jeremy,2144654.980.000.0054.980.00
Clark, Zachary, J,2389358.980.000.000.0058.98
Suri, Carolyn, S,12972175.710.000.000.00175.71
Watson, Michelle, H,262352181.560.000.002181.560.00
Yang, Aaron, C,2519654.980.000.000.0054.98
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Simmons, Brittany,2923139.980.000.000.0039.98
Ward, Stephanie, A,27429782.990.000.00782.990.00
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Thomas, Richard,27557782.990.000.00782.990.00
Parker, Caleb, A,2631813.980.000.000.0013.98
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Diaz, Richard, A,2668264.470.000.000.0064.47
Powell, David, W,266151000.440.000.001000.440.00
Hall, Jan, M,11740334.120.000.00235.1598.97
Wilson, Victoria, R,27536782.990.000.00782.990.00
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Edwards, Hunter,2422067.930.000.000.0067.93
Murphy, Dalton, N,27043782.990.00782.990.000.00
Smith, Chloe,17619163.920.000.000.00163.92
Price, Jocelyn, D,258752443.350.002443.350.000.00
Stewart, Marcus, R,2063221.980.000.000.0021.98
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Barnes, Dalton, C,178581700.990.000.000.001700.99
Coleman, Lucas, A,27060782.990.00782.990.000.00
James, Bryce,13466133.450.000.000.00133.45
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Williams, Edward, D,14274121.560.000.009.99111.57
Taylor, Marcus, A,18944146.940.000.000.00146.94
Jones, Alexander, I,2002180.960.000.000.0080.96
Taylor, Edward, C,17442319.880.000.00230.9088.98
Bell, Garrett, J,14265161.230.000.000.00161.23
Howard, Alexandra,207363194.580.000.002049.101145.48
Carter, Katherine,11861286.300.000.000.00286.30
Gonzales, Gavin,2448813.980.000.000.0013.98
Morris, Paige, W,220414167.233578.270.000.00588.96
Gray, Jesse,14626197.040.000.0032.60164.44
Ramirez, Emma,29072128.970.000.000.00128.97
White, Emily, M,159174679.060.000.000.004679.06
Martin, Alfredo, P,2148039.980.000.000.0039.98
Anderson, Ashley,206803219.580.000.002049.101170.48
Rivera, Allison, M,13751224.910.000.000.00224.91
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Flores, Emily,13206163.190.000.0069.9793.22
Martinez, Grace, M,17385208.690.000.0069.97138.72
Lee, James, J,2881769.990.000.0069.990.00
Phillips, James, G,16846180.950.000.00180.950.00
Scott, Eric,282484.990.000.004.990.00
Miller, Victoria,15816188.020.000.00118.0569.97
Alexander, Aidan,17387148.190.000.00148.190.00
Rogers, Andrea, L,14328308.660.000.00155.23153.43
Perry, Samuel,18811100.960.000.00100.960.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Walker, Ian,16771104.550.000.0054.5849.97
Gray, Cindy, A,13198114.950.000.0099.9714.98
Collins, Jose,2474839.980.000.0039.980.00
Jackson, Brianna,1537797.910.000.0074.9822.93
Nelson, Jose,19217185.020.000.0091.9593.07
Hill, Haley, J,161033142.320.000.00792.342349.98
Anderson, Daniel,20694146.970.000.00146.970.00
Perry, Jennifer, J,221205962.343578.270.002384.070.00
Sanders, Xavier,1672173.750.000.0023.7849.97
Davis, Marcus, T,17337123.910.000.0086.9536.96
Foster, Carson, L,16959135.350.000.00120.3714.98
Ramirez, Ian,166783162.310.000.00742.352419.96
Deng, Wayne,2145336.960.000.0036.960.00
Richardson, Erin, R,1633188.850.000.0088.850.00
Flores, Kevin,15878225.920.000.0069.97155.95
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Mitchell, Bailey, B,267067.280.000.007.280.00
White, Abigail, T,15866145.820.000.0038.88106.94
Adams, Hailey, M,121544798.530.000.002379.472419.06
Parker, Morgan, S,1677236.960.000.0014.9821.98
Foster, Samuel, M,18523160.940.000.00128.9731.97
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Anderson, Tyler, E,131481137.430.000.001137.430.00
Russell, Jacqueline,18391100.960.000.00100.960.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Russell, Melanie, B,15478182.830.000.00167.8514.98
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Robinson, Lauren,2719668.490.000.0068.490.00
Simmons, David, E,120172339.970.000.002339.970.00
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Cox, Sara, P,2775869.990.000.0069.990.00
Jai, Jose,12944164.210.000.0039.99124.22
Gray, Jared, A,264494.990.000.004.990.00
Hughes, Antonio, P,15913712.270.000.00712.270.00
Harris, Edward,27062782.990.00782.990.000.00
Sanders, Alexandra,259112181.560.002181.560.000.00
Edwards, Angel, J,2912469.990.000.000.0069.99
Clark, Emily, R,120862294.990.000.000.002294.99
Moreno, Marie,2773969.990.000.000.0069.99
Thomas, Megan,2907169.990.000.000.0069.99
Watson, Marcus,2271585.480.000.000.0085.48
Phillips, Devin,18759112.060.000.000.00112.06
Morris, Mason, J,22349124.990.000.000.00124.99
Long, Sydney,279217.280.000.000.007.28
Wilson, Madison, H,1982821.980.000.000.0021.98
Taylor, Natalie, M,14338828.740.000.000.00828.74
Murphy, Chase, J,2472958.980.000.000.0058.98
Foster, Kayla,1969371.950.000.000.0071.95
Long, Jordyn,1733847.250.000.000.0047.25
Harris, Samantha, A,244874.990.000.000.004.99
Hill, Timothy,14871848.470.000.000.00848.47
Coleman, Spencer,15993597.260.000.000.00597.26
Green, Mackenzie, C,280737.280.000.000.007.28
Watson, Richard,15943365.410.000.00154.98210.43
Jones, Charles,22882101.450.000.000.00101.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Nelson, Kevin,1476584.970.000.000.0084.97
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Bradley, Jocelyn,230227.280.000.000.007.28
Green, Eric,2738069.990.000.000.0069.99
Flores, Devin, A,15559172.040.000.0086.5685.48
Williams, Austin,2035432.220.000.000.0032.22
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Hughes, Destiny, P,28027119.980.000.000.00119.98
Anderson, Isabella,137432349.980.000.000.002349.98
Rodriguez, Taylor,1607166.960.000.000.0066.96
Bradley, Alexandria,176911779.470.000.000.001779.47
Kennedy, Bridget,2202639.980.000.000.0039.98
Allen, Allison, A,1975737.270.000.000.0037.27
Evans, Gabriel,2348789.970.000.000.0089.97
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Phillips, Luis, G,207347.280.000.000.007.28
Thompson, Brianna, X,1864269.970.000.000.0069.97
Evans, Alexandra,2432268.490.000.000.0068.49
Perez, Timothy, L,227304.990.000.000.004.99
Watson, Devin, A,18875114.950.000.000.00114.95
Robinson, Zachary, L,137092332.280.000.000.002332.28
Brown, Morgan,2919778.980.000.000.0078.98
Foster, Antonio,12795108.540.000.0066.2642.28
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Nath, Kenneth, W,170372334.970.000.000.002334.97
Sandberg, Chase,2190475.970.000.000.0075.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Alexander, Caroline,176541759.970.000.000.001759.97
Stewart, Allison, R,18826166.430.000.0069.9996.44
Moore, Wyatt, F,189712351.960.000.000.002351.96
Stewart, Cindy,14496804.480.000.000.00804.48
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Lewis, Ethan,27998144.470.000.000.00144.47
Taylor, Zachary, M,27082782.990.00782.990.000.00
Hill, Sydney,264821000.440.000.001000.440.00
Williams, Zachary, B,27099782.990.000.00782.990.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Diaz, Angela, K,27259782.990.000.00782.990.00
Cox, Julia, A,206703228.570.000.002049.101179.47
Wilson, Eduardo,15323804.470.000.000.00804.47
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Ross, Kelly,2607676.960.000.000.0076.96
Powell, Katherine, C,14574177.600.000.000.00177.60
Bradley, Evan,18506101.940.000.000.00101.94
Baker, Mason, A,132702394.950.000.000.002394.95
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Gonzales, Emily, P,21777180.980.000.000.00180.98
Brooks, Allison,146054750.010.000.000.004750.01
Roberts, Hunter,282607.280.000.000.007.28
Carter, Jonathan,14578848.470.000.000.00848.47
Adams, Gabriel, S,195271219.450.000.000.001219.45
Hayes, Dalton, C,188822322.280.000.000.002322.28
Reed, Melanie, A,28160574.980.000.000.00574.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Jones, Kayla, C,1854194.260.000.0069.9924.27
Martin, Christian, V,19709197.250.000.000.00197.25
Price, Rachel, D,2532889.970.000.000.0089.97
Rivera, Sara,187852350.960.000.000.002350.96
Diaz, Trevor, B,2051954.960.000.000.0054.96
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Miller, Destiny,251577.280.000.000.007.28
Yuan, Brendan, S,247444.990.000.000.004.99
Turner, Eduardo,158764789.020.000.000.004789.02
Collins, Allison,28581119.980.000.000.00119.98
Watson, Victoria,16125588.960.000.000.00588.96
Flores, Caleb, S,12165280.640.000.00243.3737.27
Bradley, Rachel,158504813.040.000.000.004813.04
Miller, Jill,129142329.980.000.000.002329.98
Ross, Seth, M,184332329.980.000.000.002329.98
Li, Thomas,181162376.960.000.000.002376.96
Turner, Mary,220154.990.000.000.004.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Alexander, Luke,290432447.050.000.002447.050.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Diaz, Hailey, W,116932294.990.000.002294.990.00
Johnson, Ian, E,2173283.470.000.000.0083.47
White, Emma, N,16090604.960.000.000.00604.96
Nelson, Jordan, H,201304.990.000.004.990.00
Harris, Anthony,2144721.980.000.000.0021.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03

Generated 2024-09-20 19:26:51.321 UTC