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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Moore, Jonathan,2047896.460.000.000.0096.46
Washington, Victoria,235577.280.000.000.007.28
Moreno, Marie,2773969.990.000.000.0069.99
Jai, Jose,12944164.210.000.000.00164.21
Young, Savannah,259712749.320.000.002181.56567.76
Robinson, Abigail, R,183792362.270.000.000.002362.27
Gray, Sara,292472447.050.000.002447.050.00
Morgan, Timothy,14633242.500.000.0071.58170.92
Russell, Isabella, A,11507645.780.000.0028.48617.30
Blue, Paige,2170313.980.000.000.0013.98
Gomez, Rebekah,13486225.440.000.000.00225.44
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Walker, Charles,11677298.210.000.000.00298.21
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Alexander, Julia, J,15291889.470.000.000.00889.47
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Coleman, Dylan,27403132.970.000.000.00132.97
Stewart, Allison, R,18826166.430.000.0069.9996.44
Ramos, Derrick,18449100.940.000.0030.9769.97
Taylor, Tyler, A,12032614.960.000.00614.960.00
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
White, James,253317.280.000.000.007.28
Gonzalez, Morgan,130651700.990.000.000.001700.99
Carter, Katherine,11861286.300.000.000.00286.30
Ward, Natalie, J,132412325.960.000.000.002325.96
Cooper, Ariana,17348205.420.000.000.00205.42
Hughes, Edward,200234530.470.003374.990.001155.48
Sun, Arturo, C,11498557.540.000.007.95549.59
Nelson, Kevin,1476584.970.000.000.0084.97
Roberts, Rebecca,2800094.480.000.000.0094.48
Jenkins, Samantha,113311290.330.000.00410.31880.02
Washington, Kayla, E,14655174.960.000.0069.97104.99
Green, Marcus, C,15974208.410.000.0091.95116.46
Morgan, Jada, A,11520702.990.000.00137.45565.54
Rogers, Andrea, L,14328308.660.000.0049.97258.69
Coleman, Benjamin, F,234865343.230.003578.270.001764.96
Hughes, Luis,130841798.960.000.000.001798.96
Evans, Elijah, S,2588439.980.000.000.0039.98
Green, Samuel, D,14096174.730.000.000.00174.73
James, Adrian, C,253404.990.000.000.004.99
Barnes, Dalton, C,178581700.990.000.000.001700.99
Walker, Thomas,1307193.980.000.000.0093.98
Wilson, Eduardo,15323804.470.000.000.00804.47
Chen, Jonathan, G,13096200.690.000.000.00200.69
Lal, Luke, L,11019698.230.000.00139.93558.30
Rodriguez, Julia, A,264884.990.000.004.990.00
Russell, Arianna,22728149.930.000.00149.930.00
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Taylor, Madison, A,11802215.290.000.00127.9687.33
Ross, Anna, D,15494275.440.000.0029.99245.45
Garcia, Henry, B,112871009.240.000.00219.26789.98
Nelson, Henry,193941155.480.000.000.001155.48
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Griffin, Melissa, L,287807.950.000.000.007.95
Green, Xavier,2356739.980.000.000.0039.98
Martin, Brianna, M,235834829.390.003578.270.001251.12
Hall, Eduardo,16847189.940.000.000.00189.94
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Wang, Benjamin, R,274547.280.000.000.007.28
Gray, Seth, M,2008785.480.000.000.0085.48
Thompson, Madison, L,187882351.960.000.000.002351.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Collins, Amanda,2078339.980.000.000.0039.98
Lee, Ian,19646197.040.000.000.00197.04
Ross, Kaitlyn,16121614.470.000.000.00614.47
Wood, Brittany,2877753.990.000.000.0053.99
Collins, Isaac,260777.280.000.000.007.28
Rivera, Amanda,11131115.920.000.000.00115.92
Perry, Benjamin,291652407.040.000.002407.040.00
Martin, Jill, C,11824181.030.000.0069.97111.06
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Long, Gabrielle,198305765.923374.990.000.002390.93
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Price, Lauren, J,14079184.740.000.0037.29147.45
Taylor, Edward, C,17442319.880.000.00230.9088.98
Parker, Blake,15008170.530.000.000.00170.53
Campbell, Adam, A,214002688.890.000.002071.42617.47
Howard, Alexandra,207363194.580.000.002049.101145.48
Sharma, Thomas, A,18637121.940.000.000.00121.94
Bell, Eduardo,27101782.990.000.00782.990.00
Gonzales, Gavin,2448813.980.000.000.0013.98
Jenkins, Megan, R,12074261.380.000.000.00261.38
Thompson, Blake,18390141.960.000.000.00141.96
Gray, Jesse,14626197.040.000.000.00197.04
Li, Connor,201863191.910.002071.420.001120.49
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Collins, Xavier, C,16646250.910.000.000.00250.91
Baker, Sean, T,247782858.490.002181.56676.930.00
Griffin, Isabelle,249864.990.000.000.004.99
Campbell, Timothy,2584513.980.000.000.0013.98
Cooper, Stephanie,249762181.560.002181.560.000.00
Thomas, Isabella, M,27265782.990.000.00782.990.00
Williams, Joshua,260514.990.000.000.004.99
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Kelly, Angel, E,15418232.230.000.000.00232.23
Chen, David,2720839.980.000.000.0039.98
Griffin, Madison, A,250932181.560.002181.560.000.00
Diaz, Angela, K,27259782.990.000.00782.990.00
Anderson, Ashley,206803219.580.000.002049.101170.48
Hughes, Julia,250612443.350.002443.350.000.00
Evans, James, C,206654408.560.000.002049.102359.46
Alexander, Elijah,11738331.680.000.00141.73189.95
Cox, Lucas, J,253932443.350.002443.350.000.00
Stewart, Andrea, M,27252782.990.000.00782.990.00
Sanders, Xavier,1672173.750.000.000.0073.75
Clark, Anthony,27071782.990.00782.990.000.00
Thomas, Logan, A,14091251.200.000.0053.99197.21
Watson, Cole, A,217684118.263578.270.000.00539.99
Howard, Isaiah,259813018.330.002443.350.00574.98
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Williams, Morgan, C,203733226.900.000.002071.421155.48
Davis, Ethan,136604750.010.000.000.004750.01
James, Sara,198023374.993374.990.000.000.00
Perry, Olivia,203754438.380.000.002071.422366.96
Hughes, Jasmine,276284.990.000.000.004.99
Edwards, Eric,2462768.490.000.000.0068.49
Flores, Stephanie,259922721.550.000.002181.56539.99
Walker, Jasmine,134604693.040.000.000.004693.04
Hall, Morgan,2172641.950.000.000.0041.95
Bryant, Samantha,18345115.470.000.000.00115.47
Ward, Nicole, L,212724435.380.000.002071.422363.96
Long, Natalie,14363192.340.000.000.00192.34
Jones, Joshua,184012294.990.000.000.002294.99
Wright, Carol, C,12928247.410.000.0033.98213.43
Martin, Lucas, L,221144183.233578.270.000.00604.96
Sanchez, Allison,1666741.720.000.000.0041.72
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Flores, Zachary, H,233765314.250.003578.270.001735.98
Bryant, Nathan,2145059.980.000.000.0059.98
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Murphy, Emma,198445807.930.003374.990.002432.94
Turner, Morgan,11823178.470.000.000.00178.47
Perez, Angel, S,213362628.350.000.002071.42556.93
Williams, Ryan, R,222475978.610.003578.270.002400.34
Simmons, Jose,2464739.980.000.000.0039.98
Adams, Connor,214232888.560.000.002049.10839.46
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Hall, Kaylee, E,1975137.270.000.000.0037.27
Griffin, Jordan,13095328.890.000.0069.97258.92
Sanchez, Alex, K,131014736.030.000.000.004736.03
Rubio, Kellie,27653128.970.000.000.00128.97
White, Edward, J,15847205.460.000.000.00205.46
Morris, Abigail, C,287762.290.000.000.002.29
Price, Jeremy,259892744.520.000.002181.56562.96
Coleman, Ashley,27297782.990.000.00782.990.00
Smith, John,198555709.960.003399.990.002309.97
Taylor, Zachary, M,27082782.990.000.00782.990.00
Alexander, Thomas,207607.280.000.000.007.28
Campbell, Hunter,17422174.920.000.000.00174.92
Richardson, Olivia,204683169.590.000.002049.101120.49
Mitchell, Maria, D,27404782.990.000.00782.990.00
Wilson, Nathan, L,13936218.930.000.000.00218.93
Smith, Samuel, D,2308349.900.000.000.0049.90
Garcia, Isabella,18382204.940.000.000.00204.94
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Griffin, Cassidy,264961000.440.000.001000.440.00
Davis, Thomas,167641760.470.000.000.001760.47
She, Martha, E,222515971.330.003578.270.002393.06
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Washington, Christian, R,2668639.980.000.000.0039.98
Miller, Katherine, B,27102782.990.000.00782.990.00
Price, Isabelle,201825749.970.003374.990.002374.98
Lewis, Seth,26782699.100.00699.100.000.00
Coleman, Vanessa,215892589.090.000.002049.10539.99
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Collins, Luis, J,227655978.610.003578.270.002400.34
Zhang, Robert,188551155.480.000.000.001155.48
Coleman, Spencer,15993597.260.000.000.00597.26
Nelson, Adam, B,27402128.970.000.000.00128.97
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Perry, Ana,112151155.520.000.00292.94862.58
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Foster, Samuel, M,18523160.940.000.00128.9731.97
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Walker, Hunter,271007.280.000.000.007.28
Cooper, Christina, C,265121000.440.000.001000.440.00
Jai, Samuel, L,1635887.950.000.0039.9947.96
Green, Gabrielle, M,2181564.470.000.000.0064.47
Ross, Rachel, C,206693169.590.000.002049.101120.49
Wilson, Grace,17539205.920.000.000.00205.92
James, Juan,232674862.090.003578.271283.820.00
Hill, Jordan, J,16005198.730.000.0069.99128.74
Martin, Nicholas,233627.280.000.000.007.28
Powell, Angela, R,12970471.110.000.000.00471.11
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Washington, Lauren, R,229985329.250.003578.271750.980.00
Nelson, Jennifer,171471700.990.000.000.001700.99
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Ware, Dennis, L,237254828.110.003578.270.001249.84
Thompson, Joshua, F,259992181.560.000.002181.560.00
Rogers, Shelby,11712127.800.000.0042.5985.21
Shan, Benjamin,235663578.270.003578.270.000.00
Phillips, Jack, R,259952443.350.000.002443.350.00
Price, Devin, M,18758158.510.000.0073.5584.96
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Jai, Connor, D,27253782.990.000.00782.990.00
Phillips, Kyle,12158202.200.000.000.00202.20
Garcia, Cameron,186411120.490.000.000.001120.49
Foster, Kayla,1969371.950.000.000.0071.95
Hu, Gilbert, L,2876769.990.000.000.0069.99
Wilson, Hunter, R,2723013.980.000.000.0013.98
Hill, Haley, J,161033142.320.000.00792.342349.98
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Young, Julia, J,274144.990.000.000.004.99
Davis, Emily,27267782.990.000.00782.990.00
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Sharma, Samuel,27725119.980.000.000.00119.98
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Gonzales, Brittany,217104187.233578.270.000.00608.96
Rogers, Faith,2468259.980.000.000.0059.98
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Russell, Samantha,11211723.560.000.00118.46605.10
Long, Brandon, M,16110650.470.000.000.00650.47
Morris, Seth,189592341.460.000.000.002341.46
Chow, Candice,1923260.960.000.000.0060.96
Williams, Ian, M,175581750.470.000.000.001750.47
Patterson, Alexis,213484392.020.000.002049.102342.92
Gonzalez, Jeremiah,17468128.910.000.000.00128.91
Jones, Madison,246614181.760.003578.27603.490.00
Jones, Zachary, J,27285782.990.000.00782.990.00
Hughes, Eduardo,15564188.520.000.000.00188.52
Long, Morgan, H,213522625.390.000.002071.42553.97
Allen, Sean, L,12097159.220.000.000.00159.22
Sanders, Paige,252872983.340.002443.350.00539.99
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Perry, Ryan,132494795.340.000.000.004795.34
Kelly, Bryan,213492989.380.000.002989.380.00
Jenkins, Austin, D,15748296.910.000.000.00296.91
Lee, William,13185149.840.000.0069.9779.87
Baker, Ian, V,262002756.540.000.002181.56574.98
Turner, James, E,16841126.960.000.0069.9956.97
Bennett, Maria, G,229837.280.000.000.007.28
Suri, Carolyn, S,12972175.710.000.000.00175.71
Adams, Kaitlyn, A,11869239.600.000.000.00239.60
Chen, James, D,11641303.200.000.0021.49281.71
Henderson, Luke,19200109.240.000.000.00109.24
Robinson, Emily,12183228.420.000.0054.96173.46
Cook, Bryce,2864069.990.000.000.0069.99
Patterson, Natalie,16123629.970.000.000.00629.97
Rodriguez, Richard,12969180.790.000.000.00180.79
Lopez, Carlos,186171147.770.000.000.001147.77
Butler, Dalton, A,133454759.510.000.000.004759.51
Hughes, Nathan, B,121134737.530.000.002294.992442.54

Generated 2024-11-10 04:13:05.551 UTC