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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Jones, Natalie, A,11845197.200.000.0082.26114.94
Alexander, Julian,132172351.960.000.000.002351.96
Thompson, Tyler,2750269.990.000.0069.990.00
Rivera, Rachel, S,2899678.980.000.000.0078.98
Griffin, Jason, L,112001267.110.000.00391.08876.03
Gonzales, Jordan,2368113.980.000.000.0013.98
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Phillips, Isaiah,28631144.470.000.00144.470.00
Jones, Michael, A,2210771.970.000.000.0071.97
Martin, Samuel,15874225.440.000.0069.99155.45
Flores, Arianna,217274132.243578.270.000.00553.97
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Parker, Morgan, S,1677236.960.000.0014.9821.98
Gomez, Briana, A,2878443.980.000.000.0043.98
Barnes, Ian, M,16106133.540.000.000.00133.54
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Baker, Eduardo,180921789.450.000.000.001789.45
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Martinez, Kristina, S,2134529.930.000.000.0029.93
James, Christina,17409219.920.000.000.00219.92
Carter, Luis, E,258832443.350.002443.350.000.00
Griffin, Cassidy,264961000.440.000.001000.440.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Stewart, Olivia, B,1874923.780.000.000.0023.78
Garcia, Xavier, M,2030071.970.000.000.0071.97
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Jones, Alexander, I,2002180.960.000.000.0080.96
King, Aaron, L,117394758.030.000.002359.982398.05
Sanders, Isaiah,2587339.980.000.000.0039.98
Flores, Zachary, H,233765314.250.003578.270.001735.98
Jenkins, Megan, R,12074261.380.000.000.00261.38
James, Bryce,13466133.450.000.000.00133.45
Smith, Megan, J,2671668.970.000.000.0068.97
Moreno, Lance, A,2922939.980.000.000.0039.98
Brooks, Bryce,12061140.170.000.00112.2527.92
Washington, Adam, G,2543713.980.000.000.0013.98
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Hill, Timothy,14871848.470.000.000.00848.47
Anderson, David, A,2209761.960.000.0061.960.00
Bell, Christina,2609939.980.000.000.0039.98
Ross, Xavier, A,12202171.470.000.0049.97121.50
Stewart, Marcus, R,2063221.980.000.000.0021.98
Henderson, Austin,2764354.980.000.000.0054.98
Perry, Samuel,18811100.960.000.00100.960.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Young, Sierra, J,11619634.840.000.0034.99599.85
Richardson, Evan, J,15488165.300.000.000.00165.30
Russell, Fernando,27084782.990.000.00782.990.00
Lopez, Carlos,186171147.770.000.000.001147.77
Simmons, Haley, T,262022749.320.000.002181.56567.76
Anderson, Daniel,20694146.970.000.00146.970.00
Jackson, Andrew,2047985.480.000.000.0085.48
Dominguez, Erika, C,21251191.270.000.000.00191.27
Chander, Wayne, S,243444329.610.003578.27751.340.00
Jones, Kayla, C,1854194.260.000.000.0094.26
Luo, Franklin, J,2202759.980.000.000.0059.98
Collins, Sierra,185491169.460.000.001169.460.00
Lal, Caleb, R,1586874.460.000.000.0074.46
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Patterson, Natalie,16123629.970.000.000.00629.97
Young, Julia, J,274144.990.000.000.004.99
Sanders, Alexandra,259112181.560.000.002181.560.00
Shan, Chad, M,2462112.940.000.000.0012.94
Robinson, Lauren,2719668.490.000.0068.490.00
Bryant, Samantha,18345115.470.000.000.00115.47
Chen, Jack, E,17579151.430.000.000.00151.43
Stewart, Alex, M,2008463.150.000.000.0063.15
Morris, Jessica,289678.990.000.008.990.00
Scott, Eric,282484.990.000.004.990.00
Diaz, Luis, D,11203801.770.000.00183.97617.80
Morris, Mason, J,22349124.990.000.000.00124.99
Miller, Joseph, A,227134148.190.003578.270.00569.92
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Robinson, Sarah, A,2702859.980.000.000.0059.98
Martin, Lucas, L,221144183.233578.270.000.00604.96
Stewart, Makayla,16649115.940.000.000.00115.94
Hall, Jose, J,17601225.420.000.00155.4569.97
Foster, Antonio,12795108.540.000.0066.2642.28
Campbell, Adam, A,214002688.890.000.002071.42617.47
Butler, Trevor,2741569.990.000.0069.990.00
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Taylor, Tyler, A,12032614.960.000.00614.960.00
Diaz, Alyssa,139084715.330.000.000.004715.33
Xu, Louis,2010466.530.000.0066.530.00
Peterson, Steven, L,234497.280.000.007.280.00
Fernandez, Darren,2899278.980.000.000.0078.98
Watson, Shelby, J,14911867.970.000.000.00867.97
Bradley, Nathaniel,169551760.470.000.000.001760.47
Gray, Sebastian, B,138782366.960.000.000.002366.96
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Perry, Natalie,1712669.990.000.000.0069.99
Long, Sydney,279217.280.000.000.007.28
Moore, Logan,2634889.970.000.0089.970.00
Lewis, Ethan,27998144.470.000.000.00144.47
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
White, James,253317.280.000.000.007.28
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Williams, Destiny, S,15881564.990.000.00564.990.00
Jai, Logan, H,12031769.490.000.000.00769.49
Ward, Jade, D,14661195.020.000.000.00195.02
Carter, Elijah,216182611.070.000.002611.070.00
Miller, Alexis, A,12196124.930.000.000.00124.93
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Perry, Jackson, J,213064.990.000.000.004.99
Foster, Paige,2742894.480.000.000.0094.48
Brooks, Lucas, S,16089342.030.000.000.00342.03
Hayes, Luis,12880200.730.000.000.00200.73
Green, Sophia, E,249772181.560.002181.560.000.00
Cooper, Alexandra,19541131.240.000.000.00131.24
Shan, Logan,1867760.960.000.0029.9930.97
Bennett, Maria, G,229837.280.000.000.007.28
Bryant, Rachel,220197.280.000.007.280.00
Reed, Sean, L,145974803.310.000.000.004803.31
Hall, Lauren, A,19648100.840.000.000.00100.84
Sanders, Xavier,1672173.750.000.000.0073.75
Green, Gabrielle, M,2181564.470.000.000.0064.47
Ramos, Derrick,18449100.940.000.0030.9769.97
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Washington, Hannah, A,291307.280.000.007.280.00
Morris, Alyssa,28072548.980.000.000.00548.98
Powell, David, W,266151000.440.000.001000.440.00
Miller, Victoria,15816188.020.000.0081.46106.56
Ross, Kaitlyn,16121614.470.000.000.00614.47
Walker, Emma, M,2520998.960.000.000.0098.96
Hayes, Brittany,13941286.820.000.000.00286.82
White, Tyler,14291258.440.000.0049.97208.47
Davis, Marcus, T,17337123.910.000.0086.9536.96
Sanchez, Allison,1666741.720.000.000.0041.72
Allen, Allison, A,1975737.270.000.000.0037.27
Martin, Nicholas,233627.280.000.000.007.28
Campbell, Evan, W,243424828.110.003578.270.001249.84
Bradley, Evan,18506101.940.000.000.00101.94
White, Miguel, S,13988195.520.000.000.00195.52
Henderson, Luke,19200109.240.000.000.00109.24
Alexander, Logan, E,191161183.470.000.000.001183.47
Gray, Cindy, A,13198114.950.000.0099.9714.98
Foster, Nicole, A,2349489.970.000.000.0089.97
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Harris, Joshua, L,2028095.940.000.0030.9764.97
Perez, Jonathan, R,2345512.940.000.000.0012.94
Hughes, Jasmine,276284.990.000.000.004.99
Flores, Miguel,1975077.250.000.000.0077.25
Mehta, Carmen, C,2743694.480.000.000.0094.48
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Chen, Ethan,2054756.970.000.000.0056.97
Perry, Eric,18314115.730.000.0056.9758.76
Gomez, Krista,12760273.180.000.0036.27236.91
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Thompson, Joshua, F,259992181.560.000.002181.560.00
Phillips, Kyle,12158202.200.000.000.00202.20
Butler, Morgan, E,2050068.490.000.000.0068.49
Cox, Sara, P,2775869.990.000.0069.990.00
Sanders, Sean,14341175.150.000.000.00175.15
Martin, Alfredo, P,2148039.980.000.000.0039.98
Stewart, Andrea, M,27252782.990.000.00782.990.00
Ward, Angela, M,2775669.990.000.000.0069.99
Collins, Xavier, C,16646250.910.000.000.00250.91
Stewart, Lucas, J,2934198.970.000.000.0098.97
Collins, Eduardo,139872329.990.000.000.002329.99
Adams, Jennifer,153624745.020.000.000.004745.02
Gomez, Rebekah,13486225.440.000.000.00225.44
Smith, Tyler, J,2034156.970.000.000.0056.97
Bradley, Alexandria,176911779.470.000.000.001779.47
Torres, Abigail,253674.990.000.000.004.99
Reed, Melanie, A,28160574.980.000.000.00574.98
Parker, Katherine,13268289.700.000.0068.97220.73
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Davis, Jonathan,2925913.980.000.000.0013.98
Wu, Randy, J,116472365.940.000.002365.940.00
Miller, Katherine, B,27102782.990.000.00782.990.00
Stewart, Melissa,2517336.960.000.000.0036.96
Griffin, Jack, L,1768632.280.000.000.0032.28
Rogers, Bryce,174022304.980.000.000.002304.98
Richardson, Olivia,204683169.590.000.002049.101120.49
Evans, Connor, J,15402131.550.000.000.00131.55
Lee, Kayla, M,2078115.230.000.000.0015.23
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Rowe, Todd,14586233.940.000.000.00233.94
Wang, Austin, A,1463284.970.000.009.9974.98
Hayes, Dalton, C,188822322.280.000.000.002322.28
Thomas, Jessica,1684894.480.000.0094.480.00
Bell, Alex, M,167543118.600.000.00756.332362.27
Martin, Brianna, M,235834829.390.003578.270.001251.12
Turner, Mary,220154.990.000.000.004.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Cook, Seth,2301064.470.000.000.0064.47
Gray, Mariah,222787.280.000.007.280.00
Wang, Benjamin, R,274547.280.000.000.007.28
Stewart, Gabriella,2803469.990.000.000.0069.99
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Roberts, Robert, R,1898656.970.000.0056.970.00
Mitchell, Caleb, K,268064.990.000.000.004.99
Cook, Joan,235544.990.000.000.004.99
Carter, Savannah, M,120902350.960.000.000.002350.96
Ye, Alisha, J,220084141.233578.270.000.00562.96
Patterson, Aaron, W,191131184.460.000.000.001184.46
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Perry, Melissa,221284142.230.003578.270.00563.96
Ramirez, Richard, C,282397.280.000.007.280.00
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Anderson, Madison, G,2835978.980.000.000.0078.98
Russell, Caleb,23552103.480.000.000.00103.48
Foster, Abigail,1982346.470.000.000.0046.47
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Stewart, Hailey,229036054.220.003578.270.002475.95
Hall, Amber,20106131.950.000.000.00131.95
Davis, Thomas,167641760.470.000.000.001760.47
James, Timothy,213312670.890.000.002670.890.00
Chandra, Allen,2932753.990.000.000.0053.99
Jones, Alexandra, B,2020245.950.000.000.0045.95
Wilson, Andrew, R,182362414.990.000.000.002414.99
Turner, Wyatt,200345769.960.003399.990.002369.97
Lewis, Isabella,2624267.930.000.000.0067.93
Torres, Mackenzie,28153570.470.000.000.00570.47
Gray, Marcus, T,183892401.450.000.000.002401.45
Anderson, Emma, A,185801170.480.000.000.001170.48
Green, Mackenzie, C,280737.280.000.000.007.28
Morris, Seth,189592341.460.000.000.002341.46
Wilson, Grace,17539205.920.000.000.00205.92
Nelson, Jennifer,171471700.990.000.000.001700.99
Wright, Robert, C,158894848.030.000.000.004848.03
Thompson, Ethan,199894495.480.003374.990.001120.49
Phillips, Haley, B,2807939.980.000.000.0039.98
Foster, Alyssa, I,14875839.480.000.000.00839.48
Ross, Haley, T,253612443.350.002443.350.000.00
Bell, Julia,216522646.060.000.002646.060.00
Sanders, Lucas, W,268024.990.000.000.004.99
Brown, Benjamin, D,151874725.320.000.000.004725.32
Torres, Erin,1218287.250.000.0037.2949.96
Murphy, Dalton, N,27043782.990.00782.990.000.00
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Edwards, Logan,250024.990.000.000.004.99
Edwards, Angel, J,2912469.990.000.000.0069.99
Parker, Kaylee, M,2773878.980.000.000.0078.98
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Butler, Jackson, J,183241735.980.000.000.001735.98
Robinson, Madison, W,183772394.970.000.000.002394.97
Allen, Amanda,2235339.980.000.000.0039.98
Long, Natalie,14363192.340.000.000.00192.34
Ross, Alexia, S,13231247.900.000.000.00247.90
Miller, Eduardo,14561158.840.000.0049.97108.87
Reed, Isaac, D,260747.280.000.000.007.28
Smith, Eduardo,2069139.980.000.0039.980.00
Sanchez, Jared, J,2585064.470.000.000.0064.47
Deng, Damien, A,16873578.460.000.000.00578.46

Generated 2025-11-04 02:56:35.734 UTC