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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Blanco, Armando, F,139182397.950.000.000.002397.95
Johnson, Madison, L,15530846.460.000.000.00846.46
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Diaz, Luke,12054402.530.000.00139.97262.56
Srini, Evelyn,16855150.950.000.000.00150.95
Li, Eugene, A,15283865.950.000.000.00865.95
Thompson, Lucas, O,212774.990.000.000.004.99
Turner, Kaylee, M,16213154.540.000.000.00154.54
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Butler, Jackson, J,183241735.980.000.000.001735.98
Jones, Alexander, I,2002180.960.000.000.0080.96
Kelly, Bailey, R,28284563.770.000.000.00563.77
Diaz, Alyssa,139084715.330.000.002294.992420.34
Griffin, Jack, L,1768632.280.000.0032.280.00
Adams, Miguel,11659213.520.000.0064.97148.55
Liu, Arturo,13222150.410.000.0088.4461.97
Shan, Logan,1867760.960.000.0060.960.00
Griffin, Thomas, J,19015125.430.000.00125.430.00
Taylor, Brianna,17027230.900.000.00145.4285.48
Foster, Antonio,12795108.540.000.0066.2642.28
Hall, Natalie, A,230704.990.000.004.990.00
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Price, Mariah, C,2074549.480.000.000.0049.48
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Jai, Edwin,169211754.980.000.000.001754.98
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Washington, Hannah, A,291307.280.000.007.280.00
Carter, Bailey,213322616.860.000.002616.860.00
Cooper, Ariana,17348205.420.000.000.00205.42
Patterson, Alexis,213484392.020.000.002049.102342.92
White, Edward, J,15847205.460.000.000.00205.46
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Peterson, Christina,2897694.480.000.000.0094.48
Bailey, Mariah, L,2724354.980.000.0054.980.00
Harris, Matthew,14330806.760.000.000.00806.76
Evans, Luke,2917615.230.000.0015.230.00
Moreno, Marie,2773969.990.000.000.0069.99
Robinson, Sarah, A,2702859.980.000.0059.980.00
Barnes, Emily, G,15996564.990.000.000.00564.99
Lewis, Isabella,2624267.930.000.0067.930.00
Hill, Jordan, J,16005198.730.000.00102.2796.46
Simmons, Dakota, T,14110819.460.000.00819.460.00
Turner, Samuel,2742069.990.000.0069.990.00
Turner, Blake,12136131.740.000.0027.28104.46
Hall, Jose, J,17601225.420.000.00155.4569.97
Ross, Alexia, S,13231247.900.000.00104.97142.93
Chen, Luis, G,2125294.450.000.0094.450.00
Ward, Stephanie, A,27429782.990.000.00782.990.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Powell, David, W,266151000.440.000.001000.440.00
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Ward, Kaylee, A,244154.990.000.004.990.00
Garcia, Lucas,27545782.990.000.00782.990.00
Griffin, Jennifer, B,14244154.960.000.0069.9984.97
Hall, Kaylee, E,1975137.270.000.000.0037.27
Washington, Alexia,27613782.990.000.00782.990.00
Foster, Edward, R,18355150.950.000.000.00150.95
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Washington, Riley, L,185441155.480.000.001155.480.00
Ross, Miranda,145984839.000.000.000.004839.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Butler, Isabel,16241126.960.000.0056.9769.99
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Zhao, Clarence, R,1982671.970.000.0071.970.00
Rivera, Makayla, A,2878334.990.000.0034.990.00
Lee, Samantha, B,2737878.980.000.000.0078.98
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Sanders, Megan, A,15376136.240.000.0014.98121.26
White, Emma, N,16090604.960.000.000.00604.96
Parker, Katherine,13268289.700.000.0068.97220.73
Martin, Brandon, S,2169139.980.000.0039.980.00
Murphy, Maria,160113657.260.000.000.003657.26
Gomez, Krista,12760273.180.000.0036.27236.91
Hughes, Brittany,14387898.460.000.00898.460.00
Griffin, Jordan,13095328.890.000.0069.97258.92
Allen, Sean, L,12097159.220.000.000.00159.22
Hayes, Brittany,13941286.820.000.0038.88247.94
Kumar, Austin,204834400.060.002049.100.002350.96
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Allen, Luke,113162349.980.000.002349.980.00
Cooper, Amanda, P,146064716.020.000.000.004716.02
Martinez, Joseph, E,2921459.980.000.0059.980.00
Alexander, Luke,290432447.050.000.002447.050.00
Patterson, Taylor,12147271.450.000.000.00271.45
Prasad, Summer, M,2214339.980.000.0039.980.00
Nelson, Sierra,161322459.620.000.002459.620.00
Bennett, Antonio, C,11631707.500.000.00266.33441.17
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Alexander, Ryan, J,14078839.480.000.00839.480.00
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Stewart, Alex, M,2008463.150.000.000.0063.15
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Phillips, Adam, R,227484188.240.003578.270.00609.97
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Kelly, Erin, D,2351364.470.000.000.0064.47
Torres, Xavier,16840176.950.000.000.00176.95
Diaz, Hailey, W,116932294.990.000.002294.990.00
Adams, Katherine, M,235184.990.000.000.004.99
Ramos, Derrick,18449100.940.000.0030.9769.97
Robinson, William,20103103.480.000.00103.480.00
Watson, Cole, A,217684118.263578.270.00539.990.00
Collins, Sierra,185491169.460.000.001169.460.00
Lal, Robert, L,14084138.680.000.0035.00103.68
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Thomas, Matthew, K,13239185.700.000.000.00185.70
Cox, Devin, C,134184768.050.000.002329.992438.06
Price, Miranda,26629699.10699.100.000.000.00
She, Kenneth,16096212.010.000.0080.96131.05
Price, Riley, R,139094764.020.000.002344.962419.06
Bailey, Richard, N,220504160.533578.270.000.00582.26
King, Gabrielle,263504.990.000.000.004.99
Hall, Noah, A,1525175.250.000.0068.976.28
Reed, Paige,221126047.323578.270.002469.050.00
Green, Marcus, C,15974208.410.000.0091.95116.46
Lewis, Ryan, A,203124.990.000.004.990.00
Powell, Vanessa,26630699.10699.100.000.000.00
Lee, James, J,2881769.990.000.0069.990.00
Diaz, Thomas, O,16020595.960.000.00595.960.00
Lopez, Eduardo, J,266401288.06699.100.000.00588.96
Thompson, Brianna, X,1864269.970.000.000.0069.97
Bradley, Melanie, G,133434720.270.000.002319.262401.01
Perry, Melissa,221284142.230.003578.270.00563.96
Jackson, Brianna,1537797.910.000.0074.9822.93
Thomas, Logan, A,14091251.200.000.0053.99197.21
Murphy, Richard, M,222994145.540.003578.270.00567.27
Turner, James, E,16841126.960.000.0069.9956.97
Hall, Elizabeth, L,13474339.480.000.0068.97270.51
Bell, Gabrielle,223735976.320.003578.270.002398.05
James, Richard, D,15760109.230.000.003.99105.24
Ramirez, Makayla, L,1750998.720.000.0037.2761.45
Brooks, Makayla,222526047.320.003578.270.002469.05
Hill, Eric, G,2525667.930.000.0067.930.00
Johnson, Christopher,119794813.760.000.004813.760.00
Howard, Morgan, T,229713578.270.003578.270.000.00
Bryant, Rachel,220197.280.000.007.280.00
Russell, Ian, T,2474613.980.000.0013.980.00
Long, Jordan,199884555.470.003399.990.001155.48
Li, Jordan,17026261.390.000.00261.390.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Gill, Beth,199975814.980.003374.990.002439.99
Ashe, Alexis, S,194141145.480.000.000.001145.48
Evans, Maria,22544127.280.000.00127.280.00
Thompson, Ethan,199894495.480.003374.990.001120.49
Russell, Chloe, M,12763589.960.000.000.00589.96
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Shan, Benjamin,235663578.270.003578.270.000.00
White, Nicole,16731155.910.000.0084.9670.95
Gonzalez, James, M,188421155.480.000.001155.480.00
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Luo, Franklin, J,2202759.980.000.000.0059.98
Coleman, Benjamin, F,234865343.230.003578.270.001764.96
Hayes, Logan, J,19026113.240.000.0037.2775.97
Brooks, Ian, W,2829064.470.000.000.0064.47
Martin, Brianna, M,235834829.390.003578.270.001251.12
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Miller, Sydney, A,134404818.530.000.000.004818.53
Foster, Olivia,238063578.270.003578.270.000.00
Cooper, Angela,195261179.470.000.000.001179.47
Hayes, Luis,12880200.730.000.000.00200.73
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Stewart, Cindy,14496804.480.000.000.00804.48
Ross, Jose,2744178.980.000.0078.980.00
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Davis, Marcus, T,17337123.910.000.0086.9536.96
Torres, Taylor,16666205.440.000.00123.9881.46
Jones, Madison,246614181.760.003578.27603.490.00
Thomas, Ian,191181120.490.000.000.001120.49
Alexander, Paige, W,1860459.250.000.0037.2721.98
Sanchez, Alex, K,131014736.030.000.002351.962384.07
Clark, Emily, R,120862294.990.000.000.002294.99
Walker, Hunter,271007.280.000.007.280.00
Watson, Marcus,2271585.480.000.000.0085.48
Walker, Isabella,243864143.740.003578.27565.470.00
Taylor, Christian,2076456.760.000.000.0056.76
Fernandez, Cesar,200355694.980.003374.990.002319.99
Phillips, Isaiah,28631144.470.000.00144.470.00
Baker, Sean, T,247782858.490.002181.56676.930.00
Griffin, Haley, L,1892582.180.000.000.0082.18
Garcia, Carmen, J,247812181.560.002181.560.000.00
Taylor, Natalie, M,14338828.740.000.000.00828.74
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Martin, John, A,144364776.010.000.000.004776.01
Jai, Adam,250952443.350.002443.350.000.00
Phillips, Devin,18759112.060.000.000.00112.06
Huang, Kristen,251002443.350.002443.350.000.00
Rodriguez, Destiny, J,227397.280.000.007.280.00
White, Jennifer, S,27027782.990.00782.990.000.00
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Clark, Anthony,27071782.990.00782.990.000.00
Howard, Isaiah,259813018.330.002443.350.00574.98
Williams, Morgan, C,203733226.900.002071.420.001155.48
Anderson, Lucas,2926639.980.000.0039.980.00
Bailey, Morgan, E,213542646.400.000.002646.400.00
Wilson, Fernando,16643126.960.000.0056.9769.99
Thomas, Dylan,198737.280.000.007.280.00
Lu, Alejandro,2562039.980.000.0039.980.00
Parker, James,11808610.190.000.00351.22258.97
Chen, James, D,11641303.200.000.00235.9367.27
Murphy, Shelby,244894.990.000.004.990.00
Hill, Fernando,247634.990.000.004.990.00
Taylor, Zachary, M,27082782.990.00782.990.000.00
Griffin, Cassidy,264961000.440.000.001000.440.00
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Wilson, Christian,27085782.990.000.00782.990.00
Ramirez, Ian,166783162.310.000.00742.352419.96
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Deng, Wayne,2145336.960.000.0036.960.00
Diaz, Hunter, S,27242782.990.000.00782.990.00
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
White, Christopher, R,260492181.560.000.002181.560.00
Roberts, Carlos,2319639.980.000.000.0039.98
James, Timothy,213312670.890.000.002670.890.00
Gonzalez, Morgan,130651700.990.000.000.001700.99
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Hughes, Luis,130841798.960.000.000.001798.96
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Gonzales, Jose,2201439.980.000.000.0039.98
Simmons, Haley, T,262022749.320.000.002181.56567.76
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Coleman, Vanessa,215892589.090.000.002049.10539.99
Gonzales, Paige,2170291.940.000.0039.9851.96
Stewart, Grace, H,247737.280.000.007.280.00
White, Abigail, T,15866145.820.000.0038.88106.94
King, Aaron, L,117394758.030.000.004758.030.00
Parker, Morgan, S,1677236.960.000.0014.9821.98
Isla, Julian, A,13732108.960.000.0073.9635.00
Harris, Joshua, L,2028095.940.000.0030.9764.97
Foster, Trevor, J,2896469.990.000.0069.990.00
Nelson, Henry,193941155.480.000.000.001155.48
Watson, Michelle, H,262352181.560.000.002181.560.00
Griffin, Melissa, L,287807.950.000.000.007.95
Brooks, Mariah,216202620.400.000.002071.42548.98
Green, Xavier,2356739.980.000.000.0039.98
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Ward, Ian,12056213.920.000.000.00213.92
Russell, Jessica,265721000.440.000.001000.440.00
Gray, Seth, M,2008785.480.000.000.0085.48
Carter, Elijah,216182611.070.000.002611.070.00
Bell, Alex, M,167543118.600.000.00756.332362.27
Parker, Jordan,216212616.860.000.002049.10567.76
Morgan, Evan, G,14725318.830.000.0069.97248.86
King, Jordan, C,110202316.970.000.002316.970.00
Baker, Robert, A,273007.280.000.007.280.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Anderson, Tyler, E,131481137.430.000.001137.430.00
Jackson, Edward,290422420.340.000.002420.340.00

Generated 2024-09-20 00:06:47.583 UTC