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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Torres, Victoria,17551160.920.000.000.00160.92
Washington, Hailey, S,2588559.980.000.000.0059.98
Reed, Kaylee, R,17371151.920.000.000.00151.92
Hughes, Riley,2928449.990.000.000.0049.99
Prasad, Donald,15413318.920.000.00123.98194.94
Gonzalez, Morgan,130651700.990.000.000.001700.99
Howard, Alyssa, A,11513863.950.000.000.00863.95
Coleman, Luke, A,11723152.550.000.0039.99112.56
Henderson, Abigail,2044139.980.000.000.0039.98
Reed, Isaac, D,260747.280.000.000.007.28
Jones, Charles,22882101.450.000.000.00101.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Walker, Jacob, N,29027574.980.000.000.00574.98
Jones, Michael, A,2210771.970.000.000.0071.97
Cooper, Brian, L,13760128.840.000.000.00128.84
Gray, Seth, M,2008785.480.000.000.0085.48
Gray, Cody, C,144594775.010.000.000.004775.01
Blanco, Armando, F,139182397.950.000.000.002397.95
Johnson, Madison, L,15530846.460.000.000.00846.46
Kelly, Bailey, R,28284563.770.000.000.00563.77
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Simmons, Anna, K,124512367.920.000.000.002367.92
Flores, Caleb, S,12165280.640.000.00159.47121.17
Thomas, Jessica,1684894.480.000.0094.480.00
Stewart, Makayla,16649115.940.000.000.00115.94
Collins, Eduardo,139872329.990.000.000.002329.99
Coleman, Miguel, D,2740069.990.000.0069.990.00
Russell, Ian, T,2474613.980.000.0013.980.00
Hall, Natalie, A,230704.990.000.004.990.00
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Hall, Jose, J,17601225.420.000.000.00225.42
Foster, Caleb,27112114.460.000.000.00114.46
Walker, Richard, T,19640224.550.000.000.00224.55
Brooks, Allison,146054750.010.000.000.004750.01
Rubio, Ruben, D,1887186.960.000.0056.9729.99
Harris, Jacob, G,2367939.980.000.0039.980.00
Kapoor, Preston,2143156.970.000.000.0056.97
Williams, Sydney, J,15334848.470.000.000.00848.47
Roberts, Hunter,282607.280.000.000.007.28
Carter, Jonathan,14578848.470.000.000.00848.47
Adams, Gabriel, S,195271219.450.000.000.001219.45
Price, Rachel, D,2532889.970.000.000.0089.97
Long, Elizabeth, F,127822400.950.000.000.002400.95
Ramos, Derrick,18449100.940.000.000.00100.94
Murphy, Brianna, K,2834269.990.000.000.0069.99
Anderson, Madison, G,2835978.980.000.000.0078.98
Nelson, Katherine,2802178.980.000.000.0078.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Lewis, Morgan,17410168.740.000.000.00168.74
Cannata, Gabrielle, C,217254.990.000.000.004.99
Murphy, Maria,160113657.260.000.000.003657.26
White, Greg, C,174032322.280.000.000.002322.28
Diaz, Ryan, J,16910141.960.000.000.00141.96
Adams, Katherine, M,235184.990.000.000.004.99
Blue, Paige,2170313.980.000.000.0013.98
Roberts, Robert, R,1898656.970.000.000.0056.97
Zhao, Clarence, R,1982671.970.000.000.0071.97
Lopez, Bailey, R,185571179.470.000.000.001179.47
Ward, Natalie, J,132412325.960.000.000.002325.96
Nath, Kenneth, W,170372334.970.000.000.002334.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
Rubio, Javier, E,1972664.240.000.000.0064.24
Martinez, Joseph, E,2921459.980.000.000.0059.98
Wu, Randy, J,116472365.940.000.000.002365.94
Gray, Sara,292472447.050.000.000.002447.05
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Flores, Hannah,1952540.230.000.000.0040.23
Edwards, Elijah, D,281577.280.000.000.007.28
Martin, Noah, A,1765775.970.000.000.0075.97
Scott, Eric,282484.990.000.000.004.99
Rogers, Andrea, L,14328308.660.000.000.00308.66
Walker, Ian,16771104.550.000.000.00104.55
Sanchez, Stephanie,1786756.970.000.000.0056.97
Wilson, Emily,174002331.950.000.000.002331.95
Jackson, Victoria,270194.990.000.000.004.99
Rodriguez, Julia, A,264884.990.000.000.004.99
Diaz, Brandon,236764.990.000.000.004.99
Sanders, Zoe, L,248254.990.000.000.004.99
Bryant, Rachel,220197.280.000.000.007.28
Lee, Kayla, M,2078115.230.000.000.0015.23
Sanders, Mason, G,2345939.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Mohamed, Samantha, A,292772419.060.000.000.002419.06
Gonzales, Cameron, L,2900569.990.000.000.0069.99
Hughes, Caroline, C,2830278.980.000.000.0078.98
Edwards, Hunter,2422067.930.000.000.0067.93
Bailey, Maria, C,1915034.980.000.000.0034.98
Baker, Gabriella,174041709.980.000.000.001709.98
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Hernandez, Sierra,27393123.980.000.000.00123.98
Ortega, Sheila, M,2763239.980.000.000.0039.98
Wright, Katelyn, A,14502122.260.000.000.00122.26
Gill, Robyn, J,127651750.980.000.000.001750.98
Anderson, Tyler, E,131481137.430.000.000.001137.43
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Simmons, David, E,120172339.970.000.000.002339.97
Torres, Dalton,235037.280.000.000.007.28
White, Judith, R,148851155.480.000.000.001155.48
Smith, Nathan,217647.280.000.000.007.28
Cox, Sara, P,2775869.990.000.000.0069.99
Johnson, Jonathan,220597.280.000.000.007.28
Rogers, Paige, H,17125539.990.000.000.00539.99
Yuan, Brendan, S,247444.990.000.000.004.99
Li, Eugene, A,15283865.950.000.000.00865.95
Coleman, Ian,2127639.980.000.000.0039.98
Henderson, Austin,2764354.980.000.000.0054.98
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Morgan, Isabella, L,28602144.470.000.000.00144.47
Coleman, Lucas, A,27060782.990.000.00782.990.00
Harris, Edward,27062782.990.000.00782.990.00
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Flores, Stephanie,259922721.550.000.002181.56539.99
Li, Kevin, S,2518813.980.000.000.0013.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Long, Chloe,167841735.980.000.000.001735.98
Roberts, Amber, W,215822638.060.000.002049.10588.96
Lee, Ethan, J,223597.280.000.000.007.28
Hayes, Carson, A,124472331.950.000.000.002331.95
Diaz, Thomas, O,16020595.960.000.000.00595.96
Reed, Mariah,263731565.910.000.001000.44565.47
Taylor, Zachary, M,27082782.990.000.00782.990.00
Williams, Zachary, B,27099782.990.000.00782.990.00
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Cooper, Christina, C,265121000.440.000.001000.440.00
Perry, Marcus, L,206563245.900.000.002071.421174.48
Diaz, Angela, K,27259782.990.000.00782.990.00
Nelson, Jennifer,171471700.990.000.000.001700.99
Jai, Connor, D,27253782.990.000.00782.990.00
Thomas, Logan, A,14091251.200.000.0053.99197.21
Butler, Ana,260403018.330.000.002443.35574.98
Phillips, Kaylee,211384371.380.000.002049.102322.28
Yang, Aaron, C,2519654.980.000.000.0054.98
Washington, Taylor,212664525.070.000.002049.102475.97
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Carter, Bailey,213322616.860.000.002049.10567.76
Alexander, Lauren,189502351.960.000.000.002351.96
Simmons, Haley, T,262022749.320.000.002181.56567.76
Henderson, Logan, C,2236656.970.000.000.0056.97
White, Edward, J,15847205.460.000.000.00205.46
Sanders, Hailey,19647282.040.000.000.00282.04
Coleman, Ashley,27297782.990.000.00782.990.00
Mitchell, Maria, D,27404782.990.000.00782.990.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Peterson, Christina,2897694.480.000.000.0094.48
Carter, Katherine,11861286.300.000.000.00286.30
Harris, Matthew,14330806.760.000.000.00806.76
Patterson, Jeremy,130272319.260.000.000.002319.26
Parker, Caleb, A,2631813.980.000.000.0013.98
Diaz, Richard, A,2668264.470.000.000.0064.47
Hayes, Hannah, J,2165656.970.000.000.0056.97
White, Tyler,14291258.440.000.0049.97208.47
Thomas, David,168363193.790.000.000.003193.79
Edwards, Madeline,2077146.470.000.000.0046.47
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Perry, Brandon,22095141.980.000.000.00141.98
Evans, Gabriel,2348789.970.000.000.0089.97
Moore, Seth,138512331.950.000.000.002331.95
Hall, Kaylee, E,1975137.270.000.000.0037.27
Moore, Anthony, M,2473039.980.000.000.0039.98
Russell, Elijah, M,118354772.300.000.002319.262453.04
Allen, Sean, L,12097159.220.000.000.00159.22
Butler, Dalton, A,133454759.510.000.000.004759.51
She, Shawn, J,16902141.980.000.000.00141.98
Sanchez, Jared, J,2585064.470.000.000.0064.47
Peterson, Morgan, J,168341750.980.000.000.001750.98
Davis, Austin, E,133664749.040.000.000.004749.04
Young, Jenna, W,163652490.180.000.000.002490.18
Alexander, Caroline,176541759.970.000.000.001759.97
Peterson, Julia, P,16497132.710.000.000.00132.71
Griffin, Miguel,2146476.970.000.000.0076.97
Brooks, Mariah,216202620.400.000.002071.42548.98
Moore, Fernando,265821000.440.000.001000.440.00
Thompson, Madison, L,187882351.960.000.000.002351.96
Alexander, Sarah,1941129.990.000.000.0029.99
Collins, Amanda,2078339.980.000.000.0039.98
Blue, Melanie, L,178611749.960.000.000.001749.96
Collins, Isaac,260777.280.000.000.007.28
Coleman, Samuel, N,17450123.980.000.000.00123.98
Russell, Caleb,23552103.480.000.000.00103.48
Reed, Melanie, A,28160574.980.000.000.00574.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Allen, Luke,113162349.980.000.002349.980.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Phillips, Haley, B,2807939.980.000.000.0039.98
Phillips, Luis, G,207347.280.000.000.007.28
Thompson, Brianna, X,1864269.970.000.000.0069.97
Ruiz, Philip,1807781.460.000.000.0081.46
Moore, Ian, L,2463939.980.000.000.0039.98
Barnes, Ian, M,16106133.540.000.000.00133.54
Stewart, Gabriella,2803469.990.000.000.0069.99
Flores, Luke, L,247337.280.000.000.007.28
Taylor, Taylor,159054899.020.000.000.004899.02
Nath, Carl, H,29001624.970.000.000.00624.97
Wilson, Madison, H,1982821.980.000.000.0021.98
Scott, Allison,14497804.480.000.000.00804.48
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Rodriguez, Natalie,2077330.970.000.000.0030.97
Foster, Aaron,155664912.470.000.000.004912.47
Washington, Aaron, L,246494.990.000.000.004.99
Thomas, Ian,191181120.490.000.000.001120.49
Moore, Jessica, J,2008576.760.000.000.0076.76
Moore, Chloe, L,2626913.980.000.000.0013.98
Harris, Samantha, A,244874.990.000.000.004.99
Sara, Ivan, L,2509067.930.000.000.0067.93
Shan, Gabriel, T,2773169.990.000.000.0069.99
Roberts, Carlos,2319639.980.000.000.0039.98
Russell, Gail, L,212634.990.000.000.004.99
Flores, Gabriel,271117.280.000.000.007.28
Sanders, Angel,16219553.970.000.000.00553.97
Hughes, Luis,130841798.960.000.000.001798.96
Evans, Elijah, S,2588439.980.000.000.0039.98
Carter, Jesse, E,22141166.280.000.000.00166.28
Henderson, Hailey, C,171481775.470.000.000.001775.47
Brown, Christian,227554.990.000.000.004.99
Reed, Michelle,2804669.990.000.000.0069.99
Flores, Julian,158464943.320.000.000.004943.32
Hall, Taylor, J,169951735.980.000.000.001735.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Hayes, Gavin, A,194001179.470.000.000.001179.47
Alexander, Gavin, K,2932249.990.000.000.0049.99
Jones, Alexander, I,2002180.960.000.000.0080.96
Hughes, Austin, P,183681754.980.000.000.001754.98
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Long, Rachel,2828339.980.000.000.0039.98
Stewart, Melissa,2517336.960.000.000.0036.96
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Olivia,188591155.480.000.000.001155.48
Edwards, Amber, B,2051776.970.000.000.0076.97
Nelson, Jordan, H,201304.990.000.004.990.00
Li, Brandon,2933973.960.000.000.0073.96
Martin, Christian, V,19709197.250.000.000.00197.25
Barnes, Haley, J,2133939.980.000.0039.980.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
James, Morgan, E,2324539.980.000.000.0039.98
Alexander, Angelica,2271471.950.000.000.0071.95
Sanchez, Shelby,16021539.990.000.000.00539.99
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Washington, Hannah, A,291307.280.000.007.280.00
Kumar, Elijah,15197156.920.000.000.00156.92
Russell, Katherine,2877169.990.000.000.0069.99
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Miller, Destiny,251577.280.000.000.007.28
Miller, Jill,129142329.980.000.000.002329.98
Turner, Mary,220154.990.000.000.004.99
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Campbell, Natalie, L,115122319.990.000.000.002319.99
Hernandez, Jamie,27283119.980.000.000.00119.98
Ramirez, Brian, M,116182369.960.000.000.002369.96
Phillips, Isaiah,28631144.470.000.000.00144.47
Evans, Alexandra,2432268.490.000.000.0068.49
Ramirez, Garrett, M,173881763.970.000.000.001763.97
_SUM1806517.5025543.71496024.56253394.871031554.36

Generated 2025-12-21 02:10:11.997 UTC