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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Green, Xavier,2356739.980.000.000.0039.98
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Baker, Isaiah,12106169.540.000.000.00169.54
Gray, Seth, M,2008785.480.000.000.0085.48
Clark, Miguel, D,169872414.990.000.000.002414.99
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Morgan, Angela,24665109.970.000.000.00109.97
Hall, Kaylee, E,1975137.270.000.000.0037.27
Gomez, Rebekah,13486225.440.000.000.00225.44
Carter, Marcus, l,2147131.970.000.000.0031.97
Powell, Katherine, C,14574177.600.000.000.00177.60
White, Miguel, S,13988195.520.000.000.00195.52
Collins, Jonathan,16849119.980.000.000.00119.98
Turner, Amanda, L,203183241.900.002071.420.001170.48
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Alvarez, Melody,2507068.490.000.000.0068.49
Morgan, Brianna, D,111362380.470.000.002380.470.00
Russell, Chloe, M,12763589.960.000.000.00589.96
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Alexander, Paige, W,1860459.250.000.0037.2721.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Thomas, David,168363193.790.000.000.003193.79
Blue, Paige,2170313.980.000.000.0013.98
Campbell, Hailey,15507267.840.000.00228.9638.88
Washington, Lauren, R,229985329.250.003578.271750.980.00
Wood, Gavin,16964108.540.000.0093.5614.98
Bradley, Evan,18506101.940.000.000.00101.94
Lopez, Bailey, R,185571179.470.000.001179.470.00
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Moreno, Lance, A,2922939.980.000.000.0039.98
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Rivera, Sara,187852350.960.000.000.002350.96
Edwards, Connor,16950211.010.000.000.00211.01
Evans, Connor, J,15402131.550.000.000.00131.55
Young, Julia, J,274144.990.000.000.004.99
Bryant, Connor,238424828.110.003578.270.001249.84
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Rogers, Andrea, L,14328308.660.000.00112.95195.71
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Watson, Devin, A,18875114.950.000.000.00114.95
Carter, Luis, E,258832443.350.002443.350.000.00
Wright, Kyle,2371626.970.000.000.0026.97
Flores, Logan, K,14631848.470.000.000.00848.47
Thomas, Thomas,216292624.080.000.002049.10574.98
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Scott, Haley,13701154.540.000.000.00154.54
Long, Kaitlyn,233964891.610.003578.270.001313.34
Powell, Vanessa,26630699.100.00699.100.000.00
Flores, Hannah,1952540.230.000.000.0040.23
Howard, Brianna, D,246304.990.000.000.004.99
Cooper, Alexandra,19541131.240.000.000.00131.24
Parker, Blake,15008170.530.000.0074.9895.55
Ye, Alisha, J,220084141.233578.270.000.00562.96
Gonzalez, Molly,1637021.980.000.000.0021.98
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Miller, Kayla, A,236734.990.000.000.004.99
She, Alisha, G,247574343.590.003578.270.00765.32
Evans, Jordan,2920939.980.000.0039.980.00
Evans, Alexandra,2432268.490.000.000.0068.49
Stewart, Alex, M,2008463.150.000.000.0063.15
Posti, Juha-Pekka,2221912.940.000.000.0012.94
King, Aaron, L,117394758.030.000.002359.982398.05
Ross, Anna, D,15494275.440.000.0029.99245.45
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Stewart, Sara,17347119.720.000.000.00119.72
Hayes, Brittany,13941286.820.000.000.00286.82
Martin, Brandon, S,2169139.980.000.000.0039.98
Alexander, Julia, J,15291889.470.000.000.00889.47
Lee, Samantha, B,2737878.980.000.000.0078.98
Rodriguez, Julia, A,264884.990.000.004.990.00
Wilson, Christian,27085782.990.000.00782.990.00
Blue, Melanie, L,178611749.960.000.000.001749.96
White, Christopher, R,260492181.560.000.002181.560.00
Hayes, Gavin, A,194001179.470.000.000.001179.47
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Chen, David,2720839.980.000.000.0039.98
Butler, Dalton, A,133454759.510.000.000.004759.51
Cooper, Angela,195261179.470.000.000.001179.47
Brown, Samantha, G,2514739.980.000.000.0039.98
Reed, Sean, L,145974803.310.000.000.004803.31
Kelly, Julia,2379867.930.000.0067.930.00
Hayes, Oscar,2652729.260.000.000.0029.26
Suarez, Juan, R,167631700.990.000.000.001700.99
Hu, Gilbert, L,2876769.990.000.000.0069.99
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Hill, Haley, J,161033142.320.000.00792.342349.98
Clark, Anthony,27071782.990.00782.990.000.00
Perry, Melissa,221284142.230.003578.270.00563.96
Alexander, Ryan, J,14078839.480.000.00839.480.00
Adams, Kyle, E,1881269.990.000.0069.990.00
Hughes, Eduardo,15564188.520.000.000.00188.52
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Perez, Angel, S,213362628.350.000.002071.42556.93
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Flores, Jordyn,252882721.550.002181.560.00539.99
Hall, Jan, M,11740334.120.000.00235.1598.97
Campbell, Timothy,2584513.980.000.000.0013.98
Cooper, Brooke,195361120.490.000.000.001120.49
Rogers, Sara,198744544.450.003374.990.001169.46
Sanders, Xavier,1672173.750.000.000.0073.75
Russell, Samantha,11211723.560.000.00118.46605.10
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Coleman, Luke, A,11723152.550.000.0069.9882.57
Adams, Mason, T,2052864.470.000.0064.470.00
Watson, Cole, A,217684118.263578.270.000.00539.99
Sanders, Alexandra,259112181.560.000.002181.560.00
Phillips, Jack, R,259952443.350.000.002443.350.00
Bryant, Jackson, J,2533239.980.000.000.0039.98
Rogers, Faith,2468259.980.000.000.0059.98
Carter, Bailey,213322616.860.000.002616.860.00
Martinez, Joseph, E,2921459.980.000.0059.980.00
Baker, Sean, T,247782858.490.002181.56676.930.00
Phillips, Adam, R,227484188.240.003578.270.00609.97
Mitchell, Savannah,261153052.800.000.002443.35609.45
Phillips, Aaron, R,2494739.980.000.000.0039.98
Martin, Jill, C,11824181.030.000.0069.97111.06
Kelly, Trinity,2609515.230.000.000.0015.23
Torres, Dalton,235037.280.000.007.280.00
Ross, Miranda,145984839.000.000.000.004839.00
Hughes, Brittany,14387898.460.000.000.00898.46
Campbell, Adam, A,214002688.890.000.002071.42617.47
Martin, John, A,144364776.010.000.000.004776.01
Jenkins, Austin, D,15748296.910.000.000.00296.91
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Evans, James, C,206654408.560.000.002049.102359.46
Bell, Eduardo,27101782.990.000.00782.990.00
Reed, Michelle,2804669.990.000.000.0069.99
White, Cameron,238304802.110.003578.270.001223.84
King, Morgan,196811179.970.000.000.001179.97
Scott, Allison,14497804.480.000.000.00804.48
Diaz, Luis, D,11203801.770.000.00183.97617.80
Turner, Courtney, A,229753578.270.003578.270.000.00
Russell, Caleb,23552103.480.000.000.00103.48
Gill, Robyn, J,127651750.980.000.001750.980.00
Flores, Xavier,238664828.110.003578.270.001249.84
Coleman, Ian,2127639.980.000.000.0039.98
Kapoor, Preston,2143156.970.000.000.0056.97
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Madan, Carmen, V,155674720.270.000.000.004720.27
Hall, Taylor, J,169951735.980.000.000.001735.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Flores, Miguel,1975077.250.000.000.0077.25
Martin, Gina, E,11078793.270.000.00158.36634.91
Wilson, Emily,174002331.950.000.000.002331.95
Gray, Marcus, T,183892401.450.000.000.002401.45
Jai, Jose,12944164.210.000.0039.99124.22
Hughes, Miranda,266784.990.000.000.004.99
Powell, David, W,266151000.440.000.001000.440.00
Chen, Ethan,2054756.970.000.000.0056.97
Bell, Gabrielle,223735976.320.003578.270.002398.05
Simmons, Jose,2464739.980.000.000.0039.98
Ross, Rachel, C,206693169.590.000.002049.101120.49
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Campbell, Gabriella,188411145.480.000.000.001145.48
Turner, Wyatt,200345769.960.003399.990.002369.97
Washington, Ian, M,246644368.580.003578.270.00790.31
Winston, Ethan, R,216222612.060.000.002049.10562.96
Wilson, Grace,17539205.920.000.000.00205.92
Johnson, Cameron, R,137201155.480.000.000.001155.48
Butler, Jackson, J,183241735.980.000.000.001735.98
Diaz, Hailey, W,116932294.990.000.002294.990.00
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Bradley, Nathaniel,169551760.470.000.000.001760.47
Thompson, Kayla, D,12363273.900.000.000.00273.90
Anand, Brendan, L,1984721.980.000.000.0021.98
Richardson, Evan, J,15488165.300.000.000.00165.30
Price, Lauren, J,14079184.740.000.0037.29147.45
Patterson, Eduardo,11142866.810.000.0072.26794.55
Perry, Samuel,18811100.960.000.00100.960.00
Hayes, Carson, A,124472331.950.000.000.002331.95
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Campbell, Chloe,11212760.930.000.00231.72529.21
Collins, Lucas, T,219214142.753578.270.000.00564.48
Parker, Caleb, A,2631813.980.000.000.0013.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
Martin, James, M,1987077.250.000.000.0077.25
Rivera, Rachel, S,2899678.980.000.000.0078.98
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Tang, Carl,2123832.270.000.000.0032.27
Adams, Miguel,11659213.520.000.000.00213.52
Green, Chloe, J,1465892.820.000.000.0092.82
Baker, Gabriella,174041709.980.000.000.001709.98
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Lal, Jonathan,2009671.460.000.000.0071.46
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Williams, Joshua,260514.990.000.000.004.99
Flores, Julian,158464943.320.000.000.004943.32
Sharma, Jackson,16876151.840.000.000.00151.84
Cook, Joan,235544.990.000.000.004.99
Allen, Jack, M,291372419.060.000.002419.060.00
Chen, Jonathan, G,13096200.690.000.000.00200.69
James, Jeremiah, S,11661287.700.000.000.00287.70
Barnes, Dalton, C,178581700.990.000.000.001700.99
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Brooks, Makayla,222526047.320.003578.270.002469.05
Foster, Aaron,155664912.470.000.000.004912.47
_SUM1806517.5065197.22487005.99323518.76930795.53
Collins, Allison,28581119.980.000.000.00119.98
James, Morgan, E,2324539.980.000.000.0039.98
Ward, Nicole, L,212724435.380.000.002071.422363.96
Watson, Emma,17481126.940.000.000.00126.94
Alexander, Caroline,176541759.970.000.000.001759.97
Rowe, Todd,14586233.940.000.000.00233.94
Hall, Luke, E,14745902.460.000.000.00902.46
Ware, Dennis, L,237254828.110.003578.270.001249.84
Flores, Emma, P,15543180.940.000.000.00180.94
Flores, Kevin,15878225.920.000.0069.97155.95
Collins, Charles, B,29041628.450.000.000.00628.45
Smith, Zachary, W,2378358.980.000.0058.980.00
Coleman, Stephanie,2226489.970.000.000.0089.97
Moreno, Meredith, D,2228589.970.000.000.0089.97
Watson, Victoria,16125588.960.000.000.00588.96
Ross, Antonio,18322148.890.000.000.00148.89
Thomas, Isabella, M,27265782.990.000.00782.990.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Hall, Charles,234764.990.000.000.004.99
Griffin, Marcus,2075634.560.000.000.0034.56
Sanchez, Faith,270494.990.000.000.004.99
Smith, Noah,13175166.920.000.000.00166.92
Campbell, Angel, D,195461174.480.000.000.001174.48
Ward, Lucas, N,183631700.990.000.000.001700.99
Yuan, Leonard, F,167911729.970.000.000.001729.97
Cooper, Stephanie,249762181.560.002181.560.000.00
Blanco, Armando, F,139182397.950.000.000.002397.95
Hughes, Justin, M,181222439.990.000.000.002439.99
Reed, Gabriella, A,2743778.980.000.000.0078.98
Russell, Richard,2763322.260.000.000.0022.26
Martinez, Dominique,287888.990.000.008.990.00
Edwards, Elijah, D,281577.280.000.000.007.28
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Bell, Brooke, H,2325339.980.000.000.0039.98
Taylor, Zachary, M,27082782.990.000.00782.990.00
Sanders, Zoe, L,248254.990.000.000.004.99
Moore, Jessica, J,2008576.760.000.000.0076.76
Brown, Dylan, J,124492351.960.000.000.002351.96
Campbell, Hunter,17422174.920.000.000.00174.92
Perez, Dalton,110911125.360.000.00213.86911.50
Reed, Erin, I,14353128.840.000.0074.9853.86
Allen, Luke,113162349.980.000.002349.980.00
Jones, Charles,22882101.450.000.000.00101.45
James, Maria,1624391.970.000.0069.9921.98
Jackson, Charles, P,112771305.660.000.00237.821067.84
Garcia, Henry, B,112871009.240.000.00219.26789.98

Generated 2025-11-04 16:43:00.210 UTC