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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Taylor, Marcus, A,18944146.940.000.000.00146.94
King, Sara,2235439.980.000.000.0039.98
Miller, Jill,129142329.980.000.000.002329.98
Ross, David, M,171431763.970.000.000.001763.97
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Bryant, Dakota, L,176132401.950.000.000.002401.95
Russell, Richard,2763322.260.000.000.0022.26
Ortega, Sheila, M,2763239.980.000.000.0039.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Williams, Sydney, J,15334848.470.000.000.00848.47
Hayes, Jason,261764.990.000.000.004.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Nath, Yolanda, A,2462513.980.000.000.0013.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
White, Judith, R,148851155.480.000.000.001155.48
Gray, Marcus, T,183892401.450.000.000.002401.45
Thompson, Lucas, O,212774.990.000.000.004.99
Johnson, Ian, E,2173283.470.000.000.0083.47
White, Emma, N,16090604.960.000.000.00604.96
Adams, Katherine, M,235184.990.000.000.004.99
Campbell, Natalie, L,115122319.990.000.000.002319.99
Torres, Abigail,253674.990.000.000.004.99
Davis, Justin,2807412.940.000.000.0012.94
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Bailey, Richard, N,220504160.533578.270.000.00582.26
Martin, Lucas, L,221144183.233578.270.000.00604.96
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Murphy, Emma,198445807.930.003374.990.002432.94
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Perry, Melissa,221284142.230.003578.270.00563.96
Miller, Benjamin, G,26643699.100.00699.100.000.00
She, Martha, E,222515971.330.003578.270.002393.06
Williams, Ryan, R,222475978.610.003578.270.002400.34
Turner, Courtney, A,229753578.270.003578.270.000.00
Washington, Lauren, R,229985329.250.003578.271750.980.00
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Harris, Megan,232814828.110.003578.271249.840.00
Thompson, Abigail,243324816.090.003578.270.001237.82
Chander, Wayne, S,243444329.610.003578.27751.340.00
Turner, Wyatt,200345769.960.003399.990.002369.97
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Baker, Sean, T,247782858.490.002181.56676.930.00
Long, Caleb, P,250462181.560.002181.560.000.00
Green, Sophia, E,249772181.560.002181.560.000.00
Thomas, Charles,250942443.350.002443.350.000.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Richardson, Victoria, C,248172181.560.002181.560.000.00
Martin, Morgan,248322181.560.002181.560.000.00
Huang, Kristen,251002443.350.002443.350.000.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Carter, Luis, E,258832443.350.002443.350.000.00
Flores, Jordyn,252882721.550.002181.560.00539.99
Parker, Natalie, A,251043018.330.002443.350.00574.98
Coleman, Lucas, A,27060782.990.000.00782.990.00
Harris, Edward,27062782.990.000.00782.990.00
Perry, Olivia,203754438.380.000.002071.422366.96
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Fernandez, Ruth,205463246.550.000.002049.101197.45
Thomas, Isabella, M,27265782.990.000.00782.990.00
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Diaz, Angela, K,27259782.990.000.00782.990.00
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Mitchell, Savannah,261153052.800.000.002443.35609.45
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Foster, Deb,215012661.400.000.002661.400.00
Long, Morgan, H,213522625.390.000.002071.42553.97
Perez, Angel, S,213362628.350.000.002071.42556.93
Collins, Connor, J,27270782.990.000.00782.990.00
Watson, Michelle, H,262352181.560.000.002181.560.00
Johnson, Andrew, F,262942443.350.000.002443.350.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Davis, Richard, R,15549574.980.000.00574.980.00
Allen, Luke,113162349.980.000.002349.980.00
King, Aaron, L,117394758.030.000.002359.982398.05
Alexander, Ryan, J,14078839.480.000.00839.480.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Martinez, Dominique,287888.990.000.008.990.00
Campbell, Hailey,15507267.840.000.00228.9638.88
Stewart, Jessica,16097103.550.000.0046.5856.97
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Nelson, Jordan, H,201304.990.000.004.990.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Wright, Jennifer,2650559.980.000.0059.980.00
Smith, Alexandra,2829261.960.000.000.0061.96
Johnson, Anthony, D,270224.990.000.000.004.99
Rivera, Ariana,261734.990.000.000.004.99
Coleman, Joan, W,2669964.470.000.000.0064.47
Henderson, Luke,19200109.240.000.000.00109.24
Hughes, Anna,197052341.970.000.000.002341.97
Zhang, Nathan, L,2910478.980.000.000.0078.98
Simmons, Brittany,2923139.980.000.000.0039.98
Jai, Logan, H,12031769.490.000.000.00769.49
Alexander, Lauren,189502351.960.000.000.002351.96
Martinez, Kristina, S,2134529.930.000.000.0029.93
Scott, Sean, F,2475539.980.000.000.0039.98
Li, Kevin, S,2518813.980.000.000.0013.98
Long, Chloe,167841735.980.000.000.001735.98
Martin, Nicholas,233627.280.000.000.007.28
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Flores, Nathan, C,2463713.980.000.000.0013.98
Flores, Brittany,169062359.980.000.000.002359.98
Smith, Noah,13175166.920.000.000.00166.92
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Hall, Lauren, A,19648100.840.000.000.00100.84
Cox, Devin, C,134184768.050.000.000.004768.05
Davis, Ethan,136604750.010.000.000.004750.01
Mitchell, Caleb, K,268064.990.000.000.004.99
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Griffin, Jack, L,1768632.280.000.000.0032.28
Bailey, Lauren,15864103.550.000.000.00103.55
Barnes, Jeremy,2144654.980.000.000.0054.98
Flores, Eduardo, S,2896962.980.000.000.0062.98
Brooks, Ian, W,2829064.470.000.000.0064.47
Jai, Edwin,169211754.980.000.000.001754.98
Phillips, Devin,18759112.060.000.000.00112.06
Morgan, Marcus, W,289682.290.000.000.002.29
Barnes, Elizabeth, J,249397.280.000.000.007.28
Ward, Emma, W,2179659.980.000.000.0059.98
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Edwards, Angel, J,2912469.990.000.000.0069.99
Washington, Victoria,235577.280.000.000.007.28
Bell, Christina,2609939.980.000.000.0039.98
Rubio, Kellie,27653128.970.000.000.00128.97
Lal, Caleb, R,1586874.460.000.000.0074.46
Torres, Victoria,17551160.920.000.000.00160.92
Harris, Samantha, A,244874.990.000.000.004.99
Richardson, Evan, J,15488165.300.000.000.00165.30
Hill, Timothy,14871848.470.000.000.00848.47
Miller, Kayla, A,236734.990.000.000.004.99
Brown, Morgan,2919778.980.000.000.0078.98
Davis, Thomas,167641760.470.000.000.001760.47
Shan, Chad, M,2462112.940.000.000.0012.94
Green, Mackenzie, C,280737.280.000.000.007.28
Reed, Isaac, D,260747.280.000.000.007.28
Jones, Charles,22882101.450.000.000.00101.45
Thomas, Matthew, K,13239185.700.000.000.00185.70
Green, Eric,2738069.990.000.000.0069.99
Davis, Austin, E,133664749.040.000.000.004749.04
Mehta, Carmen, C,2743694.480.000.000.0094.48
Young, Jenna, W,163652490.180.000.000.002490.18
Alexander, Caroline,176541759.970.000.000.001759.97
Kennedy, Bridget,2202639.980.000.000.0039.98
Allen, Allison, A,1975737.270.000.000.0037.27
Phillips, Luis, G,207347.280.000.000.007.28
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Ruiz, Philip,1807781.460.000.000.0081.46
Evans, Maria,22544127.280.000.00127.280.00
Moore, Andrew, A,13944150.130.000.0036.27113.86
Chavez, Kara, P,13285214.350.000.0012.94201.41
Russell, Rachel, C,2158124.270.000.0024.270.00
Torres, Taylor,16666205.440.000.00123.9881.46
Moore, Logan,2634889.970.000.0089.970.00
Turner, Samuel,2742069.990.000.0069.990.00
Chen, Luis, G,2125294.450.000.0094.450.00
Torres, Pedro, E,16958168.020.000.00153.0414.98
Xu, Louis,2010466.530.000.0066.530.00
Rubio, Javier, E,1972664.240.000.0064.240.00
Taylor, Lucas, V,115232376.960.000.002376.960.00
Robinson, Joseph,2814194.480.000.0094.480.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Ward, Devin, J,15378170.910.000.0076.9593.96
Collins, Jose,2474839.980.000.0039.980.00
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Perry, Benjamin,291652407.040.000.002407.040.00
James, Maria,1624391.970.000.0069.9921.98
Bryant, Rachel,220197.280.000.007.280.00
Hill, Haley, J,161033142.320.000.00792.342349.98
Gonzales, Nathan, M,12107222.230.000.0032.27189.96
Adams, Kyle, E,1881269.990.000.0069.990.00
Anderson, Daniel,20694146.970.000.00146.970.00
Zhang, Heather,166543056.320.000.00751.342304.98
Hayes, Logan, J,19026113.240.000.0037.2775.97
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Alexander, Taylor,17482146.940.000.0076.9769.97
Williams, Destiny, S,15881564.990.000.00564.990.00
Peterson, Mason, A,185701174.480.000.001174.480.00
Mitchell, Bailey, B,267067.280.000.007.280.00
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Parker, Morgan, S,1677236.960.000.0014.9821.98
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Anderson, Tyler, E,131481137.430.000.001137.430.00
Russell, Jacqueline,18391100.960.000.0078.9821.98
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Kumar, Cameron, S,185711120.490.000.001120.490.00
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Powell, Sydney, M,14886539.990.000.000.00539.99
Lewis, Christopher,1875586.960.000.000.0086.96
Parker, Blake,15008170.530.000.000.00170.53
Hughes, Antonio, P,15913712.270.000.000.00712.27
Hill, Katherine, L,2670139.980.000.000.0039.98
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Long, Natalie,14363192.340.000.000.00192.34
Sanchez, Martin, E,216317.280.000.000.007.28
Sanchez, Alex, K,131014736.030.000.000.004736.03
Johnson, James,234984.990.000.000.004.99
Washington, Christian, R,2668639.980.000.000.0039.98
Ramos, Kristi,151764703.030.000.000.004703.03
Rogers, Faith,2468259.980.000.000.0059.98
Brooks, Lucas, S,16089342.030.000.000.00342.03
Harris, Emily, P,1986298.480.000.000.0098.48
Wilson, Tyler, L,15879196.930.000.000.00196.93
Patterson, Nicole,1972937.270.000.000.0037.27
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Young, Julia, J,274144.990.000.000.004.99
Bryant, Samantha,18345115.470.000.000.00115.47
Lu, Alejandro,2562039.980.000.000.0039.98
Johnson, Edward, H,23279124.990.000.000.00124.99
Cooper, Paige,14119148.940.000.000.00148.94
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Peterson, Alex, M,13423132.900.000.000.00132.90
Thompson, Madison, L,187882351.960.000.000.002351.96
Hall, Eduardo,16847189.940.000.000.00189.94
Alexander, Sarah,1941129.990.000.000.0029.99
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Griffin, Marcus,2075634.560.000.000.0034.56
Bradley, Melanie, G,133434720.270.000.000.004720.27
Blue, Melanie, L,178611749.960.000.000.001749.96
Kelly, Haley,15511128.560.000.000.00128.56
Rivera, Amanda,11131115.920.000.000.00115.92
Harris, Destiny, M,137102341.460.000.000.002341.46
Alexander, Logan, E,191161183.470.000.000.001183.47
Torres, Mariah,16380195.950.000.000.00195.95
Russell, Chloe, M,12763589.960.000.000.00589.96
Bailey, Mariah, L,2724354.980.000.000.0054.98
Cooper, Angela,195261179.470.000.000.001179.47
Ortega, Javier, P,127852294.990.000.000.002294.99
Thomas, Edward, E,19147133.710.000.000.00133.71
Gutierrez, Jerome,127832420.460.000.000.002420.46
McDonald, Aaron, J,27734119.980.000.000.00119.98
Phillips, Miguel,2049812.940.000.000.0012.94
Sánchez, Angela, C,176551750.980.000.000.001750.98
Hughes, Miranda,266784.990.000.000.004.99
Hayes, Dalton, C,188822322.280.000.000.002322.28
Smith, Justin, P,1982721.980.000.000.0021.98
Adams, Julia, N,2607359.980.000.000.0059.98
Jackson, Hannah, G,131432404.970.000.000.002404.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Sanders, Isaiah,2587339.980.000.000.0039.98
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Torres, Mackenzie,28153570.470.000.000.00570.47
Rivera, Sara,187852350.960.000.000.002350.96

Generated 2025-11-06 20:04:12.219 UTC