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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Moore, Fernando,265821000.440.000.001000.440.00
Gray, Sebastian, B,138782366.960.000.000.002366.96
Wu, Randy, J,116472365.940.000.002365.940.00
Brooks, Bryce,12061140.170.000.00112.2527.92
Powell, David, W,266151000.440.000.001000.440.00
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Collins, Alex, S,287812.290.000.000.002.29
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Cooper, Angela,195261179.470.000.000.001179.47
Bell, Christina,2609939.980.000.000.0039.98
Alexander, Julia, J,15291889.470.000.000.00889.47
Young, Sierra, J,11619634.840.000.0034.99599.85
Barnes, Kayla,2425639.980.000.0039.980.00
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Hernandez, José, M,11253696.610.000.0098.97597.64
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Gonzales, Luis,15856116.250.000.0037.2778.98
Diaz, Richard, A,2668264.470.000.000.0064.47
Gomez, Rebekah,13486225.440.000.000.00225.44
Bailey, Mariah, L,2724354.980.000.000.0054.98
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Smith, Katherine, J,13197105.190.000.000.00105.19
Chen, James, D,11641303.200.000.0021.49281.71
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Diaz, Faith, M,2236356.970.000.000.0056.97
Alexander, Julian,132172351.960.000.000.002351.96
Bell, Gabrielle,223735976.320.003578.270.002398.05
Powell, Katherine, C,14574177.600.000.000.00177.60
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Ramos, Derrick,18449100.940.000.0030.9769.97
Turner, Amanda, L,203183241.900.002071.420.001170.48
Ward, Cole,214907.280.000.000.007.28
Ramirez, Sydney,267007.280.000.000.007.28
Taylor, Marcus, A,18944146.940.000.000.00146.94
Moore, Taylor, A,199874564.450.003374.990.001189.46
Simmons, Haley, T,262022749.320.000.002181.56567.76
Barnes, Jeremy,2144654.980.000.000.0054.98
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Thomas, Thomas,216292624.080.000.002049.10574.98
Deng, Damien, A,16873578.460.000.000.00578.46
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Perry, Dalton, A,16149192.040.000.000.00192.04
Perez, Angel, S,213362628.350.000.002071.42556.93
Edwards, Logan,250024.990.000.000.004.99
Evans, Jordan,2920939.980.000.0039.980.00
Martin, Morgan,248322181.560.002181.560.000.00
White, Christopher, R,260492181.560.000.002181.560.00
Taylor, Tyler, A,12032614.960.000.00614.960.00
Miller, Sydney, A,134404818.530.000.000.004818.53
Ross, Kaitlyn,16121614.470.000.000.00614.47
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Russell, Caleb,23552103.480.000.000.00103.48
Reed, Megan, A,181181750.980.000.000.001750.98
Gonzales, Jordan,2368113.980.000.000.0013.98
Wang, Karen, P,1955331.970.000.000.0031.97
Umeda, Masaki,16717233.810.000.000.00233.81
Harris, Destiny, M,137102341.460.000.000.002341.46
Alexander, Ryan, J,14078839.480.000.00839.480.00
Johnson, Edward, H,23279124.990.000.000.00124.99
Butler, Victoria,132844767.530.000.000.004767.53
Long, Natalie,14363192.340.000.000.00192.34
White, Miguel, S,13988195.520.000.000.00195.52
Watson, Cole, A,217684118.263578.270.000.00539.99
Watson, Olivia, S,1386093.850.000.0014.9878.87
Nelson, James, L,245257.280.000.007.280.00
Rogers, Bryce,174022304.980.000.000.002304.98
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Sanchez, Shelby,16021539.990.000.000.00539.99
Chow, Candice,1923260.960.000.000.0060.96
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Rogers, Jade, I,14332102.250.000.000.00102.25
Evans, Alexandra,2432268.490.000.000.0068.49
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Russell, Rachel, C,2158124.270.000.0024.270.00
Alexander, Elijah,11738331.680.000.00141.73189.95
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Li, Eugene, A,15283865.950.000.000.00865.95
Walker, Hunter,271007.280.000.000.007.28
Fernandez, Cesar,200355694.980.003374.990.002319.99
Carter, Savannah, M,120902350.960.000.000.002350.96
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Russell, Melanie, B,15478182.830.000.00167.8514.98
Bryant, Rachel,220197.280.000.007.280.00
Taylor, Madison, A,11802215.290.000.00127.9687.33
Hill, Eric, G,2525667.930.000.0067.930.00
Watson, Shelby, J,14911867.970.000.000.00867.97
Smith, Austin,13707149.050.000.000.00149.05
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Miller, Kayla, A,236734.990.000.000.004.99
Griffin, Julian, M,113284718.040.000.002319.992398.05
Washington, Kayla, E,14655174.960.000.0069.97104.99
Smith, Lucas, P,1809064.910.000.000.0064.91
Price, Miranda,26629699.10699.100.000.000.00
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Phillips, Haley, B,2807939.980.000.000.0039.98
Green, Isabella,26620699.10699.100.000.000.00
Brown, Morgan,2919778.980.000.000.0078.98
Gray, Cody, C,144594775.010.000.000.004775.01
Anderson, Jasmine, A,235534.990.000.000.004.99
Thomas, Samantha,2169093.970.000.000.0093.97
Reed, Morgan, E,2877923.970.000.000.0023.97
Thomas, Matthew, K,13239185.700.000.000.00185.70
Peterson, Jared,11502829.370.000.00171.95657.42
Barnes, Fernando,113001390.550.000.00248.381142.17
Hughes, Austin, P,183681754.980.000.000.001754.98
Sandberg, Isaac,1335053.970.000.000.0053.97
Rubio, Javier, E,1972664.240.000.0064.240.00
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Turner, Jose,11784272.690.000.000.00272.69
Walker, Thomas,1307193.980.000.000.0093.98
Alexander, Logan, E,191161183.470.000.000.001183.47
Griffin, Cassidy,264961000.440.000.001000.440.00
Gill, Robyn, J,127651750.980.000.001750.980.00
Griffin, Isabelle,249864.990.000.000.004.99
Ross, Haley, T,253612443.350.002443.350.000.00
Alexander, Gavin, K,2932249.990.000.000.0049.99
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Stewart, Marcus, R,2063221.980.000.000.0021.98
Nelson, Adam, B,27402128.970.000.000.00128.97
Alexander, Lauren,189502351.960.000.000.002351.96
Johnson, Madison, L,15530846.460.000.000.00846.46
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Russell, Samantha,11211723.560.000.00118.46605.10
Murphy, Dalton, N,27043782.990.00782.990.000.00
Griffin, Jordan,13095328.890.000.0069.97258.92
Taylor, Lucas, V,115232376.960.000.002376.960.00
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Bryant, Jackson, J,2533239.980.000.000.0039.98
Chander, Wayne, S,243444329.610.003578.27751.340.00
Rodriguez, Taylor,1607166.960.000.000.0066.96
Collins, Jose,2474839.980.000.0039.980.00
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Bell, Eduardo,27101782.990.000.00782.990.00
Anderson, Isabella,137432349.980.000.000.002349.98
Flores, Julia, E,172631700.990.000.000.001700.99
Anderson, Daniel,20694146.970.000.00146.970.00
Thomas, David,168363193.790.000.000.003193.79
Clark, Lauren,170341750.980.000.000.001750.98
Cox, Lucas, J,253932443.350.002443.350.000.00
Roberts, Rebecca,2800094.480.000.000.0094.48
Cooper, Ariana,17348205.420.000.000.00205.42
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Miller, Benjamin, G,26643699.100.00699.100.000.00
Evans, Elijah, S,2588439.980.000.000.0039.98
Thompson, Lucas, O,212774.990.000.000.004.99
Hughes, Zachary,12203157.910.000.000.00157.91
Smith, Zachary, W,2378358.980.000.0058.980.00
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Sharma, Samuel,27725119.980.000.000.00119.98
Hughes, Antonio, P,15913712.270.000.000.00712.27
Evans, Kaylee,19642133.540.000.000.00133.54
Green, Eric,2738069.990.000.000.0069.99
Ward, Angela, M,2775669.990.000.000.0069.99
Thomas, Charles,250942443.350.002443.350.000.00
Martinez, Jonathan,1330366.250.000.000.0066.25
Zhang, Robert,188551155.480.000.000.001155.48
Clark, Zachary, J,2389358.980.000.000.0058.98
Walker, Brandon, J,159164793.270.000.000.004793.27
Simmons, Dakota, T,14110819.460.000.000.00819.46
Coleman, Stephanie,2226489.970.000.000.0089.97
Harris, Anthony,2144721.980.000.000.0021.98
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Hughes, Riley,2928449.990.000.000.0049.99
Griffin, Seth, R,17585164.460.000.0078.9885.48
Adams, Gabriel, S,195271219.450.000.000.001219.45
Kumar, Cameron, S,185711120.490.000.001120.490.00
Martinez, Jill,242354829.390.003578.270.001251.12
Robinson, Madison, W,183772394.970.000.000.002394.97
Campbell, Alex,119844730.320.000.002329.982400.34
Griffin, Miguel,2146476.970.000.000.0076.97
Wang, Zachary,2214489.970.000.000.0089.97
Foster, Alyssa, I,14875839.480.000.000.00839.48
Evans, James, C,206654408.560.000.002049.102359.46
Gonzales, Jose,2201439.980.000.000.0039.98
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Lee, William,13185149.840.000.0069.9779.87
Prasad, Molly,243924329.610.003578.270.00751.34
Thompson, Joshua, F,259992181.560.000.002181.560.00
Blanco, Armando, F,139182397.950.000.000.002397.95
Johnson, Jonathan,220597.280.000.000.007.28
Mitchell, Caleb, K,268064.990.000.000.004.99
Simmons, Nicole, S,2617729.480.000.000.0029.48
Adams, Hailey, M,121544798.530.000.002379.472419.06
Yuan, Leonard, F,167911729.970.000.000.001729.97
James, Timothy,213312670.890.000.002670.890.00
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Scott, Allison,14497804.480.000.000.00804.48
Hernandez, Haley, L,11769478.950.000.000.00478.95
Martin, Katherine, J,2027339.980.000.000.0039.98
Dominguez, Erika, C,21251191.270.000.000.00191.27
Green, Blake, P,11719287.200.000.000.00287.20
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Wilson, Fernando,16643126.960.000.000.00126.96
Ross, Miranda,145984839.000.000.000.004839.00
Torres, Taylor,16666205.440.000.00123.9881.46
Washington, Thomas, C,2745137.430.000.000.0037.43
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Reed, Catherine, M,203807.280.000.000.007.28
Allen, Sean, L,12097159.220.000.000.00159.22
Jackson, Edward,290422420.340.000.002420.340.00
Bradley, Nathaniel,169551760.470.000.000.001760.47
Moreno, Marie,2773969.990.000.000.0069.99
Lewis, Isabella,2624267.930.000.000.0067.93
Hughes, Destiny, P,28027119.980.000.000.00119.98
Nelson, Sean,11841307.970.000.000.00307.97
Diaz, Gabrielle,14893839.480.000.000.00839.48
Morris, Alyssa,28072548.980.000.000.00548.98
Jackson, Charles, P,112771305.660.000.00237.821067.84
Price, Riley, R,139094764.020.000.000.004764.02
Washington, Robert, J,14906143.950.000.000.00143.95
Harris, Isabella,17119214.900.000.0077.96136.94
Nath, Kenneth, W,170372334.970.000.000.002334.97
Bennett, Maria, G,229837.280.000.000.007.28
Griffin, Haley, L,1892582.180.000.000.0082.18
James, Jeremiah, S,11661287.700.000.000.00287.70
Long, Brandon, M,16110650.470.000.000.00650.47
King, Caleb, J,2898678.980.000.000.0078.98
Smith, John,198555709.960.003399.990.002309.97
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Morris, Abigail, C,287762.290.000.000.002.29
Powell, Caleb, G,216132610.580.000.002049.10561.48
Barnes, Ian, M,16106133.540.000.000.00133.54
Green, Mackenzie, C,280737.280.000.000.007.28
Simmons, Jose,2464739.980.000.000.0039.98
Fernandez, Darren,2899278.980.000.000.0078.98
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Thompson, Abigail,243324816.090.003578.270.001237.82
Bradley, Melanie, G,133434720.270.000.000.004720.27
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Campbell, Chloe,11212760.930.000.00231.72529.21
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Stewart, Sara,17347119.720.000.000.00119.72
Simmons, Adam,253274.990.000.000.004.99
Hayes, Austin,202083219.580.002049.100.001170.48
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Lee, John,19801193.010.000.000.00193.01
Shan, Logan,1867760.960.000.0029.9930.97
Collins, Luis, J,227655978.610.003578.270.002400.34
Wilson, Tyler, L,15879196.930.000.000.00196.93
Thomas, Ian,191181120.490.000.000.001120.49
Martin, Thomas, A,169521735.980.000.000.001735.98
Washington, Aaron, L,246494.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Gray, Seth, M,2008785.480.000.000.0085.48

Generated 2025-11-04 04:51:56.234 UTC