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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Shan, Christian, L,2308439.980.000.000.0039.98
Simmons, Anna, K,124512367.920.000.000.002367.92
Li, Brandon,2933973.960.000.000.0073.96
Collins, Eduardo,139872329.990.000.000.002329.99
Simmons, Adam,253274.990.000.000.004.99
Ross, Kelly,2607676.960.000.000.0076.96
Patterson, Aaron, W,191131184.460.000.000.001184.46
Williams, Joshua,260514.990.000.000.004.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Stewart, Garrett, O,15762564.480.000.000.00564.48
Foster, Caleb,27112114.460.000.000.00114.46
Luo, Donna, E,248054.990.000.000.004.99
Roberts, Hunter,282607.280.000.000.007.28
Perry, Lauren,248164.990.000.000.004.99
Bradley, Nathaniel,169551760.470.000.000.001760.47
Price, Rachel, D,2532889.970.000.000.0089.97
Long, Elizabeth, F,127822400.950.000.000.002400.95
Cook, Joan,235544.990.000.000.004.99
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Kelly, Erin, D,2351364.470.000.000.0064.47
Torres, Abigail,253674.990.000.000.004.99
Richardson, Lauren, C,14867839.480.000.000.00839.48
Wang, Zachary,2214489.970.000.000.0089.97
Cook, Seth,2301064.470.000.000.0064.47
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Flores, Brittany,169062359.980.000.000.002359.98
Nelson, Sierra,161322459.620.000.002459.620.00
Diaz, Hailey, W,116932294.990.000.002294.990.00
Cox, Devin, C,134184768.050.000.000.004768.05
Brooks, Bryce,12061140.170.000.00112.2527.92
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Washington, Alexis,1978146.260.000.007.2838.98
Phillips, Devin,18759112.060.000.000.00112.06
Diaz, Alyssa,139084715.330.000.000.004715.33
Foster, Antonio,12795108.540.000.0066.2642.28
Diaz, Katherine, P,115262376.960.000.002376.960.00
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Alexander, Jordan,2141259.980.000.0059.980.00
Ross, Jose,2744178.980.000.0078.980.00
Harris, Jacob, G,2367939.980.000.0039.980.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Martin, Samuel,15874225.440.000.0069.99155.45
Wright, Carol, C,12928247.410.000.0033.98213.43
Torres, Mackenzie,28153570.470.000.000.00570.47
Alexander, Thomas,207607.280.000.000.007.28
Wilson, Grace,17539205.920.000.000.00205.92
Moore, Chloe, L,2626913.980.000.000.0013.98
Harris, Samantha, A,244874.990.000.000.004.99
Washington, Hailey, S,2588559.980.000.000.0059.98
Chen, Luis, G,2125294.450.000.0094.450.00
Henderson, Abigail,2044139.980.000.000.0039.98
Lobao, Alexandre,1892691.950.000.0091.950.00
Xu, Louis,2010466.530.000.0066.530.00
Peterson, Steven, L,234497.280.000.007.280.00
Blue, Makayla,1900029.990.000.000.0029.99
Nelson, Luis,234884.990.000.000.004.99
Lewis, Isabella,2624267.930.000.000.0067.93
Smith, Lucas, P,1809064.910.000.000.0064.91
Foster, Trevor, J,2896469.990.000.000.0069.99
Wu, Randy, J,116472365.940.000.002365.940.00
Murphy, Maria,160113657.260.000.000.003657.26
Kennedy, Bridget,2202639.980.000.000.0039.98
Flores, Kevin,15878225.920.000.0069.97155.95
Martin, Noah, A,1765775.970.000.0075.970.00
Martinez, Grace, M,17385208.690.000.0069.97138.72
Taylor, Tyler, A,12032614.960.000.00614.960.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Russell, Arianna,22728149.930.000.00149.930.00
Rodriguez, Taylor,1607166.960.000.000.0066.96
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Perry, Benjamin,291652407.040.000.002407.040.00
Hill, Eric, G,2525667.930.000.0067.930.00
Bryant, Rachel,220197.280.000.007.280.00
Jai, Samuel, L,1635887.950.000.0039.9947.96
Green, Gabriella, C,2803569.990.000.000.0069.99
Cooper, Brianna,2592513.980.000.000.0013.98
Smith, Alexandra,2829261.960.000.000.0061.96
Cox, Katelyn, B,2174230.970.000.000.0030.97
Johnson, Anthony, D,270224.990.000.000.004.99
Stewart, Olivia, B,1874923.780.000.000.0023.78
Chen, Jonathan, G,13096200.690.000.000.00200.69
Lee, Don,188392384.970.000.000.002384.97
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Davis, Dylan,15556588.960.000.00588.960.00
Hayes, Logan, J,19026113.240.000.0037.2775.97
Hughes, Caroline, C,2830278.980.000.0078.980.00
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Rogers, Jade, I,14332102.250.000.000.00102.25
Hall, Jose, J,17601225.420.000.00155.4569.97
Ramirez, Brian, M,116182369.960.000.002369.960.00
Ward, Kaylee, A,244154.990.000.004.990.00
Nelson, Kevin,1476584.970.000.000.0084.97
Ramirez, Ian,166783162.310.000.00742.352419.96
Roberts, Robert, R,1898656.970.000.0056.970.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Rodriguez, Destiny, J,227397.280.000.007.280.00
Henderson, Luke,19200109.240.000.000.00109.24
Patterson, Natalie,16123629.970.000.000.00629.97
Zhang, Nathan, L,2910478.980.000.000.0078.98
Yang, Aaron, C,2519654.980.000.000.0054.98
Reed, Catherine, M,203807.280.000.000.007.28
Gomez, Rebekah,13486225.440.000.000.00225.44
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Anderson, David, A,2209761.960.000.0061.960.00
Allen, Allison, A,1975737.270.000.000.0037.27
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Lee, James, J,2881769.990.000.0069.990.00
Scott, Eric,282484.990.000.004.990.00
Collins, Jose,2474839.980.000.0039.980.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Hughes, Destiny, P,28027119.980.000.000.00119.98
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Flores, Nathan, C,2463713.980.000.000.0013.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Wang, Austin, A,1463284.970.000.009.9974.98
Adams, Kyle, E,1881269.990.000.0069.990.00
Anderson, Daniel,20694146.970.000.00146.970.00
Richardson, Charles, I,121144719.020.000.002325.962393.06
Adams, Mason, T,2052864.470.000.0064.470.00
Peterson, Mason, A,185701174.480.000.001174.480.00
Li, Kevin, S,2518813.980.000.000.0013.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Long, Chloe,167841735.980.000.000.001735.98
Campbell, Gabriella,188411145.480.000.000.001145.48
Perez, Timothy, L,227304.990.000.000.004.99
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Jai, Hunter, M,28272111.950.000.000.00111.95
Clark, Joseph, D,153954780.020.000.000.004780.02
Nath, Kenneth, W,170372334.970.000.000.002334.97
Sandberg, Chase,2190475.970.000.000.0075.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Roberts, Rebecca,2800094.480.000.000.0094.48
Baker, Robert, A,273007.280.000.007.280.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Anderson, Tyler, E,131481137.430.000.001137.430.00
Gonzales, Jordan,2368113.980.000.000.0013.98
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Reed, Megan, A,181181750.980.000.000.001750.98
Roberts, Jordan, M,1680039.250.000.000.0039.25
Sanchez, Jared, J,2585064.470.000.000.0064.47
Peterson, Morgan, J,168341750.980.000.000.001750.98
Prasad, Erick, E,28786127.950.000.000.00127.95
Foster, Abigail,1982346.470.000.000.0046.47
Howard, Brianna, D,246304.990.000.000.004.99
Collins, Jonathan,16849119.980.000.000.00119.98
Hall, Wyatt,2382713.980.000.000.0013.98
Mitchell, Evan, R,247314.990.000.000.004.99
Flores, Luke, L,247337.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Bell, Chase,180911750.980.000.000.001750.98
Jones, Alexandra, B,2020245.950.000.000.0045.95
Garcia, Kayla, L,2130881.460.000.000.0081.46
McDonald, Aaron, J,27734119.980.000.000.00119.98
Thames, Bernard,2380368.490.000.000.0068.49
Shan, Gabriel, T,2773169.990.000.000.0069.99
Russell, Gail, L,212634.990.000.000.004.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Patterson, Austin, O,270247.280.000.000.007.28
Zhang, Connor, R,138532329.980.000.000.002329.98
Flores, Julian,158464943.320.000.000.004943.32
Walker, Jacob, N,29027574.980.000.000.00574.98
Hughes, Luis,130841798.960.000.000.001798.96
Coleman, Stephanie,2226489.970.000.000.0089.97
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Hall, Taylor, J,169951735.980.000.000.001735.98
Jones, Michael, A,2210771.970.000.000.0071.97
Wang, Benjamin, R,274547.280.000.000.007.28
Kelly, Bailey, R,28284563.770.000.000.00563.77
Walker, Destiny, M,169961754.980.000.000.001754.98
Clark, Zachary, J,2389358.980.000.000.0058.98
Cooper, Brooke,195361120.490.000.000.001120.49
Foster, Jose, C,2878534.990.000.000.0034.99
Washington, Adam, G,2543713.980.000.000.0013.98
Carter, Jonathan,14578848.470.000.000.00848.47
Sanders, Lucas, W,268024.990.000.000.004.99
Miller, Destiny,251577.280.000.000.007.28
Murphy, Brianna, K,2834269.990.000.000.0069.99
Miller, Jill,129142329.980.000.000.002329.98
Ross, David, M,171431763.970.000.000.001763.97
Anderson, Madison, G,2835978.980.000.000.0078.98
Turner, Mary,220154.990.000.000.004.99
Nelson, Katherine,2802178.980.000.000.0078.98
Campbell, Natalie, L,115122319.990.000.000.002319.99
Nath, Alison, J,171161764.960.000.000.001764.96
Williams, Destiny, S,15881564.990.000.00564.990.00
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Martinez, Jonathan,1330366.250.000.000.0066.25
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Nelson, James, L,245257.280.000.007.280.00
Hernandez, Sierra,27393123.980.000.00123.980.00
Stewart, Allison, R,18826166.430.000.0069.9996.44
Robinson, Zachary, L,137092332.280.000.000.002332.28
Richardson, Brian,2860878.980.000.000.0078.98
Brown, Julia,18065155.470.000.000.00155.47
Ward, Natalie, J,132412325.960.000.000.002325.96
Gray, Mariah,222787.280.000.007.280.00
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Robinson, William,20103103.480.000.000.00103.48
Lewis, Ryan, A,203124.990.000.000.004.99
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Flores, Hannah,1952540.230.000.000.0040.23
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Simmons, David, E,120172339.970.000.002339.970.00
Campbell, Lucas,2932953.990.000.000.0053.99
Alexander, Caroline,176541759.970.000.000.001759.97
Long, Sarah,173721729.970.000.000.001729.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Barnes, Jeremy,2144654.980.000.000.0054.98
Watson, Erin, B,227724.990.000.004.990.00
Smith, Nathan,217647.280.000.007.280.00
Van, Bobby,27757132.970.000.00132.970.00
Hall, Grace, A,201894.990.000.000.004.99
Henderson, Justin, P,235917.280.000.000.007.28
Clark, Destiny, L,28600119.980.000.000.00119.98
Scott, Mason,2355139.980.000.000.0039.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Barnes, Dalton, C,178581700.990.000.000.001700.99
Wilson, Eduardo,15323804.470.000.000.00804.47
Griffin, Miguel,2146476.970.000.000.0076.97
Moore, Jonathan,2047896.460.000.000.0096.46
Price, Mariah, C,2074549.480.000.000.0049.48
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Baker, Gabriella,174041709.980.000.000.001709.98
Stewart, Marcus, R,2063221.980.000.000.0021.98
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Peterson, Christina,2897694.480.000.000.0094.48
Washington, Victoria,235577.280.000.000.007.28
Flores, Brandon, L,2562189.970.000.000.0089.97
Russell, Nicole, M,182372318.960.000.000.002318.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Wood, Brittany,2877753.990.000.000.0053.99
Stewart, Alexandria,174761700.990.000.000.001700.99
Hayes, Jason,261764.990.000.000.004.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Robinson, Madison, W,183772394.970.000.000.002394.97
Perez, Barry, M,2728269.990.000.000.0069.99
Yuan, Brendan, S,247444.990.000.000.004.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Coleman, Ian,2127639.980.000.000.0039.98
Henderson, Austin,2764354.980.000.000.0054.98
Ross, Seth, M,184332329.980.000.000.002329.98
Coleman, Samuel, N,17450123.980.000.000.00123.98
Russell, Caleb,23552103.480.000.000.00103.48
Jones, Dalton, T,189512334.970.000.000.002334.97
Davis, Justin,2807412.940.000.000.0012.94
James, Julia,2497567.930.000.000.0067.93
She, Shawn, J,16902141.980.000.000.00141.98
Yuan, Leonard, F,167911729.970.000.000.001729.97
_SUM1806517.5065197.22487005.99323518.76930795.53

Generated 2025-11-04 04:23:33.662 UTC