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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Butler, Cassidy, L,21792114.460.000.000.00114.46
Taylor, Brianna,17027230.900.000.0051.96178.94
Lee, Don,188392384.970.000.000.002384.97
Wang, Austin, A,1463284.970.000.009.9974.98
Coleman, Miguel, D,2740069.990.000.0069.990.00
Evans, Gabriel,2348789.970.000.000.0089.97
Anderson, Daniel,20694146.970.000.00146.970.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Howard, Erin, L,183621725.210.000.000.001725.21
Evans, Maria,22544127.280.000.00127.280.00
Moore, Seth,138512331.950.000.000.002331.95
Richardson, Charles, I,121144719.020.000.002325.962393.06
Henderson, Luke,19200109.240.000.000.00109.24
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Moore, Jessica, J,2008576.760.000.000.0076.76
Yang, Aaron, C,2519654.980.000.000.0054.98
Green, Kaylee, C,2618567.970.000.000.0067.97
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Nelson, Luis,234884.990.000.000.004.99
Phillips, Aaron, R,2494739.980.000.000.0039.98
Davis, Dylan,15556588.960.000.00588.960.00
Jai, Logan, H,12031769.490.000.000.00769.49
Patterson, Taylor,12147271.450.000.000.00271.45
Clark, Miguel, D,169872414.990.000.000.002414.99
Phillips, Luis, G,207347.280.000.000.007.28
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Adams, Mason, T,2052864.470.000.0064.470.00
Martin, Thomas, A,169521735.980.000.000.001735.98
Lobao, Alexandre,1892691.950.000.0091.950.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Harris, Jacob, G,2367939.980.000.0039.980.00
Peterson, Steven, L,234497.280.000.007.280.00
Thomas, Dalton,230097.280.000.000.007.28
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Cooper, Angela,195261179.470.000.000.001179.47
Evans, Jesse,2191639.980.000.000.0039.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Barnes, Ian, M,16106133.540.000.000.00133.54
Garcia, Anna, B,15572104.550.000.000.00104.55
Hernandez, Jamie,27283119.980.000.00119.980.00
Thomas, Edward, E,19147133.710.000.000.00133.71
Rivera, Rachel, S,2899678.980.000.000.0078.98
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Alexander, Julia, J,15291889.470.000.000.00889.47
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Harris, Natalie,2368259.980.000.0059.980.00
Young, Jenna, W,163652490.180.000.000.002490.18
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Ward, Kaylee, A,244154.990.000.004.990.00
Prasad, Summer, M,2214339.980.000.0039.980.00
Foster, Aaron,155664912.470.000.000.004912.47
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Flores, Gabriel,271117.280.000.000.007.28
Jones, Alexandra, B,2020245.950.000.000.0045.95
Richardson, Brian,2860878.980.000.000.0078.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Gonzales, Paige,2170291.940.000.0039.9851.96
Roberts, Robert, R,1898656.970.000.0056.970.00
Martin, Noah, A,1765775.970.000.0075.970.00
Mitchell, Bailey, B,267067.280.000.007.280.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Martinez, Grace, M,17385208.690.000.0069.97138.72
Flores, Julia, E,172631700.990.000.000.001700.99
Ross, Miranda,145984839.000.000.000.004839.00
Collins, Sierra,185491169.460.000.001169.460.00
Morgan, Marcus, W,289682.290.000.000.002.29
Washington, Aaron, L,246494.990.000.000.004.99
Thompson, Madison, L,187882351.960.000.000.002351.96
White, Emily, M,159174679.060.000.000.004679.06
Thames, Bernard,2380368.490.000.000.0068.49
Ward, Cole,214907.280.000.000.007.28
Alexander, Angelica,2271471.950.000.000.0071.95
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Collins, Amanda,2078339.980.000.000.0039.98
Gonzalez, Molly,1637021.980.000.000.0021.98
Mehta, Carmen, C,2743694.480.000.000.0094.48
Blue, Melanie, L,178611749.960.000.000.001749.96
Sara, Ivan, L,2509067.930.000.000.0067.93
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Rivera, Amanda,11131115.920.000.000.00115.92
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Alexander, Caroline,176541759.970.000.000.001759.97
Robinson, Joseph,2814194.480.000.0094.480.00
Shan, Gabriel, T,2773169.990.000.000.0069.99
Moore, Wyatt, F,189712351.960.000.000.002351.96
Sanders, Angel,16219553.970.000.000.00553.97
Harris, Joshua, L,2028095.940.000.0030.9764.97
Gray, Sara,292472447.050.000.002447.050.00
Adams, Gabriel, S,195271219.450.000.000.001219.45
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Anderson, Tyler, E,131481137.430.000.001137.430.00
Barnes, Dalton, C,178581700.990.000.000.001700.99
Washington, Emma,191231170.480.000.000.001170.48
Peterson, Xavier, R,2645639.980.000.000.0039.98
Martin, Christian, V,19709197.250.000.000.00197.25
Griffin, Miguel,2146476.970.000.000.0076.97
Harris, Noah,292562393.060.000.002393.060.00
Washington, Ryan,2833294.480.000.000.0094.48
Kumar, Cameron, S,185711120.490.000.001120.490.00
Gonzalez, Morgan,130651700.990.000.000.001700.99
Robinson, Lauren,2719668.490.000.0068.490.00
Allen, Allison, A,1975737.270.000.000.0037.27
Reed, Michelle,2804669.990.000.000.0069.99
Morris, Jessica,289678.990.000.008.990.00
Ward, Destiny,16128539.990.000.000.00539.99
Griffin, Marcus,2075634.560.000.000.0034.56
Perez, Jonathan, R,2345512.940.000.000.0012.94
Scott, Eric,282484.990.000.004.990.00
Gray, Sebastian, B,138782366.960.000.000.002366.96
Rogers, Andrea, L,14328308.660.000.0049.97258.69
Anderson, Jasmine, A,235534.990.000.000.004.99
Evans, Elijah, S,2588439.980.000.000.0039.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Hall, Taylor, J,169951735.980.000.000.001735.98
Taylor, Marcus, A,18944146.940.000.000.00146.94
Henderson, Abigail,2044139.980.000.000.0039.98
Murphy, Brianna, K,2834269.990.000.000.0069.99
Henderson, Hailey, C,171481775.470.000.000.001775.47
Barnes, Kayla,2425639.980.000.000.0039.98
Johnson, Madison, L,15530846.460.000.000.00846.46
Lewis, Christopher,1875586.960.000.000.0086.96
Srini, Evelyn,16855150.950.000.000.00150.95
Gray, Jared, A,264494.990.000.000.004.99
Foster, Nicole, A,2349489.970.000.000.0089.97
Torres, Christina, M,20746119.950.000.000.00119.95
Howard, Danielle,28357133.490.000.000.00133.49
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Turner, Kaylee, M,16213154.540.000.000.00154.54
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Parker, Jeremy,2866878.980.000.000.0078.98
Anderson, Madison, G,2835978.980.000.000.0078.98
Smith, Nathan,217647.280.000.000.007.28
Bell, Brooke, H,2325339.980.000.000.0039.98
Cox, Sara, P,2775869.990.000.000.0069.99
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Van, Bobby,27757132.970.000.000.00132.97
Murphy, Maria,160113657.260.000.000.003657.26
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Kennedy, Bridget,2202639.980.000.000.0039.98
Bailey, Alexandria, V,132092319.990.000.000.002319.99
White, Greg, C,174032322.280.000.000.002322.28
Griffin, James,28189567.760.000.000.00567.76
Jones, Alexander, I,2002180.960.000.000.0080.96
Sanders, Sean,14341175.150.000.000.00175.15
Hughes, Austin, P,183681754.980.000.000.001754.98
Lewis, Morgan,17410168.740.000.000.00168.74
Allen, Madeline,2924068.970.000.000.0068.97
Richardson, Lauren, C,14867839.480.000.000.00839.48
Nath, Alison, J,171161764.960.000.000.001764.96
Perez, Timothy, L,227304.990.000.000.004.99
Russell, Richard,2763322.260.000.000.0022.26
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Blue, Paige,2170313.980.000.000.0013.98
Watson, Devin, A,18875114.950.000.000.00114.95
Evans, Alexandra,2432268.490.000.000.0068.49
Johnson, Jonathan,220597.280.000.000.007.28
James, Zoe, R,14611304.550.000.000.00304.55
Jones, Kayla, C,1854194.260.000.000.0094.26
Wang, Zachary,2214489.970.000.000.0089.97
Reed, Gabriella, A,2743778.980.000.000.0078.98
Gonzales, Gavin,2448813.980.000.000.0013.98
Li, Brandon,2933973.960.000.000.0073.96
Washington, Adam, G,2543713.980.000.000.0013.98
Chen, Ethan,2054756.970.000.000.0056.97
Nath, Kenneth, W,170372334.970.000.000.002334.97
Brown, Julia,18065155.470.000.000.00155.47
Stewart, Lucas, J,2934198.970.000.000.0098.97
Ward, Natalie, J,132412325.960.000.000.002325.96
Williams, Joshua,260514.990.000.000.004.99
Simmons, Nicole, S,2617729.480.000.000.0029.48
Chen, David,2720839.980.000.000.0039.98
Russell, Katherine,2877169.990.000.000.0069.99
Collins, Charles, B,29041628.450.000.000.00628.45
Moreno, Lance, A,2922939.980.000.000.0039.98
Williams, Sydney, J,15334848.470.000.000.00848.47
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Brooks, Steven, C,14877889.470.000.000.00889.47
Flores, Hannah,1952540.230.000.000.0040.23
Gutierrez, Neil, L,214897.280.000.000.007.28
Lewis, Ethan,27998144.470.000.000.00144.47
Flores, Miguel,1975077.250.000.000.0077.25
Brooks, Evan,2340139.980.000.000.0039.98
Roberts, Amanda,171752334.980.000.000.002334.98
Long, Sarah,173721729.970.000.000.001729.97
Edwards, Elijah, D,281577.280.000.000.007.28
Johnson, Cameron, R,137201155.480.000.000.001155.48
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Anderson, Ryan, W,132712319.990.000.000.002319.99
Scott, Mason,2355139.980.000.000.0039.98
Foster, Alyssa, I,14875839.480.000.000.00839.48
Rogers, Bryce,174022304.980.000.000.002304.98
Alvarez, Melody,2507068.490.000.000.0068.49
Parker, Kaylee, M,2773878.980.000.000.0078.98
Adams, Katherine, M,235184.990.000.000.004.99
Coleman, Stephanie,2226489.970.000.000.0089.97
Sanders, Mason, G,2345939.980.000.000.0039.98
Stewart, Marcus, R,2063221.980.000.000.0021.98
Gonzales, Jose,2201439.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Bryant, Dakota, L,176132401.950.000.000.002401.95
Ward, Mariah, J,2158044.910.000.000.0044.91
Edwards, Hunter,2422067.930.000.000.0067.93
Richardson, Devin, G,2131836.960.000.000.0036.96
Gray, Cindy, A,13198114.950.000.0099.9714.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Rivera, Hailey, R,2079239.980.000.000.0039.98
Smith, Samuel, D,2308349.900.000.000.0049.90
Campbell, Natalie, L,115122319.990.000.000.002319.99
Russell, Nicole, M,182372318.960.000.000.002318.96
Russell, Caleb,23552103.480.000.000.00103.48
Reed, Morgan, E,2877923.970.000.000.0023.97
Malhotra, Brenda,133912405.470.000.000.002405.47
Brown, Fernando,1900191.950.000.0069.9721.98
Baker, Gabriella,174041709.980.000.000.001709.98
Robinson, Madison, W,183772394.970.000.000.002394.97
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Martin, Katherine, J,2027339.980.000.000.0039.98
Li, Eugene, A,15283865.950.000.000.00865.95
Green, Xavier,2356739.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Hall, Jason, A,29351119.980.000.000.00119.98
Adams, Julia, N,2607359.980.000.000.0059.98
Stewart, Alexandria,174761700.990.000.000.001700.99
Thompson, Lucas, O,212774.990.000.000.004.99
Johnson, Jacob, I,28069553.970.000.000.00553.97
Perez, Barry, M,2728269.990.000.000.0069.99
Rogers, Olivia,12020804.470.000.000.00804.47
Wang, Benjamin, R,274547.280.000.000.007.28
Gray, Marcus, T,183892401.450.000.000.002401.45
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Smith, Megan, J,2671668.970.000.000.0068.97
Coleman, Ian,2127639.980.000.000.0039.98
Johnson, Ian, E,2173283.470.000.000.0083.47
Hill, Eric, G,2525667.930.000.0067.930.00
Ross, Seth, M,184332329.980.000.000.002329.98
Hall, Fernando,2210090.950.000.000.0090.95
Li, Thomas,181162376.960.000.000.002376.96
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Lee, Samantha, B,2737878.980.000.000.0078.98
Reed, Megan, A,181181750.980.000.000.001750.98
Bell, Garrett, J,14265161.230.000.000.00161.23
Adams, Kyle, E,1881269.990.000.0069.990.00
Ramirez, Richard, C,282397.280.000.007.280.00
Phillips, Haley, B,2807939.980.000.000.0039.98
Roberts, Jordan, M,1680039.250.000.000.0039.25
Clark, Zachary, J,2389358.980.000.000.0058.98
Foster, Isabel, M,2174571.950.000.000.0071.95
Stewart, Melissa,2517336.960.000.000.0036.96

Generated 2024-11-10 03:25:37.044 UTC