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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Torres, Mariah,16380195.950.000.000.00195.95
Baker, Allison,2649558.980.000.000.0058.98
Dominguez, Meghan,14370122.560.000.000.00122.56
Bailey, Hailey, R,262704.990.000.000.004.99
Nelson, Katherine,2802178.980.000.000.0078.98
Martinez, Grace, M,17385208.690.000.0069.97138.72
Gonzales, Miranda,11660324.720.000.000.00324.72
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Morris, Mason, J,22349124.990.000.000.00124.99
Griffin, Miguel,2146476.970.000.000.0076.97
Griffin, Maria,1840763.250.000.000.0063.25
Hughes, Zachary,12203157.910.000.000.00157.91
Evans, Dalton, E,127104774.040.000.002354.982419.06
Scott, Eric,282484.990.000.004.990.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Scott, Haley,13701154.540.000.000.00154.54
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Thomas, Jeremiah,183721760.470.000.000.001760.47
Rodriguez, Julia, A,264884.990.000.004.990.00
White, Emma, N,16090604.960.000.000.00604.96
Jackson, Andrew,2047985.480.000.000.0085.48
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Perry, Natalie,1712669.990.000.000.0069.99
Bell, Julia,216522646.060.000.002646.060.00
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Price, Riley, R,139094764.020.000.000.004764.02
Adams, Connor,214232888.560.000.002049.10839.46
Walker, Brandon, J,159164793.270.000.000.004793.27
Blue, Makayla,1900029.990.000.000.0029.99
Morris, Alyssa,28072548.980.000.000.00548.98
James, Julia,2497567.930.000.000.0067.93
Li, Connor,201863191.910.002071.420.001120.49
Alexander, Thomas,207607.280.000.000.007.28
Martin, Thomas, A,169521735.980.000.000.001735.98
Robinson, William,20103103.480.000.000.00103.48
Chander, Wayne, S,243444329.610.003578.27751.340.00
Reed, Isaac, D,260747.280.000.000.007.28
Hayes, Arianna,259912845.520.000.002181.56663.96
Blue, Marcus, L,27550782.990.000.00782.990.00
Watson, Shelby, J,14911867.970.000.000.00867.97
Ward, Stephanie, A,27429782.990.000.00782.990.00
Cox, Arianna, D,1892789.250.000.000.0089.25
Miller, Jill,129142329.980.000.000.002329.98
Gray, Brianna,249603008.820.002443.35565.470.00
Hall, Fernando,2210090.950.000.000.0090.95
Flores, Brittany,169062359.980.000.000.002359.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Kumar, Elijah,15197156.920.000.000.00156.92
Roberts, Mason, D,111761106.680.000.00494.64612.04
Hayes, Gavin, A,194001179.470.000.000.001179.47
Baker, Robert, A,273007.280.000.007.280.00
Collins, Alex, S,287812.290.000.000.002.29
Campbell, Hailey,15507267.840.000.00228.9638.88
Hall, Noah, A,1525175.250.000.000.0075.25
Jones, Joshua,184012294.990.000.000.002294.99
Srini, Ruben,18078200.940.000.000.00200.94
Gray, Seth, M,2008785.480.000.000.0085.48
Simmons, Nicole, S,2617729.480.000.000.0029.48
Carter, Isaac,137191129.480.000.000.001129.48
Roberts, Amber, W,215822638.060.000.002049.10588.96
Richardson, Charles, I,121144719.020.000.002325.962393.06
Zhang, Nathan, L,2910478.980.000.000.0078.98
Lewis, Ethan,27998144.470.000.000.00144.47
Hughes, Miranda,266784.990.000.000.004.99
Roberts, Wyatt,15900699.970.000.00699.970.00
Williams, Morgan, C,203733226.900.000.002071.421155.48
Johnson, James,234984.990.000.000.004.99
Walker, Isabella,243864143.740.003578.27565.470.00
Smith, Megan, J,2671668.970.000.000.0068.97
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Phillips, Devin,18759112.060.000.000.00112.06
Reed, Catherine, M,203807.280.000.000.007.28
Howard, Isaiah,259813018.330.002443.350.00574.98
Martinez, Matthew, L,16009170.450.000.000.00170.45
Bell, Christina,2609939.980.000.000.0039.98
Mitchell, Bailey, B,267067.280.000.007.280.00
Taylor, Natalie, M,14338828.740.000.000.00828.74
Brooks, Victoria, H,16479158.510.000.000.00158.51
Patterson, Natalie,16123629.970.000.000.00629.97
Collins, Lucas, T,219214142.753578.270.000.00564.48
Bryant, Jackson, J,2533239.980.000.000.0039.98
Moreno, Marie,2773969.990.000.000.0069.99
Foster, Carson, L,16959135.350.000.0085.4849.87
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Reed, Megan, A,181181750.980.000.000.001750.98
Anderson, Emma, A,185801170.480.000.000.001170.48
Ross, Anna, D,15494275.440.000.0029.99245.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Sharma, Kathryn,20740140.940.000.000.00140.94
Nelson, Henry,193941155.480.000.000.001155.48
Collins, Isaac,260777.280.000.000.007.28
Allen, Madeline,2924068.970.000.000.0068.97
Hall, Charles,234764.990.000.000.004.99
Foster, Kayla,1969371.950.000.000.0071.95
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Sara, Ivan, L,2509067.930.000.000.0067.93
Zukowski, Jake,220584118.263578.270.000.00539.99
Stewart, Alex, M,2008463.150.000.000.0063.15
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Lopez, Carlos,186171147.770.000.000.001147.77
Edwards, Alexandra,133582386.940.000.000.002386.94
Barnes, Kayla,2425639.980.000.0039.980.00
Rivera, Sara,187852350.960.000.000.002350.96
_SUM1806517.5065197.22487005.99323518.76930795.53
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Powell, David, W,266151000.440.000.001000.440.00
Bradley, Nathaniel,169551760.470.000.000.001760.47
Wilson, Tyler, L,15879196.930.000.000.00196.93
Smith, Alexandra,2829261.960.000.000.0061.96
Powell, Miranda, J,153044843.000.000.000.004843.00
Hall, Jason, A,29351119.980.000.000.00119.98
Chen, Jack, E,17579151.430.000.000.00151.43
Hughes, Destiny, P,28027119.980.000.000.00119.98
Powell, Sydney, M,14886539.990.000.00539.990.00
Sandberg, Chase,2190475.970.000.000.0075.97
Williams, Austin,2035432.220.000.000.0032.22
Ramos, Kristi,151764703.030.000.000.004703.03
Hall, Amber,20106131.950.000.000.00131.95
Parker, Jeremy,2866878.980.000.0078.980.00
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Griffin, Xavier,228775962.340.003578.270.002384.07
Foster, Isabelle,2637739.980.000.000.0039.98
Butler, Cassidy, L,21792114.460.000.000.00114.46
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Peterson, Julia, P,16497132.710.000.000.00132.71
Davis, Richard, R,15549574.980.000.00574.980.00
Green, Eric,2738069.990.000.000.0069.99
Gray, Sebastian, B,138782366.960.000.000.002366.96
Perry, Ryan,132494795.340.000.000.004795.34
Brown, Anthony, J,19399151.430.000.000.00151.43
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Edwards, Amber, B,2051776.970.000.000.0076.97
Griffin, Seth, R,17585164.460.000.0078.9885.48
Howard, Alexandra,207363194.580.000.002049.101145.48
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Washington, Riley, L,185441155.480.000.001155.480.00
Bailey, Lauren,15864103.550.000.000.00103.55
Flores, Emily,13206163.190.000.0069.9793.22
Lewis, Seth,26782699.100.00699.100.000.00
Reed, Marcus,14582111.790.000.0014.9896.81
Edwards, Logan,250024.990.000.000.004.99
Harris, Anthony,2144721.980.000.000.0021.98
Sharma, Thomas, A,18637121.940.000.000.00121.94
Phillips, Miguel,2049812.940.000.000.0012.94
Prasad, Donald,15413318.920.000.00123.98194.94
Sanchez, Allison,1666741.720.000.000.0041.72
Flores, Logan, K,14631848.470.000.000.00848.47
Powell, Lauren, E,1966275.970.000.000.0075.97
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Zhao, Clarence, R,1982671.970.000.0071.970.00
Thomas, William, A,216142589.090.000.002049.10539.99
Scott, Allison,14497804.480.000.000.00804.48
Coleman, Joan, W,2669964.470.000.000.0064.47
Lal, Jonathan,2009671.460.000.000.0071.46
Lewis, Brandon, A,2903769.990.000.000.0069.99
Kumar, Zachary,254334.990.000.000.004.99
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Simmons, Anna, K,124512367.920.000.000.002367.92
Torres, Taylor,16666205.440.000.00123.9881.46
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Johnson, Jonathan,220597.280.000.000.007.28
Lu, Alejandro,2562039.980.000.000.0039.98
Washington, Elijah, L,250164.990.000.000.004.99
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Hall, Luke, E,14745902.460.000.000.00902.46
Thomas, Charles,250942443.350.002443.350.000.00
Russell, Nicole, M,182372318.960.000.000.002318.96
Harris, Seth, M,161402528.330.000.002528.330.00
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Parker, Jordan,216212616.860.000.002049.10567.76
Hernandez, Jamie,27283119.980.000.00119.980.00
Smith, Justin, P,1982721.980.000.000.0021.98
Lal, Luke, L,11019698.230.000.00139.93558.30
Robinson, Lauren,2719668.490.000.0068.490.00
Thompson, Devin,207084406.400.000.002071.422334.98
Adams, Mason, T,2052864.470.000.0064.470.00
Martinez, Jonathan,1330366.250.000.000.0066.25
Hill, Jordan, J,16005198.730.000.00102.2796.46
Powell, Caleb, G,216132610.580.000.002049.10561.48
Thomas, David,168363193.790.000.000.003193.79
Kelly, Angel, E,15418232.230.000.000.00232.23
Kelly, Haley,15511128.560.000.000.00128.56
Turner, Jose,11784272.690.000.000.00272.69
Wood, Brittany,2877753.990.000.000.0053.99
Hayes, Jason,261764.990.000.000.004.99
Torres, Dalton,235037.280.000.007.280.00
Hill, Timothy,14871848.470.000.000.00848.47
Collins, Sierra,185491169.460.000.001169.460.00
Barnes, Blake, A,178651789.970.000.000.001789.97
Watson, Marcus,2271585.480.000.000.0085.48
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Scott, Sean, F,2475539.980.000.000.0039.98
Diaz, Jason,17374206.630.000.0089.46117.17
Ward, Jade, D,14661195.020.000.000.00195.02
Brown, Dalton, N,218134118.263578.270.000.00539.99
Ward, Emma, W,2179659.980.000.000.0059.98
Young, Sierra, J,11619634.840.000.0034.99599.85
Rivera, Rachel, S,2899678.980.000.000.0078.98
Cooper, Paige,14119148.940.000.000.00148.94
Cooper, Christina, C,265121000.440.000.001000.440.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Hernandez, José, M,11253696.610.000.0098.97597.64
Jai, Kevin,1983678.960.000.0038.9839.98
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Price, Stephanie,258922443.350.002443.350.000.00
Griffin, Isabelle,249864.990.000.000.004.99
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Bryant, Connor,238424828.110.003578.270.001249.84
Flores, Morgan,19817118.940.000.0039.9878.96
Cook, Joan,235544.990.000.000.004.99
Miller, Andrew, C,271104.990.000.000.004.99
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Robinson, Zachary, L,137092332.280.000.000.002332.28
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Turner, Adam, K,16109548.980.000.000.00548.98
Thomas, Dylan,198737.280.000.000.007.28
Thompson, Jose,237314828.110.003578.270.001249.84
Smith, Andrew,1472387.570.000.0014.9872.59
Brooks, Lucas, S,16089342.030.000.000.00342.03
Turner, Samuel,2742069.990.000.0069.990.00
Parker, Morgan, S,1677236.960.000.0014.9821.98
Ross, Jose,2744178.980.000.0078.980.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Gonzales, Jordan,2368113.980.000.000.0013.98
Bryant, Samantha,18345115.470.000.000.00115.47
Reed, Bryan,18884133.930.000.000.00133.93
Davis, Thomas,167641760.470.000.000.001760.47
Deng, Damien, A,16873578.460.000.000.00578.46
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Hill, Fernando,247634.990.000.000.004.99
Robinson, Sarah, A,2702859.980.000.000.0059.98
Diaz, Elijah,200004495.480.003374.990.001120.49
Torres, Christina, M,20746119.950.000.000.00119.95
Sanders, Megan, A,15376136.240.000.000.00136.24
Chen, David,2720839.980.000.000.0039.98
Foster, Abigail,1982346.470.000.000.0046.47
Shan, Gabriel, T,2773169.990.000.000.0069.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Sanders, Hailey,19647282.040.000.000.00282.04
Henderson, Hailey, C,171481775.470.000.000.001775.47

Generated 2025-11-04 10:08:01.338 UTC