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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Anand, Brendan, L,1984721.980.000.000.0021.98
Walker, Jacob, N,29027574.980.000.000.00574.98
Martinez, Andrew, C,11530523.810.000.00194.86328.95
Barnes, Elizabeth, J,249397.280.000.000.007.28
Harris, Megan,232814828.110.003578.271249.840.00
Bradley, Melanie, G,133434720.270.000.002319.262401.01
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Williams, Joshua,260514.990.000.000.004.99
Jones, Michael, A,2210771.970.000.000.0071.97
White, Judith, R,148851155.480.000.000.001155.48
Russell, Jacqueline,18391100.960.000.00100.960.00
Hughes, Zachary,12203157.910.000.000.00157.91
Barnes, Kayla,2425639.980.000.0039.980.00
Prasad, Summer, M,2214339.980.000.0039.980.00
White, Abigail, T,15866145.820.000.0038.88106.94
Martin, Katherine, J,2027339.980.000.000.0039.98
Sanders, Xavier,1672173.750.000.0023.7849.97
Parker, Natalie, A,251043018.330.002443.35574.980.00
Sanchez, Faith,270494.990.000.004.990.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Russell, Fernando,27084782.990.00782.990.000.00
Malhotra, Brenda,133912405.470.000.000.002405.47
Smith, Andrew,1472387.570.000.0047.5839.99
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Gomez, Krista,12760273.180.000.0036.27236.91
Carter, Jesse, E,22141166.280.000.000.00166.28
Lal, Robert, L,14084138.680.000.0035.00103.68
Navarro, Jerome, B,11519717.280.000.00186.18531.10
Hall, Noah, A,1525175.250.000.0068.976.28
Baker, Mason, A,132702394.950.000.000.002394.95
Reed, Mariah,263731565.910.001000.440.00565.47
Moreno, Renee, C,12936265.220.000.000.00265.22
Murphy, Maria,160113657.260.000.000.003657.26
Adams, Carlos,1982236.960.000.000.0036.96
Bell, Alex, M,167543118.600.000.00756.332362.27
Martin, Lucas, L,221144183.233578.270.000.00604.96
Powell, Ian,2608564.470.000.000.0064.47
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Cooper, Brian, L,13760128.840.000.000.00128.84
Smith, Lucas, P,1809064.910.000.0021.9842.93
James, Christina,17409219.920.000.000.00219.92
Ross, Natalie, J,12916261.220.000.0068.97192.25
Roberts, Rebecca,2800094.480.000.000.0094.48
Evans, Elijah, S,2588439.980.000.000.0039.98
Williams, Zachary, B,27099782.990.000.00782.990.00
Parker, Blake,15008170.530.000.0074.9895.55
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
Chow, Candice,1923260.960.000.000.0060.96
Garcia, Victoria, V,245013578.270.003578.270.000.00
Powell, Katherine, C,14574177.600.000.000.00177.60
Zhao, Clarence, R,1982671.970.000.0071.970.00
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
White, Cameron,238304802.110.003578.270.001223.84
Thompson, Tyler,2750269.990.000.0069.990.00
Hughes, Samantha,2721564.470.000.000.0064.47
Miller, Chloe, V,228936056.510.003578.272478.240.00
Thomas, Isabella, M,27265782.990.000.00782.990.00
Washington, Alexandra, E,15498256.520.000.00223.9232.60
White, Jennifer, S,27027782.990.00782.990.000.00
Gonzales, Gavin,2448813.980.000.000.0013.98
Diaz, Brandon,236764.990.000.004.990.00
Brown, Fernando,1900191.950.000.0069.9721.98
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Long, Sydney,279217.280.000.000.007.28
Sun, Arturo, C,11498557.540.000.00173.39384.15
Long, Julia, R,228895971.330.003578.270.002393.06
Davis, Nicholas,1320173.160.000.000.0073.16
Collins, Isaac,260777.280.000.000.007.28
Watson, Michelle, H,262352181.560.000.002181.560.00
Anderson, Megan, A,238594153.250.003578.27574.980.00
Mitchell, Bailey, B,267067.280.000.007.280.00
Lal, Luke, L,11019698.230.000.00156.20542.03
Thompson, Abigail,243324816.090.003578.270.001237.82
Martin, Alfredo, P,2148039.980.000.000.0039.98
Moore, Taylor, A,199874564.450.003374.990.001189.46
Turner, Sean,227324133.240.003578.270.00554.97
James, Sara,198023374.993374.990.000.000.00
Price, Stephanie,258922443.350.002443.350.000.00
Mitchell, Caleb, K,268064.990.000.000.004.99
Bradley, Rachel,158504813.040.000.000.004813.04
Perry, Oscar,227856029.570.003578.272451.300.00
Flores, Hannah,1952540.230.000.000.0040.23
Roberts, Robert, R,1898656.970.000.0056.970.00
Brown, Samantha, G,2514739.980.000.000.0039.98
Cox, Devin, C,134184768.050.000.002329.992438.06
Sanders, Mason, G,2345939.980.000.000.0039.98
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Bailey, Hailey, R,262704.990.000.000.004.99
Suarez, Juan, R,167631700.990.000.001700.990.00
Parker, Kaylee, M,2773878.980.000.000.0078.98
Johnson, James,234984.990.000.004.990.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Russell, Melanie, B,15478182.830.000.00167.8514.98
Rodriguez, Taylor,1607166.960.000.000.0066.96
Wright, Jackson,11698225.950.000.00204.4621.49
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Powell, Caleb, G,216132610.580.000.002049.10561.48
Gill, Robyn, J,127651750.980.000.001750.980.00
Ross, Isabelle, D,18554155.450.000.00155.450.00
Huang, Kristen,251002443.350.002443.350.000.00
Lopez, Jack, I,2904751.460.000.000.0051.46
Ortega, Javier, P,127852294.990.000.000.002294.99
Li, Kevin, S,2518813.980.000.0013.980.00
Butler, Benjamin, C,189722369.970.000.000.002369.97
Bell, Brooke, H,2325339.980.000.000.0039.98
Wang, Karen, P,1955331.970.000.000.0031.97
Lewis, Ryan, A,203124.990.000.004.990.00
Turner, Kaylee, M,16213154.540.000.000.00154.54
Cook, Joan,235544.990.000.000.004.99
Chen, Luis, G,2125294.450.000.0094.450.00
Peterson, Jessica, M,11868247.010.000.0076.95170.06
Peterson, Jared,11502829.370.000.00376.87452.50
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Reed, Kaylee, R,17371151.920.000.000.00151.92
Edwards, Connor,16950211.010.000.0023.97187.04
White, Miguel, S,13988195.520.000.000.00195.52
Flores, Emma, P,15543180.940.000.0078.98101.96
Torres, Mackenzie,28153570.470.000.000.00570.47
Lee, Kayla, M,2078115.230.000.000.0015.23
Hughes, Miranda,266784.990.000.000.004.99
Campbell, Chloe,11212760.930.000.00307.78453.15
Campbell, Hailey,15507267.840.000.00228.9638.88
Jackson, Hannah, G,131432404.970.000.000.002404.97
Murphy, Emma,198445807.933374.990.000.002432.94
James, Emma,127812329.980.000.000.002329.98
Foster, Emma,15468436.350.000.00159.99276.36
Cooper, Andrea,2932378.980.000.000.0078.98
Butler, Victoria,132844767.530.000.002374.472393.06
Alexander, Taylor,17482146.940.000.0076.9769.97
Carter, Madeline, A,2752269.990.000.000.0069.99
Rogers, Jared, J,12166162.220.000.000.00162.22
Walker, Ian,16771104.550.000.0054.5849.97
Powell, David, W,266151000.440.000.001000.440.00
Srini, Evelyn,16855150.950.000.000.00150.95
Johnson, Xavier, R,2325539.980.000.0039.980.00
Jones, Alexandra, B,2020245.950.000.000.0045.95
Phillips, Devin,18759112.060.000.000.00112.06
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Clark, William,2902169.990.000.000.0069.99
Bailey, Morgan, E,213542646.400.000.002646.400.00
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Martin, Brianna, M,235834829.390.003578.270.001251.12
Bryant, Connor,238424828.110.003578.270.001249.84
Price, Jeremy,259892744.520.002181.560.00562.96
Watson, Cole, A,217684118.263578.270.00539.990.00
Russell, Caleb,23552103.480.000.000.00103.48
Alexander, Edward, E,18524195.950.000.000.00195.95
Cox, Lucas, J,253932443.350.002443.350.000.00
Griffin, Miguel,2146476.970.000.000.0076.97
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Jackson, Brianna,1537797.910.000.0074.9822.93
Sanchez, Stephanie,1786756.970.000.000.0056.97
Edwards, Logan,250024.990.000.000.004.99
Russell, Ian, T,2474613.980.000.0013.980.00
King, Caleb, J,2898678.980.000.000.0078.98
Rowe, Todd,14586233.940.000.000.00233.94
Simmons, Nicole, S,2617729.480.000.000.0029.48
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Williams, Sydney, J,15334848.470.000.000.00848.47
Hayes, Oscar,2652729.260.000.000.0029.26
Washington, Kayla, E,14655174.960.000.00174.960.00
Peterson, Mason, A,185701174.480.000.001174.480.00
Lopez, Carlos,186171147.770.000.001147.770.00
Baker, Robert, A,273007.280.000.007.280.00
Washington, Robert, J,14906143.950.000.000.00143.95
Hall, Kaylee, E,1975137.270.000.000.0037.27
Alexander, Luke,290432447.050.000.002447.050.00
Thomas, Jessica,1684894.480.000.0094.480.00
Hughes, Anna,197052341.970.000.000.002341.97
Jenkins, Samantha,113311290.330.000.00542.74747.59
Butler, Cassidy, L,21792114.460.000.000.00114.46
Price, Miranda,26629699.10699.100.000.000.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Jenkins, Alexandra, D,11632924.610.000.00295.46629.15
Thomas, Victoria, A,15536249.530.000.000.00249.53
Stewart, Makayla,16649115.940.000.000.00115.94
Rogers, Faith,2468259.980.000.000.0059.98
He, Micah,2740169.990.000.0069.990.00
Hall, Jan, M,11740334.120.000.00235.1598.97
Coleman, Isabel, S,12530337.900.000.00193.95143.95
Jones, Joshua,184012294.990.000.000.002294.99
Hall, Jason, A,29351119.980.000.000.00119.98
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Martin, James, M,1987077.250.000.0039.9837.27
Barnes, Haley, J,2133939.980.000.0039.980.00
Patterson, Austin, O,270247.280.000.000.007.28
Perry, Samuel,18811100.960.000.00100.960.00
Foster, Edward, R,18355150.950.000.000.00150.95
Hughes, Edward,200234530.470.003374.990.001155.48
Stewart, Alexandria,174761700.990.000.000.001700.99
Thompson, Isabella,18756128.410.000.000.00128.41
Parker, Morgan, S,1677236.960.000.0014.9821.98
Barnes, Emily, G,15996564.990.000.000.00564.99
Evans, Kaylee,19642133.540.000.0056.9776.57
Zhao, Karen, L,254082735.530.002181.560.00553.97
Stewart, Sara,17347119.720.000.000.00119.72
Clark, Joseph, D,153954780.020.000.000.004780.02
Henderson, Justin, P,235917.280.000.007.280.00
Robinson, William,20103103.480.000.00103.480.00
Foster, Paige,2742894.480.000.000.0094.48
Jai, Logan, H,12031769.490.000.000.00769.49
Edwards, Elijah, D,281577.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Hayes, Logan, J,19026113.240.000.0037.2775.97
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Carter, Savannah, M,120902350.960.000.002350.960.00
Green, Eric,2738069.990.000.000.0069.99
Brooks, Allison,146054750.010.000.000.004750.01
Stewart, Alex, M,2008463.150.000.000.0063.15
Hernandez, Haley, L,11769478.950.000.0078.98399.97
Howard, Brianna, D,246304.990.000.000.004.99
Torres, Dalton,235037.280.000.007.280.00
Bryant, Brittany,2254548.970.000.000.0048.97
Griffin, Jordan,13095328.890.000.0069.97258.92
Edwards, Angel, J,2912469.990.000.000.0069.99
Roberts, Amanda,171752334.980.000.000.002334.98
Reed, Bryan,18884133.930.000.000.00133.93
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Ross, Jose,2744178.980.000.0078.980.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Turner, Wyatt,200345769.960.003399.990.002369.97
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Murphy, Dalton, N,27043782.990.00782.990.000.00
Alexander, Aidan,17387148.190.000.00148.190.00
Henderson, Gabrielle, B,186031205.470.000.001205.470.00
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Moore, Fernando,265821000.440.000.001000.440.00
Watson, Devin, A,18875114.950.000.000.00114.95
Thomas, Samantha,2169093.970.000.0093.970.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Ross, Kelly,2607676.960.000.000.0076.96
Collins, Alex, S,287812.290.000.000.002.29
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Smith, Eduardo,2069139.980.000.0039.980.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Shan, Logan,1867760.960.000.0060.960.00
Diaz, Gabrielle,14893839.480.000.000.00839.48
Nelson, Sierra,161322459.620.000.002459.620.00
Wright, Jennifer,2650559.980.000.0059.980.00
Ye, Alisha, J,220084141.233578.270.000.00562.96
Lopez, Katelyn,11820232.710.000.0092.74139.97
Sanders, Paige,252872983.340.002443.350.00539.99
Shan, Christian, L,2308439.980.000.000.0039.98
Morgan, Jada, A,11520702.990.000.00300.89402.10
Kumar, Elijah,15197156.920.000.000.00156.92
Flores, Julia, E,172631700.990.000.000.001700.99

Generated 2024-09-20 00:40:22.107 UTC