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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Perry, Natalie,1712669.990.000.000.0069.99
Kumar, Elijah,15197156.920.000.000.00156.92
Mitchell, Caleb, K,268064.990.000.000.004.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Diaz, Richard, A,2668264.470.000.000.0064.47
Adams, Carlos,1982236.960.000.000.0036.96
White, Tyler,14291258.440.000.0049.97208.47
Baker, Robert, A,273007.280.000.007.280.00
Thomas, Megan,2907169.990.000.000.0069.99
Ross, Aaron, N,118882376.960.000.002376.960.00
Bell, Christina,2609939.980.000.000.0039.98
Anderson, Tyler, E,131481137.430.000.001137.430.00
Watson, Michelle, H,262352181.560.000.002181.560.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Malhotra, Brenda,133912405.470.000.000.002405.47
Russell, Jessica,265721000.440.000.001000.440.00
Robinson, Lauren,2719668.490.000.0068.490.00
Winston, Ethan, R,216222612.060.000.002049.10562.96
Davis, Jonathan,2925913.980.000.000.0013.98
Carter, Elijah,216182611.070.000.002611.070.00
Parker, Jeremy,2866878.980.000.0078.980.00
King, Jordan, C,110202316.970.000.002316.970.00
Smith, Eduardo,2069139.980.000.0039.980.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Lewis, Christopher,1875586.960.000.0086.960.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Miller, Jill,129142329.980.000.000.002329.98
Jackson, Edward,290422420.340.000.002420.340.00
Rogers, Paige, H,17125539.990.000.000.00539.99
Morris, Mason, J,22349124.990.000.000.00124.99
Torres, Christina, M,20746119.950.000.0064.9754.98
Alexander, Edward, E,18524195.950.000.000.00195.95
Turner, Mary,220154.990.000.000.004.99
Moore, Anthony, M,2473039.980.000.000.0039.98
Ross, Seth, M,184332329.980.000.000.002329.98
Lal, Caleb, R,1586874.460.000.000.0074.46
Lewis, Rachel, J,14900839.480.000.000.00839.48
Peterson, Xavier, R,2645639.980.000.000.0039.98
Sanchez, Grace,120802354.990.000.002354.990.00
Wilson, Eduardo,15323804.470.000.000.00804.47
Johnson, Ian, E,2173283.470.000.000.0083.47
Price, Lauren, J,14079184.740.000.0037.29147.45
Wang, Zachary,2214489.970.000.000.0089.97
Zhang, Robert,188551155.480.000.000.001155.48
Torres, Abigail,253674.990.000.000.004.99
Flores, Madison,14416769.490.000.000.00769.49
Morgan, Isabella, L,28602144.470.000.000.00144.47
Washington, Alexis,1978146.260.000.007.2838.98
James, Julia,2497567.930.000.000.0067.93
Jones, Samantha,1831721.980.000.000.0021.98
Blue, Melanie, L,178611749.960.000.000.001749.96
Gonzales, Emily, P,21777180.980.000.000.00180.98
Garcia, Chloe, M,110372374.230.000.002374.230.00
Moore, Jessica, J,2008576.760.000.000.0076.76
Gray, Isabella,168203217.790.000.000.003217.79
Harris, Samantha, A,244874.990.000.000.004.99
Hill, Timothy,14871848.470.000.000.00848.47
Shan, Chad, M,2462112.940.000.000.0012.94
Yuan, Leonard, F,167911729.970.000.000.001729.97
Coleman, Spencer,15993597.260.000.000.00597.26
Howard, Natalie,1349154.960.000.0014.9839.98
Prasad, Donald,15413318.920.000.00123.98194.94
Nelson, Jordan, H,201304.990.000.004.990.00
Henderson, Abigail,2044139.980.000.000.0039.98
Carter, Jesse, E,22141166.280.000.000.00166.28
Adams, Julia, N,2607359.980.000.000.0059.98
James, Bryce,13466133.450.000.000.00133.45
Jones, Dalton, T,189512334.970.000.000.002334.97
Bradley, Jocelyn,230227.280.000.000.007.28
Green, Eric,2738069.990.000.000.0069.99
Sanchez, Jared, J,2585064.470.000.000.0064.47
Nelson, Jennifer,171471700.990.000.000.001700.99
Peterson, Morgan, J,168341750.980.000.000.001750.98
Collins, Alex, S,287812.290.000.000.002.29
Prasad, Erick, E,28786127.950.000.000.00127.95
Bryant, Brittany,2254548.970.000.000.0048.97
Williams, Austin,2035432.220.000.000.0032.22
Henderson, Logan, C,2236656.970.000.000.0056.97
Butler, Trevor,2741569.990.000.0069.990.00
Hughes, Brittany,14387898.460.000.00898.460.00
Wright, Jennifer,2650559.980.000.0059.980.00
Hayes, Brittany,13941286.820.000.0038.88247.94
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Martin, Nicholas,233627.280.000.000.007.28
Barnes, Blake, A,178651789.970.000.000.001789.97
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Phillips, Haley, B,2807939.980.000.000.0039.98
Williams, Zachary, B,27099782.990.000.00782.990.00
Howard, Erin, L,183621725.210.000.000.001725.21
Jai, Connor, D,27253782.990.000.00782.990.00
Rubio, Ruben, D,1887186.960.000.0086.960.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Harris, Jacob, G,2367939.980.000.0039.980.00
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Carter, Bailey,213322616.860.000.002616.860.00
Howard, Brianna, D,246304.990.000.000.004.99
Patterson, Alexis,213484392.020.000.002049.102342.92
Martin, Thomas, A,169521735.980.000.000.001735.98
Ruiz, Philip,1807781.460.000.000.0081.46
Foster, Abigail,1982346.470.000.000.0046.47
Perez, Savannah, J,17036176.950.000.0056.97119.98
Bell, Timothy, J,2810178.980.000.0078.980.00
Watson, Victoria,16125588.960.000.000.00588.96
Harris, Natalie,2368259.980.000.0059.980.00
Phillips, Isaiah,28631144.470.000.00144.470.00
Perez, Timothy, L,227304.990.000.000.004.99
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Robinson, Emily,12183228.420.000.0054.96173.46
Green, Kaylee, C,2618567.970.000.000.0067.97
Xu, Louis,2010466.530.000.0066.530.00
Peterson, Steven, L,234497.280.000.007.280.00
Rodriguez, Destiny, J,227397.280.000.007.280.00
Nath, Carl, H,29001624.970.000.000.00624.97
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Perry, Jackson, J,213064.990.000.000.004.99
Hall, Wyatt,2382713.980.000.000.0013.98
Martin, Kellie, R,28195574.980.000.000.00574.98
Thomas, Dalton,230097.280.000.000.007.28
Nath, Kenneth, W,170372334.970.000.000.002334.97
Chen, Ethan,2054756.970.000.000.0056.97
Sandberg, Chase,2190475.970.000.000.0075.97
Patterson, Abigail, H,144784795.010.000.000.004795.01
Thomas, Zachary, D,28045119.980.000.000.00119.98
Simmons, Nicole, S,2617729.480.000.000.0029.48
Washington, Aaron, L,246494.990.000.000.004.99
Thames, Bernard,2380368.490.000.000.0068.49
McDonald, Aaron, J,27734119.980.000.000.00119.98
Wu, Randy, J,116472365.940.000.002365.940.00
Rubio, Javier, E,1972664.240.000.0064.240.00
Foster, Aaron,155664912.470.000.000.004912.47
Taylor, Lucas, V,115232376.960.000.002376.960.00
Garcia, Kayla, L,2130881.460.000.000.0081.46
Gray, Sara,292472447.050.000.002447.050.00
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Anderson, David, A,2209761.960.000.0061.960.00
Lewis, Ethan,27998144.470.000.000.00144.47
Chen, Jack, E,17579151.430.000.000.00151.43
Morris, Jessica,289678.990.000.008.990.00
Gutierrez, Neil, L,214897.280.000.000.007.28
Patterson, Eric, A,2738478.980.000.000.0078.98
Roberts, Amanda,171752334.980.000.000.002334.98
Russell, Gail, L,212634.990.000.000.004.99
White, James,253317.280.000.000.007.28
Flores, Gabriel,271117.280.000.000.007.28
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Stewart, Amanda, M,1531094.440.000.000.0094.44
Brooks, Evan,2340139.980.000.000.0039.98
Robinson, Joseph,2814194.480.000.0094.480.00
Johnson, Cameron, R,137201155.480.000.000.001155.48
Perry, Samuel,18811100.960.000.00100.960.00
Butler, Jonathan,261804.990.000.000.004.99
Johnson, Xavier, R,2325539.980.000.0039.980.00
Luo, Jodi,2921368.490.000.000.0068.49
Foster, Emma,15468436.350.000.00159.99276.36
Hall, Grace, A,201894.990.000.000.004.99
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Anderson, Ryan, W,132712319.990.000.000.002319.99
Roberts, Noah, S,2704268.490.000.000.0068.49
Young, Courtney,176222374.980.000.000.002374.98
Brown, Dylan, J,124492351.960.000.000.002351.96
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Walker, Richard, T,19640224.550.000.000.00224.55
Cooper, Brian, L,13760128.840.000.000.00128.84
Taylor, Edward, C,17442319.880.000.00230.9088.98
Brown, Christian,227554.990.000.000.004.99
Sanders, Zoe, L,248254.990.000.000.004.99
Patterson, Austin, O,270247.280.000.000.007.28
Hall, Taylor, J,169951735.980.000.000.001735.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Jones, Michael, A,2210771.970.000.000.0071.97
Ward, Eduardo, I,139162354.980.000.000.002354.98
Wang, Benjamin, R,274547.280.000.000.007.28
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Wang, Karen, P,1955331.970.000.000.0031.97
Anderson, Daniel,20694146.970.000.00146.970.00
Perry, James,192051249.840.000.000.001249.84
Harris, Samuel, M,2477159.980.000.0059.980.00
Gray, Sebastian, B,138782366.960.000.000.002366.96
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Wang, Austin, A,1463284.970.000.009.9974.98
Rogers, Bryce,174022304.980.000.000.002304.98
Adams, Kyle, E,1881269.990.000.0069.990.00
Clark, Zachary, J,2389358.980.000.000.0058.98
Ramirez, Richard, C,282397.280.000.007.280.00
Blanco, Armando, F,139182397.950.000.000.002397.95
Foster, Alyssa, I,14875839.480.000.000.00839.48
Johnson, Madison, L,15530846.460.000.000.00846.46
Alexander, Julian,132172351.960.000.000.002351.96
Davis, Dylan,15556588.960.000.00588.960.00
Scott, Mason,2355139.980.000.000.0039.98
Cooper, Brooke,195361120.490.000.000.001120.49
Lee, Kayla, M,2078115.230.000.000.0015.23
Henderson, Olivia,188591155.480.000.000.001155.48
Parker, Kaylee, M,2773878.980.000.000.0078.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Walker, Destiny, M,169961754.980.000.000.001754.98
Bennett, Brittany, J,2233239.980.000.000.0039.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Foster, Nicole, A,2349489.970.000.000.0089.97
Adams, Mason, T,2052864.470.000.0064.470.00
Edwards, Amber, B,2051776.970.000.000.0076.97
Parker, Eduardo, M,12939169.420.000.00110.2059.22
Richardson, Erin, R,1633188.850.000.0088.850.00
Alexander, Gavin, K,2932249.990.000.000.0049.99
Taylor, Marcus, A,18944146.940.000.000.00146.94
Long, Rachel,2828339.980.000.000.0039.98
Bailey, Maria, C,1915034.980.000.000.0034.98
Simmons, Adam,253274.990.000.000.004.99
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
Martin, Christian, V,19709197.250.000.000.00197.25
Collins, Eduardo,139872329.990.000.000.002329.99
Sanchez, Shelby,16021539.990.000.000.00539.99
Baker, Mason, A,132702394.950.000.000.002394.95
Rivera, Hailey, R,2079239.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Wright, Katelyn, A,14502122.260.000.0084.9737.29
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Chen, David,2720839.980.000.000.0039.98
Carter, Jonathan,14578848.470.000.000.00848.47
Collins, Charles, B,29041628.450.000.000.00628.45
Bradley, Nathaniel,169551760.470.000.000.001760.47
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Torres, Dalton,235037.280.000.007.280.00
Price, Rachel, D,2532889.970.000.000.0089.97
Diaz, Gabrielle,14893839.480.000.000.00839.48
White, Judith, R,148851155.480.000.000.001155.48
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Miller, Destiny,251577.280.000.000.007.28
Cook, Joan,235544.990.000.000.004.99
Van, Bobby,27757132.970.000.00132.970.00
Barnes, Kayla,2425639.980.000.0039.980.00
Powell, Sydney, M,14886539.990.000.00539.990.00
Murphy, Brianna, K,2834269.990.000.000.0069.99
Ross, David, M,171431763.970.000.000.001763.97
Robinson, Madison, W,183772394.970.000.000.002394.97
Perez, Katherine, J,2207924.270.000.000.0024.27
Gray, Marcus, T,183892401.450.000.000.002401.45
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Hall, Jason, A,29351119.980.000.000.00119.98
Coleman, Ian,2127639.980.000.000.0039.98
Jackson, Andrew,2047985.480.000.000.0085.48
Rogers, Olivia,12020804.470.000.000.00804.47
Li, Thomas,181162376.960.000.000.002376.96

Generated 2024-09-20 02:58:23.552 UTC