[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 1000  >   <  TAKE 1000   

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hill, Blake,11748131.540.000.000.00131.54
Rogers, Jared, J,12166162.220.000.000.00162.22
Scott, Mason,2355139.980.000.000.0039.98
Murphy, Dalton, N,27043782.990.00782.990.000.00
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Garcia, Xavier, M,2030071.970.000.000.0071.97
Rowe, Todd,14586233.940.000.000.00233.94
Brown, Isabella, L,266921266.860.00699.100.00567.76
Price, Jeremy,259892744.520.000.002181.56562.96
Thompson, Ethan,199894495.480.003374.990.001120.49
Griffin, Jordan,13095328.890.000.0069.97258.92
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Gomez, Briana, A,2878443.980.000.000.0043.98
Robinson, Abigail, R,183792362.270.000.000.002362.27
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Edwards, Eric,2462768.490.000.000.0068.49
Barnes, Elizabeth, J,249397.280.000.000.007.28
Reed, Paige,221126047.323578.270.002469.050.00
Sanders, Paige,252872983.340.002443.350.00539.99
Hughes, Antonio, P,15913712.270.000.00712.270.00
Li, Connor,201863191.910.002071.420.001120.49
Thomas, Edward, E,19147133.710.000.000.00133.71
Diaz, Luke,12054402.530.000.00139.97262.56
Baker, Robert, A,273007.280.000.007.280.00
Stewart, Gabriella,2803469.990.000.000.0069.99
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Simmons, Haley, T,262022749.320.000.002181.56567.76
Howard, Erin, L,183621725.210.000.000.001725.21
Li, Rafael, M,217527.280.000.000.007.28
Rodriguez, Richard,12969180.790.000.000.00180.79
Fernandez, Cesar,200355694.980.003374.990.002319.99
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Butler, Jonathan,261804.990.000.000.004.99
Young, Kaylee, S,13756298.490.000.0058.47240.02
Nelson, Henry,193941155.480.000.000.001155.48
Martinez, Joseph, E,2921459.980.000.0059.980.00
Russell, Chloe, M,12763589.960.000.000.00589.96
Bailey, Olivia,238924.990.000.000.004.99
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Sanchez, Alex, K,131014736.030.000.000.004736.03
James, Maria,1624391.970.000.0069.9921.98
Parker, James,11808610.190.000.00186.77423.42
Robinson, William,20103103.480.000.000.00103.48
Hughes, Isabella,2304851.460.000.000.0051.46
Rogers, Sean, G,18685124.460.000.000.00124.46
Yuan, Leonard, F,167911729.970.000.000.001729.97
Perry, Jackson, J,213064.990.000.000.004.99
Russell, Richard,2763322.260.000.000.0022.26
Russell, Rachel, C,2158124.270.000.0024.270.00
Collins, Xavier, C,16646250.910.000.000.00250.91
Cooper, Brian, L,13760128.840.000.000.00128.84
Zhao, Karen, L,254082735.530.002181.560.00553.97
Stewart, Amanda, M,1531094.440.000.000.0094.44
Rogers, Bryce,174022304.980.000.000.002304.98
Johnson, Christopher,119794813.760.000.002352.212461.55
Martinez, Grace, M,17385208.690.000.0069.97138.72
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Lee, Kayla, M,2078115.230.000.000.0015.23
Jones, Dalton, T,189512334.970.000.000.002334.97
Powell, Caleb, G,216132610.580.000.002049.10561.48
Patterson, Alexis,213484392.020.000.002049.102342.92
Suri, Carolyn, S,12972175.710.000.000.00175.71
Thomas, Logan, A,14091251.200.000.0053.99197.21
Phillips, Kyle,12158202.200.000.000.00202.20
Hall, Fernando,2210090.950.000.000.0090.95
Ward, Devin, J,15378170.910.000.0076.9593.96
Nelson, Jennifer,171471700.990.000.000.001700.99
Blue, Marcus, L,27550782.990.000.00782.990.00
Hughes, Austin, P,183681754.980.000.000.001754.98
Murphy, Brianna, K,2834269.990.000.000.0069.99
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Long, Sarah,173721729.970.000.000.001729.97
Alexander, Thomas,207607.280.000.000.007.28
Morgan, Isabella, L,28602144.470.000.000.00144.47
Phillips, Jack, R,259952443.350.000.002443.350.00
Watson, Richard,15943365.410.000.00154.98210.43
Young, Savannah,259712749.320.002181.560.00567.76
Johnson, Jacob, I,28069553.970.000.000.00553.97
Garcia, Chloe, M,110372374.230.000.002374.230.00
Scott, Allison,14497804.480.000.000.00804.48
Moreno, Marie,2773969.990.000.000.0069.99
Thompson, Abigail,243324816.090.003578.270.001237.82
Adams, Jennifer,153624745.020.000.000.004745.02
Campbell, Natalie, L,115122319.990.000.000.002319.99
Russell, Megan,16220562.960.000.000.00562.96
Hughes, Julia,250612443.350.002443.350.000.00
Smith, Justin, P,1982721.980.000.000.0021.98
Coleman, Vanessa,215892589.090.000.002049.10539.99
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Wright, Katelyn, A,14502122.260.000.0014.98107.28
James, Juan,232674862.090.003578.271283.820.00
Powell, Ian,2608564.470.000.000.0064.47
Price, Mariah, C,2074549.480.000.000.0049.48
Kumar, Zachary,254334.990.000.000.004.99
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Collins, Amanda,2078339.980.000.000.0039.98
Watson, Cole, A,217684118.263578.270.000.00539.99
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Morris, Haley, A,2354848.970.000.000.0048.97
Barnes, Jeremy,2144654.980.000.000.0054.98
Lopez, Isaiah,18968151.430.000.000.00151.43
Diaz, Hunter, S,27242782.990.000.00782.990.00
Johnson, Anthony, D,270224.990.000.000.004.99
Torres, Dalton,235037.280.000.007.280.00
Rivera, Allison, M,13751224.910.000.000.00224.91
Alvarez, Melody,2507068.490.000.000.0068.49
Green, Kaylee, C,2618567.970.000.000.0067.97
Carter, Elijah,216182611.070.000.002611.070.00
Moore, Jennifer, A,2175964.470.000.000.0064.47
Lal, Kyle,17360122.180.000.000.00122.18
Thomas, Seth,14567161.280.000.0096.0765.21
Washington, Taylor,212664525.070.000.002049.102475.97
Russell, Gail, L,212634.990.000.000.004.99
Jai, Logan, H,12031769.490.000.000.00769.49
Howard, Isaiah,259813018.330.002443.350.00574.98
Lewis, Ryan, A,203124.990.000.000.004.99
Shan, Gabriel, T,2773169.990.000.000.0069.99
Ward, Juan, H,215952649.560.000.002049.10600.46
Alexander, Taylor,17482146.940.000.0076.9769.97
Perez, Jonathan, R,2345512.940.000.000.0012.94
Moreno, Renee, C,12936265.220.000.000.00265.22
Clark, Zachary, J,2389358.980.000.000.0058.98
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Martin, Madison, C,2049271.970.000.0071.970.00
Washington, Caroline, D,231145996.320.003578.270.002418.05
Powell, Jack, J,1841156.960.000.000.0056.96
Edwards, Hailey,242584.990.000.000.004.99
Gill, Beth,199975814.980.003374.990.002439.99
Coleman, Ian,2127639.980.000.000.0039.98
Griffin, Jack, L,1768632.280.000.000.0032.28
Peterson, Julia, P,16497132.710.000.000.00132.71
Malhotra, Gerald, A,28773127.950.000.000.00127.95
She, Kenneth,16096212.010.000.0080.96131.05
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Hall, Natalie, A,230704.990.000.004.990.00
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Richardson, Lauren, C,14867839.480.000.000.00839.48
Parker, Katherine,13268289.700.000.0068.97220.73
Bryant, Jackson, J,2533239.980.000.000.0039.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Zhang, Heather,166543056.320.000.00751.342304.98
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Coleman, Stephanie,2226489.970.000.000.0089.97
Brown, Julia,18065155.470.000.000.00155.47
Thomas, Zachary, D,28045119.980.000.000.00119.98
White, James,253317.280.000.000.007.28
Johnson, Xavier, R,2325539.980.000.0039.980.00
Long, Elizabeth, F,127822400.950.000.000.002400.95
Peterson, Isabella,2808039.980.000.0039.980.00
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Cox, Arianna, D,1892789.250.000.000.0089.25
Harris, Destiny, M,137102341.460.000.000.002341.46
Wilson, Eduardo,15323804.470.000.000.00804.47
Cook, Steven, J,27053782.990.00782.990.000.00
Green, Sophia, E,249772181.560.002181.560.000.00
Thomas, Jessica,1684894.480.000.0094.480.00
Ramos, Kristi,151764703.030.000.000.004703.03
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Hill, Katherine, L,2670139.980.000.000.0039.98
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Smith, Tyler, J,2034156.970.000.000.0056.97
Rubio, Kellie,27653128.970.000.000.00128.97
Griffin, Xavier,228775962.340.003578.270.002384.07
Yuan, Brendan, S,247444.990.000.000.004.99
Hughes, Miranda,266784.990.000.000.004.99
Tang, Carl,2123832.270.000.000.0032.27
Wilson, Christian,27085782.990.000.00782.990.00
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Davis, Emily,27267782.990.000.00782.990.00
Brooks, Victoria, H,16479158.510.000.000.00158.51
Chavez, Kara, P,13285214.350.000.0012.94201.41
Ortega, Sheila, M,2763239.980.000.000.0039.98
Anderson, David, A,2209761.960.000.0061.960.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Martin, Joshua, A,276077.280.000.007.280.00
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Turner, James, E,16841126.960.000.0069.9956.97
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Powell, Miranda, J,153044843.000.000.000.004843.00
Coleman, Ashley,27297782.990.000.00782.990.00
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Cooper, Paige,14119148.940.000.000.00148.94
Sanders, Allison, B,18852268.250.000.000.00268.25
Watson, Erin, B,227724.990.000.004.990.00
Miller, Victoria,15816188.020.000.0081.46106.56
Hall, Kaylee, E,1975137.270.000.000.0037.27
Stewart, Andrea, M,27252782.990.000.00782.990.00
Jones, Samantha,1831721.980.000.000.0021.98
Brown, Benjamin, D,151874725.320.000.000.004725.32
Watson, Victoria,16125588.960.000.000.00588.96
Zukowski, Jake,220584118.263578.270.000.00539.99
Carter, Jesse, E,22141166.280.000.000.00166.28
Kumar, Cameron, S,185711120.490.000.001120.490.00
Allen, Jack, M,291372419.060.000.002419.060.00
Cooper, Alexandra,19541131.240.000.000.00131.24
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Anand, Brendan, L,1984721.980.000.000.0021.98
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Murphy, Juan, T,246463578.270.003578.270.000.00
Coleman, Jose, S,253494.990.000.000.004.99
Green, Gabriella, C,2803569.990.000.000.0069.99
Henderson, Hailey, C,171481775.470.000.000.001775.47
Phillips, Haley, B,2807939.980.000.000.0039.98
Anderson, Daniel,20694146.970.000.00146.970.00
Roberts, Jordan, M,1680039.250.000.000.0039.25
Baker, Ian, V,262002756.540.000.002181.56574.98
Morris, Seth,189592341.460.000.000.002341.46
Kumar, Austin,204834400.060.000.002049.102350.96
Campbell, Lucas,2932953.990.000.000.0053.99
Morris, Richard,2007039.980.000.000.0039.98
Nath, Carl, H,29001624.970.000.000.00624.97
Griffin, Melissa, L,287807.950.000.000.007.95
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Townsend, Bryan,14077180.730.000.000.00180.73
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Harris, Seth, M,161402528.330.000.002528.330.00
Hill, Sydney,264821000.440.000.001000.440.00
Allen, Sean, L,12097159.220.000.000.00159.22
Moore, Taylor, A,199874564.450.003374.990.001189.46
Nelson, Luis,234884.990.000.000.004.99
Bailey, Maria, C,1915034.980.000.000.0034.98
Flores, Julia, E,172631700.990.000.000.001700.99
Sanchez, Allison,1666741.720.000.000.0041.72
Prasad, Donald,15413318.920.000.00123.98194.94
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Harris, Edward,27062782.990.000.00782.990.00
Henderson, Justin, P,235917.280.000.000.007.28
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Harris, Noah,292562393.060.000.002393.060.00
Davis, Jonathan,2925913.980.000.000.0013.98
Barnes, Emily, G,15996564.990.000.000.00564.99
Campbell, Hunter,17422174.920.000.000.00174.92
Long, Rachel,2828339.980.000.000.0039.98
Peterson, Morgan, J,168341750.980.000.000.001750.98
Diaz, Luis, D,11203801.770.000.00183.97617.80
Perry, James,192051249.840.000.000.001249.84
Campbell, Gabriella,188411145.480.000.000.001145.48
Patterson, Nicole,1972937.270.000.000.0037.27
Dominguez, Meghan,14370122.560.000.000.00122.56
Gray, Mariah,222787.280.000.007.280.00
Jai, Hunter, M,28272111.950.000.000.00111.95
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Carter, Jason,11724210.090.000.00113.8696.23
Wilson, Nathan, L,13936218.930.000.000.00218.93
Liu, Arturo,13222150.410.000.0013.98136.43
Taylor, Lucas, V,115232376.960.000.002376.960.00
Lewis, Isabella,2624267.930.000.000.0067.93
Clark, Emily, R,120862294.990.000.000.002294.99
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Moore, Logan,2634889.970.000.0089.970.00
Wilson, Daniel, K,142814746.300.000.000.004746.30
Edwards, Hunter,2422067.930.000.000.0067.93
Murphy, Chase, J,2472958.980.000.000.0058.98
Ward, Natalie, J,132412325.960.000.000.002325.96

Generated 2025-11-03 13:02:13.759 UTC