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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Rodriguez, Taylor,1607166.960.000.000.0066.96
Kelly, Angel, E,15418232.230.000.000.00232.23
Gonzales, Nathan, M,12107222.230.000.0032.27189.96
Diaz, Luis, D,11203801.770.000.00183.97617.80
Garcia, Christian, J,164913106.330.000.00751.342354.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Thompson, Xavier, R,15761192.410.000.000.00192.41
Collins, Lucas, T,219214142.753578.270.000.00564.48
Nelson, Kevin,1476584.970.000.000.0084.97
Harris, Samuel, M,2477159.980.000.0059.980.00
Hall, Jose, J,17601225.420.000.00155.4569.97
Bennett, Brittany, J,2233239.980.000.000.0039.98
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Anderson, Ashley,206803219.580.000.002049.101170.48
Griffin, Cassidy,264961000.440.000.001000.440.00
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Sanders, Hailey,19647282.040.000.000.00282.04
Anderson, Jasmine, A,235534.990.000.000.004.99
Washington, Christian, R,2668639.980.000.000.0039.98
Clark, William,2902169.990.000.000.0069.99
Stewart, Destiny,13144281.470.000.00134.98146.49
Phillips, Kyle,12158202.200.000.000.00202.20
Gomez, Briana, A,2878443.980.000.000.0043.98
Wright, Robert, C,158894848.030.000.000.004848.03
Evans, Dalton, E,127104774.040.000.002354.982419.06
Cox, Julia, A,206703228.570.000.002049.101179.47
Coleman, Ian,2127639.980.000.000.0039.98
Martin, Madison, C,2049271.970.000.0071.970.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Morris, Seth,189592341.460.000.000.002341.46
Peterson, Morgan, J,168341750.980.000.000.001750.98
Harris, Jacob, G,2367939.980.000.0039.980.00
Hill, Fernando,247634.990.000.000.004.99
Parker, Morgan, S,1677236.960.000.0014.9821.98
Anand, Brendan, L,1984721.980.000.000.0021.98
Reed, Michelle,2804669.990.000.000.0069.99
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Ross, Jose,2744178.980.000.0078.980.00
Thompson, Jose,237314828.110.003578.270.001249.84
Alexander, Taylor,17482146.940.000.0076.9769.97
Washington, Aaron, L,246494.990.000.000.004.99
Ward, Juan, H,215952649.560.000.002049.10600.46
Adams, Gabriel, S,195271219.450.000.000.001219.45
Morris, Paige, W,220414167.233578.270.000.00588.96
Washington, Ian, M,246644368.580.003578.270.00790.31
Nath, Kenneth, W,170372334.970.000.000.002334.97
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Stewart, Melissa,2517336.960.000.000.0036.96
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Richardson, Brian,2860878.980.000.000.0078.98
Phillips, James, G,16846180.950.000.00123.9856.97
_SUM1806517.5068775.49488463.69323085.41926192.91
Butler, Jonathan,261804.990.000.000.004.99
Luo, Jodi,2921368.490.000.000.0068.49
Reed, Morgan, E,2877923.970.000.000.0023.97
Lee, Emma,16948176.430.000.000.00176.43
Williams, Zachary, B,27099782.990.000.00782.990.00
Williams, Austin,2035432.220.000.000.0032.22
Adams, Kyle, E,1881269.990.000.0069.990.00
Reed, Sean, L,145974803.310.000.000.004803.31
Martin, James, M,1987077.250.000.0039.9837.27
Campbell, Hailey,15507267.840.000.00228.9638.88
Taylor, Edward, C,17442319.880.000.00230.9088.98
Butler, Benjamin, C,189722369.970.000.000.002369.97
Chandra, Allen,2932753.990.000.000.0053.99
Roberts, Hunter,282607.280.000.000.007.28
Jenkins, Samantha,113311290.330.000.00410.31880.02
Torres, Mackenzie,28153570.470.000.000.00570.47
Wu, Randy, J,116472365.940.000.002365.940.00
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Russell, Isabella, A,11507645.780.000.0028.48617.30
Garcia, Isabella,18382204.940.000.000.00204.94
Yuan, Carly,19839194.960.000.000.00194.96
Henderson, Abigail,2044139.980.000.000.0039.98
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Gonzalez, Morgan,130651700.990.000.000.001700.99
Watson, Erin, B,227724.990.000.004.990.00
Peterson, Brian,12892419.470.000.00156.27263.20
Wood, Brittany,2877753.990.000.000.0053.99
Russell, Chloe, M,12763589.960.000.000.00589.96
Hayes, Hannah, J,2165656.970.000.000.0056.97
Li, Rafael, M,217527.280.000.000.007.28
Walker, Jacob, N,29027574.980.000.000.00574.98
Foster, Isabel, M,2174571.950.000.000.0071.95
Bell, Julia,216522646.060.000.002646.060.00
Harris, Joshua, L,2028095.940.000.0030.9764.97
Baker, Gabriella,174041709.980.000.000.001709.98
Collins, Luis, J,227655978.610.003578.270.002400.34
Price, Riley, R,139094764.020.000.000.004764.02
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Serrano, Albert, E,133284708.020.000.000.004708.02
Parker, Blake,15008170.530.000.0074.9895.55
Carter, Isaac,137191129.480.000.000.001129.48
Perez, Timothy, L,227304.990.000.000.004.99
Rivera, Amanda,11131115.920.000.000.00115.92
Washington, Elijah, L,250164.990.000.000.004.99
Washington, Miranda,152014793.020.000.000.004793.02
Carter, Katherine,11861286.300.000.000.00286.30
Cox, Katelyn, B,2174230.970.000.000.0030.97
Bell, Chase,180911750.980.000.000.001750.98
Long, Caleb, P,250462181.560.002181.560.000.00
Reed, Marcus,14582111.790.000.0014.9896.81
Peterson, Alex, M,13423132.900.000.000.00132.90
Hernandez, José, M,11253696.610.000.00187.94508.67
King, Morgan,196811179.970.000.000.001179.97
Simmons, Caleb, M,121934833.030.000.002394.972438.06
Allen, Sean, L,12097159.220.000.000.00159.22
Moore, Hunter,14897196.270.000.0071.58124.69
Brown, Fernando,1900191.950.000.0069.9721.98
Murphy, Chase, J,2472958.980.000.000.0058.98
Gray, Brianna,249603008.820.002443.35565.470.00
Stewart, Andrea, M,27252782.990.000.00782.990.00
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Martin, Thomas, A,169521735.980.000.000.001735.98
Simmons, Adam,253274.990.000.000.004.99
Flores, Madison,14416769.490.000.000.00769.49
Hu, Gilbert, L,2876769.990.000.000.0069.99
Wilson, Emily,174002331.950.000.000.002331.95
Ortega, Sheila, M,2763239.980.000.000.0039.98
Henderson, Caroline,2008256.970.000.000.0056.97
Patterson, Aaron, W,191131184.460.000.000.001184.46
Russell, Oscar, A,12140118.170.000.000.00118.17
Miller, Sydney, A,134404818.530.000.000.004818.53
Hughes, Jasmine,276284.990.000.000.004.99
Bryant, Zachary,216552648.070.000.002648.070.00
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Bryant, Kyle,231644807.100.003578.271228.830.00
Hayes, Logan, J,19026113.240.000.0037.2775.97
Coleman, Benjamin, F,234865343.230.003578.270.001764.96
Perry, Marcus, L,206563245.900.000.002071.421174.48
Butler, Ana,260403018.330.000.002443.35574.98
Washington, Kayla, E,14655174.960.000.0069.97104.99
Thompson, Lucas, O,212774.990.000.000.004.99
Sandberg, Isaac,1335053.970.000.000.0053.97
Sun, Arturo, C,11498557.540.000.00151.90405.64
Moore, Ian, L,2463939.980.000.000.0039.98
Collins, Alex, S,287812.290.000.000.002.29
She, Shawn, J,16902141.980.000.000.00141.98
Cooper, Grace, C,1601294.260.000.000.0094.26
Wilson, Eduardo,15323804.470.000.000.00804.47
Taylor, Brianna,17027230.900.000.00145.4285.48
Turner, Amanda, L,203183241.900.002071.420.001170.48
Evans, Jesse,2191639.980.000.000.0039.98
Sanchez, Allison,1666741.720.000.000.0041.72
Price, Caroline,180511735.980.000.000.001735.98
Sanchez, Shelby,16021539.990.000.000.00539.99
Simmons, Mariah,266831270.820.00699.100.00571.72
Lee, Don,188392384.970.000.000.002384.97
Watson, Michelle, H,262352181.560.000.002181.560.00
King, Aaron, L,117394758.030.000.002359.982398.05
Miller, Victoria,15816188.020.000.00118.0569.97
Powell, Blake, J,2237139.980.000.000.0039.98
Smith, Austin,13707149.050.000.000.00149.05
Washington, Taylor,212664525.070.000.002049.102475.97
White, Emma, N,16090604.960.000.000.00604.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Johnson, Cameron, R,137201155.480.000.000.001155.48
Powell, Angela, R,12970471.110.000.000.00471.11
Flores, Kevin,15878225.920.000.0069.97155.95
Simmons, Brittany,2923139.980.000.000.0039.98
Hayes, Gavin, A,194001179.470.000.000.001179.47
Cooper, Andrea,2932378.980.000.000.0078.98
Lee, Samantha, B,2737878.980.000.000.0078.98
Chavez, Kara, P,13285214.350.000.0012.94201.41
Carter, Luis, E,258832443.350.002443.350.000.00
Long, Gabrielle,198305765.923374.990.000.002390.93
Wang, Zachary,2214489.970.000.000.0089.97
Martinez, Dominique,287888.990.000.008.990.00
Zhao, Clarence, R,1982671.970.000.0071.970.00
Washington, Vanessa,238194802.110.003578.270.001223.84
Lee, Ian,19646197.040.000.000.00197.04
Sanders, Zoe, L,248254.990.000.000.004.99
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Smith, Katherine, J,13197105.190.000.000.00105.19
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Turner, Sean,227324133.240.003578.270.00554.97
Patterson, Grace, M,27560782.990.000.00782.990.00
Russell, Richard,2763322.260.000.000.0022.26
Parker, Jordan,216212616.860.000.002049.10567.76
Martinez, Carol, D,17656578.460.000.000.00578.46
James, Morgan, E,2324539.980.000.000.0039.98
Perez, Jordan, A,292674.990.000.000.004.99
Bryant, Gabriel,2765669.990.000.000.0069.99
Hill, Sydney,264821000.440.000.001000.440.00
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Reed, Erin, I,14353128.840.000.0074.9853.86
Bradley, Rachel,158504813.040.000.000.004813.04
Sanz, Lori, L,238654891.610.003578.270.001313.34
Garcia, Henry, B,112871009.240.000.00234.49774.75
Moreno, Renee, C,12936265.220.000.000.00265.22
Townsend, Bryan,14077180.730.000.000.00180.73
Lal, Jack, R,185251735.980.000.000.001735.98
Alexander, Ryan, J,14078839.480.000.00839.480.00
Price, Miranda,26629699.10699.100.000.000.00
Martin, Alfredo, P,2148039.980.000.000.0039.98
Torres, Abigail,253674.990.000.000.004.99
Ross, Kelly,2607676.960.000.000.0076.96
Perez, Barry, M,2728269.990.000.000.0069.99
Brown, Anna,1624795.820.000.000.0095.82
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Rivera, Makayla, A,2878334.990.000.000.0034.99
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Kelly, Erin, D,2351364.470.000.000.0064.47
Bailey, Hailey, R,262704.990.000.000.004.99
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Griffin, Marcus,2075634.560.000.000.0034.56
Raje, Mindy, A,16083561.970.000.000.00561.97
Patterson, Eduardo,11142866.810.000.0072.26794.55
Anderson, Ryan, W,132712319.990.000.000.002319.99
Wilson, Fernando,16643126.960.000.000.00126.96
Stewart, Amanda, M,1531094.440.000.000.0094.44
Hall, Kyle, J,1749169.970.000.000.0069.97
Ortega, Javier, P,127852294.990.000.000.002294.99
Hill, Jordan, J,16005198.730.000.00102.2796.46
Thomas, David,168363193.790.000.000.003193.79
Hall, Morgan,2172641.950.000.000.0041.95
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Robinson, Abigail, R,183792362.270.000.000.002362.27
Ruiz, Philip,1807781.460.000.000.0081.46
Moore, Jennifer, A,2175964.470.000.000.0064.47
Rubio, Kellie,27653128.970.000.000.00128.97
Patterson, Austin, O,270247.280.000.000.007.28
Smith, Megan, J,2671668.970.000.000.0068.97
Price, Rachel, D,2532889.970.000.000.0089.97
Torres, Victoria,17551160.920.000.000.00160.92
Adams, Connor,214232888.560.000.002049.10839.46
Perry, Oscar,227856029.570.003578.272451.300.00
Cooper, Brian, L,13760128.840.000.000.00128.84
Richardson, Evan, J,15488165.300.000.000.00165.30
Rogers, Jade, I,14332102.250.000.000.00102.25
Stewart, Gabriella,2803469.990.000.000.0069.99
Gray, Alexandria, E,253632443.350.002443.350.000.00
Harris, Noah,292562393.060.000.002393.060.00
Perez, Dalton,110911125.360.000.00213.86911.50
Gutierrez, Jerome,127832420.460.000.000.002420.46
Wright, Carol, C,12928247.410.000.0033.98213.43
Morgan, Isabella, L,28602144.470.000.000.00144.47
Peterson, Jared,11502829.370.000.00171.95657.42
Murphy, Shelby,244894.990.000.000.004.99
Jai, Connor, D,27253782.990.000.00782.990.00
Mitchell, Caleb, K,268064.990.000.000.004.99
Butler, Dalton, A,133454759.510.000.000.004759.51
Bennett, Maria, G,229837.280.000.000.007.28
Dominguez, Erika, C,21251191.270.000.000.00191.27
Williams, Destiny, S,15881564.990.000.00564.990.00

Generated 2025-11-01 00:04:38.149 UTC