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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Patterson, Natalie,16123629.970.000.000.00629.97
Price, Isabelle,201825749.970.003374.990.002374.98
Perry, Olivia,203754438.380.002071.420.002366.96
Nelson, Luis,234884.990.000.000.004.99
Perez, Dalton,110911125.360.000.00331.76793.60
Hill, Carlos,12919257.880.000.00158.9398.95
Campbell, Adam, A,214002688.890.000.002071.42617.47
Navarro, Jerome, B,11519717.280.000.00186.18531.10
Miller, Kayla, A,236734.990.000.000.004.99
Foster, Kayla,1969371.950.000.000.0071.95
Smith, Lucas, P,1809064.910.000.0021.9842.93
Washington, Ian, M,246644368.580.003578.270.00790.31
Rogers, Jade, I,14332102.250.000.000.00102.25
Brown, Nicholas, S,11506675.640.000.00207.39468.25
Peterson, Jared,11502829.370.000.00376.87452.50
Torres, Victoria,17551160.920.000.000.00160.92
Perry, Justin, E,167583062.340.000.000.003062.34
Moore, Chloe, L,2626913.980.000.000.0013.98
Richardson, Evan, J,15488165.300.000.000.00165.30
Stewart, Sara,17347119.720.000.000.00119.72
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Gonzales, Brittany,217104187.233578.270.000.00608.96
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Miller, Eduardo,14561158.840.000.0049.97108.87
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Rogers, Jared, J,12166162.220.000.000.00162.22
Moore, Seth,138512331.950.000.000.002331.95
Kelly, Haley,15511128.560.000.0036.5991.97
Martin, Gina, E,11078793.270.000.00262.33530.94
Wright, Carol, C,12928247.410.000.0033.98213.43
She, Shawn, J,16902141.980.000.000.00141.98
She, Martha, E,222515971.330.003578.270.002393.06
Martin, Samuel,15874225.440.000.0069.99155.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Jenkins, Alexandra, D,11632924.610.000.00295.46629.15
Roberts, Mason, D,111761106.680.000.00608.60498.08
Brown, Morgan,2919778.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Rogers, Shelby,11712127.800.000.0049.8777.93
Davis, Austin, E,133664749.040.000.000.004749.04
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Campbell, Lucas,2932953.990.000.000.0053.99
Coleman, Dylan,27403132.970.000.000.00132.97
Mitchell, Thomas, J,137112380.470.000.000.002380.47
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
Allen, Allison, A,1975737.270.000.000.0037.27
White, Greg, C,174032322.280.000.000.002322.28
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Barnes, Dalton, C,178581700.990.000.000.001700.99
Brown, Jonathan,11875265.420.000.0021.49243.93
Smith, Chloe,17619163.920.000.000.00163.92
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Bryant, Jackson, J,2533239.980.000.000.0039.98
Perry, Dalton, A,16149192.040.000.000.00192.04
Gonzales, Nathan, M,12107222.230.000.0067.27154.96
Blue, Paige,2170313.980.000.000.0013.98
Evans, Alexandra,2432268.490.000.000.0068.49
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Watson, Devin, A,18875114.950.000.000.00114.95
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Thompson, Madison, L,187882351.960.000.000.002351.96
Hernandez, José, M,11253696.610.000.00212.93483.68
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Hall, Eduardo,16847189.940.000.000.00189.94
Alexander, Sarah,1941129.990.000.000.0029.99
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
Reed, Marcus,14582111.790.000.0061.8149.98
Ward, Natalie, J,132412325.960.000.000.002325.96
Scott, Allison,14497804.480.000.000.00804.48
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Phillips, Aaron, R,2494739.980.000.000.0039.98
Alexander, Logan, E,191161183.470.000.000.001183.47
Ross, Natalie, J,12916261.220.000.0068.97192.25
Baker, Sara, M,11827512.470.000.00148.47364.00
Stewart, Lucas, J,2934198.970.000.000.0098.97
Powell, Miranda, J,153044843.000.000.000.004843.00
Sánchez, Angela, C,176551750.980.000.000.001750.98
Evans, Kaylee,19642133.540.000.0056.9776.57
Foster, Eric,229765971.330.003578.270.002393.06
Long, Julia, R,228895971.330.003578.270.002393.06
Reed, Melanie, A,28160574.980.000.000.00574.98
Edwards, Hailey,242584.990.000.000.004.99
Nelson, Jose,19217185.020.000.0091.9593.07
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Peterson, Brian,12892419.470.000.00156.27263.20
Barnes, Ian, M,16106133.540.000.000.00133.54
Ward, Jade, D,14661195.020.000.0074.98120.04
Bailey, Olivia,238924.990.000.000.004.99
Moreno, Lance, A,2922939.980.000.000.0039.98
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Flores, Hannah,1952540.230.000.000.0040.23
Moore, Ian, L,2463939.980.000.000.0039.98
Foster, Isabelle,2637739.980.000.000.0039.98
Turner, Eduardo,158764789.020.000.000.004789.02
Collins, Allison,28581119.980.000.000.00119.98
Price, Caroline,180511735.980.000.000.001735.98
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Collins, Jonathan,16849119.980.000.000.00119.98
Patterson, Eduardo,11142866.810.000.00160.73706.08
Phillips, Kaylee,211384371.380.000.002049.102322.28
Turner, Sean,227324133.240.003578.270.00554.97
Bell, Chase,180911750.980.000.000.001750.98
Sanchez, Stephanie,1786756.970.000.000.0056.97
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Morgan, Isaiah,18978118.730.000.0081.4637.27
Washington, Ryan,2833294.480.000.000.0094.48
Howard, Alyssa, A,11513863.950.000.000.00863.95
Ross, Xavier, A,12202171.470.000.0092.2579.22
Hall, Amber,20106131.950.000.0024.99106.96
Lal, Jack, R,185251735.980.000.000.001735.98
Martin, James, M,1987077.250.000.0039.9837.27
Rodriguez, Natalie,2077330.970.000.000.0030.97
Madan, Carmen, V,155674720.270.000.000.004720.27
Jones, Alexandra, B,2020245.950.000.000.0045.95
Sanders, Angel,16219553.970.000.000.00553.97
Evans, Elijah, S,2588439.980.000.000.0039.98
Coleman, Stephanie,2226489.970.000.000.0089.97
Green, Samuel, D,14096174.730.000.000.00174.73
Alexander, Elijah,11738331.680.000.00141.73189.95
Brown, Anthony, J,19399151.430.000.0081.4669.97
Morris, Abigail, C,287762.290.000.000.002.29
Adams, Mason, T,2052864.470.000.0064.470.00
Sandberg, Isaac,1335053.970.000.0039.9913.98
Alexander, Taylor,17482146.940.000.0076.9769.97
Green, Marcus, C,15974208.410.000.0091.95116.46
Robinson, Sarah, A,2702859.980.000.0059.980.00
King, Morgan,196811179.970.000.000.001179.97
Lewis, Isabella,2624267.930.000.0067.930.00
Alexander, Aidan,17387148.190.000.00148.190.00
Patterson, Hailey, I,112231155.900.000.00465.56690.34
Diaz, Luis, D,11203801.770.000.00317.50484.27
Lopez, Katelyn,11820232.710.000.0092.74139.97
Henderson, Gabrielle, B,186031205.470.000.001205.470.00
Martinez, Andrew, C,11530523.810.000.00194.86328.95
Chapman, Nancy, E,11276840.150.000.00156.71683.44
Sun, Arturo, C,11498557.540.000.00173.39384.15
Green, Gabrielle, M,2181564.470.000.0064.470.00
Simmons, Dakota, T,14110819.460.000.00819.460.00
Flores, Arianna,217274132.243578.270.000.00553.97
Simmons, Sarah, V,11500651.980.000.00155.22496.76
James, Sara,198023374.993374.990.000.000.00
Turner, Blake,12136131.740.000.0027.28104.46
Green, Isabella,26620699.10699.100.000.000.00
Ross, Alexia, S,13231247.900.000.00104.97142.93
Ye, Alisha, J,220084141.233578.270.000.00562.96
Cooper, Paige,14119148.940.000.004.99143.95
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Wright, Jackson,11698225.950.000.00204.4621.49
Martin, Lucas, L,221144183.233578.270.000.00604.96
Hall, Jan, M,11740334.120.000.00235.1598.97
Murphy, Emma,198445807.933374.990.000.002432.94
Jenkins, Samantha,113311290.330.000.00542.74747.59
Martin, Xavier,222335997.330.003578.270.002419.06
Jai, Samuel, L,1635887.950.000.0073.9713.98
Lewis, Seth,26782699.100.00699.100.000.00
Richardson, Erin, R,1633188.850.000.0088.850.00
Collins, Luis, J,227655978.610.003578.270.002400.34
King, Caleb, J,2898678.980.000.000.0078.98
Moore, Taylor, A,199874564.450.003374.990.001189.46
Dominguez, Erika, C,21251191.270.000.000.00191.27
Turner, Courtney, A,229753578.270.003578.270.000.00
Taylor, Christian,2076456.760.000.000.0056.76
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Campbell, Hunter,17422174.920.000.000.00174.92
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Griffin, Jason, L,112001267.110.000.00610.74656.37
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Jackson, Hannah, G,131432404.970.000.000.002404.97
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Henderson, Ashley,111851381.370.000.00262.781118.59
Washington, Caroline, D,231145996.320.003578.270.002418.05
Hughes, Eduardo,15564188.520.000.000.00188.52
Bryant, Kyle,231644807.100.003578.271228.830.00
Moore, Hunter,14897196.270.000.0071.58124.69
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Flores, Kevin,15878225.920.000.0069.97155.95
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Robinson, Emily,12183228.420.000.0054.96173.46
Harris, Megan,232814828.110.003578.271249.840.00
Roberts, Seth, H,11510258.150.000.0039.47218.68
Ware, Dennis, L,237254828.110.003578.270.001249.84
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Bryant, Connor,238424828.110.003578.270.001249.84
Brown, Fernando,1900191.950.000.0069.9721.98
Washington, Vanessa,238194802.110.003578.270.001223.84
Taylor, Madison, A,11802215.290.000.00155.7359.56
Thompson, Jose,237314828.110.003578.270.001249.84
Taylor, Edward, C,17442319.880.000.00230.9088.98
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Ross, Isabelle, D,18554155.450.000.00155.450.00
Martinez, Jill,242354829.390.003578.270.001251.12
Lee, William,13185149.840.000.0074.9674.88
Flores, Xavier,238664828.110.003578.270.001249.84
Wright, Katelyn, A,14502122.260.000.0084.9737.29
Bennett, Seth,244933578.270.003578.270.000.00
Morgan, Jada, A,11520702.990.000.00300.89402.10
Prasad, Molly,243924329.610.003578.27751.340.00
Green, Blake, P,11719287.200.000.0094.48192.72
Murphy, Juan, T,246463578.270.003578.270.000.00
Butler, Isabel,16241126.960.000.0056.9769.99
Garcia, Victoria, V,245013578.270.003578.270.000.00
Rivera, Makayla, A,2878334.990.000.0034.990.00
Li, Connor,201863191.910.002071.420.001120.49
Stewart, Hailey,229036054.220.003578.272475.950.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Sanders, Megan, A,15376136.240.000.0014.98121.26
Turner, Andrea, A,202093268.550.002049.100.001219.45
Martin, Brandon, S,2169139.980.000.0039.980.00
Martin, Morgan,248322181.560.002181.560.000.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Sanders, Paige,252872983.340.002443.350.00539.99
James, Juan,232674862.090.003578.271283.820.00
Ross, Haley, T,253612443.350.002443.350.000.00
Watson, Richard,15943365.410.000.00154.98210.43
Turner, Amanda, L,203183241.900.002071.420.001170.48
Torres, Dalton,235037.280.000.007.280.00
Zhao, Karen, L,254082735.530.002181.560.00553.97
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Price, Stephanie,258922443.350.002443.350.000.00
Smith, Samuel, D,2308349.900.000.000.0049.90
Gomez, Renee, L,253712181.560.002181.560.000.00
Nelson, Jennifer,171471700.990.000.000.001700.99
Price, Jocelyn, D,258752443.350.002443.350.000.00
Collins, Alex, S,287812.290.000.000.002.29
Cox, Lucas, J,253932443.350.002443.350.000.00
Thomas, Logan, A,14091251.200.000.0053.99197.21
Ramirez, Abigail, S,1585974.140.000.0024.2749.87
Bryant, Brittany,2254548.970.000.000.0048.97
Young, Julia, J,274144.990.000.000.004.99
Henderson, Logan, C,2236656.970.000.000.0056.97
Perry, Ana,112151155.520.000.00496.36659.16
Miller, Sydney, A,134404818.530.000.000.004818.53
Davis, James,11922275.500.000.0094.96180.54
Parker, Eduardo, M,12939169.420.000.00110.2059.22
Wright, Robert, C,158894848.030.000.000.004848.03
Perry, Samuel,18811100.960.000.00100.960.00
Allen, Amanda,2235339.980.000.000.0039.98
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Russell, Jacqueline,18391100.960.000.00100.960.00
Bryant, Zachary,216552648.070.000.002648.070.00

Generated 2024-09-19 22:02:27.148 UTC