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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hayes, Carson, A,124472331.950.000.000.002331.95
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
Moreno, Lance, A,2922939.980.000.000.0039.98
Gutierrez, Neil, L,214897.280.000.000.007.28
Jai, Luis, A,18320185.920.000.000.00185.92
Flores, Hannah,1952540.230.000.000.0040.23
Lewis, Brandon, A,2903769.990.000.000.0069.99
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Bell, Timothy, J,2810178.980.000.0078.980.00
Wilson, Emily,174002331.950.000.000.002331.95
Brooks, Evan,2340139.980.000.000.0039.98
Brooks, Ian, W,2829064.470.000.000.0064.47
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Peterson, Steven, L,234497.280.000.007.280.00
Baker, Allison,2649558.980.000.000.0058.98
Young, Courtney,176222374.980.000.000.002374.98
Martinez, Joseph, E,2921459.980.000.0059.980.00
Wu, Randy, J,116472365.940.000.002365.940.00
Griffin, Miguel,2146476.970.000.000.0076.97
Taylor, Tyler, A,12032614.960.000.00614.960.00
Lee, Kayla, M,2078115.230.000.000.0015.23
Rogers, Bryce,174022304.980.000.000.002304.98
Griffin, Haley, L,1892582.180.000.000.0082.18
Collins, Amanda,2078339.980.000.000.0039.98
Perry, Samuel,18811100.960.000.00100.960.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Edwards, Hunter,2422067.930.000.000.0067.93
Flores, Morgan,19817118.940.000.0039.9878.96
Evans, Jordan,2920939.980.000.0039.980.00
Sánchez, Angela, C,176551750.980.000.000.001750.98
Coleman, Samuel, N,17450123.980.000.000.00123.98
Smith, Megan, J,2671668.970.000.000.0068.97
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Peterson, Isabella,2808039.980.000.0039.980.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Bailey, Maria, C,1915034.980.000.000.0034.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Martin, John, A,144364776.010.000.000.004776.01
Martin, Tyler, L,2772469.990.000.000.0069.99
Allen, Mason,176252431.950.000.000.002431.95
Rivera, Sara,187852350.960.000.000.002350.96
Reed, Megan, A,181181750.980.000.000.001750.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Foster, Jessica,2606951.460.000.0051.460.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Harris, Matthew,14330806.760.000.000.00806.76
Stewart, Alexandria,174761700.990.000.000.001700.99
Peterson, Mason, A,185701174.480.000.001174.480.00
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Watson, Richard,15943365.410.000.00154.98210.43
Rubio, Kellie,27653128.970.000.000.00128.97
Anderson, Jasmine, A,235534.990.000.000.004.99
Diaz, Gabrielle,14893839.480.000.000.00839.48
Alexander, Luke,290432447.050.000.002447.050.00
White, Judith, R,148851155.480.000.000.001155.48
Garcia, Chloe, M,110372374.230.000.002374.230.00
Baker, Robert, A,273007.280.000.007.280.00
Thomas, Seth,14567161.280.000.0096.0765.21
Ross, Aaron, N,118882376.960.000.002376.960.00
Brown, Morgan,2919778.980.000.000.0078.98
Lewis, Rachel, J,14900839.480.000.000.00839.48
Foster, Antonio,12795108.540.000.0066.2642.28
Li, Thomas,181162376.960.000.000.002376.96
Miller, Andrew, C,271104.990.000.000.004.99
Harris, Noah,292562393.060.000.002393.060.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Robinson, Lauren,2719668.490.000.0068.490.00
Howard, Natalie,1349154.960.000.0014.9839.98
Simmons, David, E,120172339.970.000.002339.970.00
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Peterson, Melissa, S,249954.990.000.004.990.00
Martin, Madison, C,2049271.970.000.0071.970.00
Torres, Dalton,235037.280.000.007.280.00
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Watson, Erin, B,227724.990.000.004.990.00
Turner, Kaylee, M,16213154.540.000.000.00154.54
Smith, Nathan,217647.280.000.007.280.00
Evans, Connor, J,15402131.550.000.000.00131.55
Barnes, Kayla,2425639.980.000.0039.980.00
Flores, Kevin,15878225.920.000.0069.97155.95
Collins, Jonathan,16849119.980.000.000.00119.98
Rodriguez, Richard,12969180.790.000.000.00180.79
Hall, Wyatt,2382713.980.000.000.0013.98
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Flores, Luke, L,247337.280.000.000.007.28
Coleman, Dylan,27403132.970.000.000.00132.97
Young, Jenna, W,163652490.180.000.000.002490.18
Alexander, Caroline,176541759.970.000.000.001759.97
Peterson, Julia, P,16497132.710.000.000.00132.71
Lal, Kyle,17360122.180.000.000.00122.18
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Griffin, Marcus,2075634.560.000.000.0034.56
Li, Kevin, S,2518813.980.000.000.0013.98
Wood, Gavin,16964108.540.000.0093.5614.98
Coleman, Miguel, D,2740069.990.000.0069.990.00
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Ward, Natalie, J,132412325.960.000.000.002325.96
Thompson, Kayla, D,12363273.900.000.000.00273.90
Sandberg, Chase,2190475.970.000.000.0075.97
Alexander, Jordan,2141259.980.000.0059.980.00
Simmons, Dylan,16133107.850.000.0038.8868.97
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Roberts, Amanda,171752334.980.000.000.002334.98
Lewis, Ethan,27998144.470.000.000.00144.47
Edwards, Elijah, D,281577.280.000.000.007.28
Wilson, Daniel, K,142814746.300.000.000.004746.30
Johnson, Christopher,119794813.760.000.002352.212461.55
Adams, Miguel,11659213.520.000.000.00213.52
Barnes, Jeremy,2144654.980.000.000.0054.98
Hernandez, Jamie,27283119.980.000.00119.980.00
Turner, Samuel,2742069.990.000.0069.990.00
Harris, Natalie,2368259.980.000.0059.980.00
Sanchez, Stephanie,1786756.970.000.000.0056.97
Jackson, Victoria,270194.990.000.000.004.99
Flores, Eduardo, S,2896962.980.000.000.0062.98
Moore, Jonathan,2047896.460.000.000.0096.46
Price, Mariah, C,2074549.480.000.000.0049.48
Lopez, Bailey, R,185571179.470.000.001179.470.00
Jones, Natalie, A,11845197.200.000.0082.26114.94
Luo, Jodi,2921368.490.000.000.0068.49
Hall, Grace, A,201894.990.000.000.004.99
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Prasad, Summer, M,2214339.980.000.0039.980.00
Taylor, Lucas, V,115232376.960.000.002376.960.00
Hayes, Logan, J,19026113.240.000.0037.2775.97
Wilson, Eduardo,15323804.470.000.000.00804.47
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Morris, Jessica,289678.990.000.008.990.00
Perez, Savannah, J,17036176.950.000.0056.97119.98
Alexander, Julian,132172351.960.000.000.002351.96
Cooper, Brian, L,13760128.840.000.000.00128.84
Alvarez, Melody,2507068.490.000.000.0068.49
Scott, Mason,2355139.980.000.000.0039.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Ross, Kaitlyn,16121614.470.000.000.00614.47
Blue, Melanie, L,178611749.960.000.000.001749.96
Lee, James, J,2881769.990.000.0069.990.00
Walker, Ian,16771104.550.000.0054.5849.97
Srini, Ruben,18078200.940.000.0071.97128.97
Long, Gavin,13762186.030.000.0036.59149.44
Gray, Cindy, A,13198114.950.000.0099.9714.98
Collins, Jose,2474839.980.000.0039.980.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Nelson, Jose,19217185.020.000.0091.9593.07
Diaz, Brandon,236764.990.000.004.990.00
Jenkins, Austin, D,15748296.910.000.000.00296.91
Powell, Katherine, C,14574177.600.000.000.00177.60
Hayes, Dalton, C,188822322.280.000.000.002322.28
Reed, Melanie, A,28160574.980.000.000.00574.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Perry, Benjamin,291652407.040.000.002407.040.00
Bryant, Rachel,220197.280.000.007.280.00
Li, Jordan,17026261.390.000.00261.390.00
Young, Kaylee, S,13756298.490.000.0058.47240.02
Ramirez, Richard, C,282397.280.000.007.280.00
Reed, Morgan, E,2877923.970.000.000.0023.97
Bryant, Dakota, L,176132401.950.000.000.002401.95
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Barnes, Blake, A,178651789.970.000.000.001789.97
Baker, Mason, A,132702394.950.000.000.002394.95
Richardson, Devin, G,2131836.960.000.000.0036.96
Rivera, Hailey, R,2079239.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Moore, Ian, L,2463939.980.000.000.0039.98
Collins, Allison,28581119.980.000.000.00119.98
Price, Caroline,180511735.980.000.000.001735.98
Foster, Abigail,1982346.470.000.000.0046.47
Smith, Zachary, W,2378358.980.000.0058.980.00
Perez, Charles,266937.280.000.007.280.00
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Adams, Mason, T,2052864.470.000.0064.470.00
Washington, Victoria,235577.280.000.000.007.28
Barnes, Emily, G,15996564.990.000.000.00564.99
Roberts, Wyatt,15900699.970.000.00699.970.00
Malhotra, Brenda,133912405.470.000.000.002405.47
Jones, Kayla, C,1854194.260.000.000.0094.26
Nelson, James, L,245257.280.000.007.280.00
Hernandez, Sierra,27393123.980.000.00123.980.00
Sanchez, Rachel, C,267304.990.000.000.004.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Hall, Jason, A,29351119.980.000.000.00119.98
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
Lee, Samantha, B,2737878.980.000.000.0078.98
James, Richard, D,15760109.230.000.003.99105.24
Parker, Jeremy,2866878.980.000.0078.980.00
Lewis, Christopher,1875586.960.000.0086.960.00
Srini, Evelyn,16855150.950.000.000.00150.95
James, Julia,2497567.930.000.000.0067.93
Henderson, Justin, P,235917.280.000.000.007.28
Simmons, Caleb, M,121934833.030.000.000.004833.03
Mitchell, Evan, R,247314.990.000.000.004.99
Perry, Jackson, J,213064.990.000.000.004.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Miller, Kayla, A,236734.990.000.000.004.99
Garcia, Kayla, L,2130881.460.000.000.0081.46
She, Shawn, J,16902141.980.000.000.00141.98
Yuan, Leonard, F,167911729.970.000.000.001729.97
Bradley, Jocelyn,230227.280.000.000.007.28
Peterson, Morgan, J,168341750.980.000.000.001750.98
Davis, Austin, E,133664749.040.000.000.004749.04
Reed, Michelle,2804669.990.000.000.0069.99
Zhang, Connor, R,138532329.980.000.000.002329.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Perry, James,192051249.840.000.000.001249.84
Phillips, Luis, G,207347.280.000.000.007.28
Thompson, Brianna, X,1864269.970.000.000.0069.97
Ruiz, Philip,1807781.460.000.000.0081.46
Johnson, Madison, L,15530846.460.000.000.00846.46
Howard, Danielle,28357133.490.000.000.00133.49
Ashe, Alexis, S,194141145.480.000.000.001145.48
Green, Kaylee, C,2618567.970.000.000.0067.97
Phillips, Aaron, R,2494739.980.000.000.0039.98
Cooper, Angela,195261179.470.000.000.001179.47
Bailey, Olivia,238924.990.000.000.004.99
Thomas, Ian,191181120.490.000.000.001120.49
Li, Brandon,2933973.960.000.000.0073.96
Ramirez, Emma,29072128.970.000.000.00128.97
Roberts, Carlos,2319639.980.000.000.0039.98
Russell, Gail, L,212634.990.000.000.004.99
Flores, Gabriel,271117.280.000.000.007.28
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Hughes, Luis,130841798.960.000.000.001798.96
Evans, Elijah, S,2588439.980.000.000.0039.98
Coleman, Stephanie,2226489.970.000.000.0089.97
Williams, Joshua,260514.990.000.000.004.99
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Nelson, Henry,193941155.480.000.000.001155.48
Bennett, Brittany, J,2233239.980.000.000.0039.98
Stewart, Melissa,2517336.960.000.000.0036.96
Cooper, Brooke,195361120.490.000.000.001120.49
Edwards, Amber, B,2051776.970.000.000.0076.97
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Kelly, Erin, D,2351364.470.000.000.0064.47
Foster, Caleb,27112114.460.000.000.00114.46
Diaz, Faith, M,2236356.970.000.000.0056.97
Luo, Donna, E,248054.990.000.000.004.99
Sanchez, Shelby,16021539.990.000.000.00539.99
Roberts, Hunter,282607.280.000.000.007.28
Bradley, Nathaniel,169551760.470.000.000.001760.47
Adams, Carlos,1982236.960.000.000.0036.96
Sanders, Lucas, W,268024.990.000.000.004.99
Edwards, Logan,250024.990.000.000.004.99
Miller, Destiny,251577.280.000.000.007.28
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Nath, Alison, J,171161764.960.000.000.001764.96
Russell, Richard,2763322.260.000.000.0022.26
_SUM1806517.5068775.49483427.72324653.52929660.77

Generated 2025-11-03 14:08:53.804 UTC