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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Turner, Timothy, C,14641119.860.000.000.00119.86
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Bailey, Jessica, L,12945218.440.000.000.00218.44
Hughes, Justin, M,181222439.990.000.000.002439.99
Cooper, Ariana,17348205.420.000.000.00205.42
Jenkins, Megan, R,12074261.380.000.000.00261.38
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Turner, Blake,12136131.740.000.000.00131.74
Jones, Joshua,184012294.990.000.000.002294.99
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Turner, Amanda, L,203183241.900.002071.420.001170.48
Russell, Megan,16220562.960.000.000.00562.96
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Washington, Robert, J,14906143.950.000.000.00143.95
Washington, Elijah, L,250164.990.000.000.004.99
Perry, Melissa,221284142.230.003578.270.00563.96
Collins, Nathan, F,197041143.460.000.000.001143.46
Kumar, Zachary,254334.990.000.000.004.99
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Simmons, Jose,2464739.980.000.000.0039.98
Hall, Charles,234764.990.000.000.004.99
Brown, Samantha, G,2514739.980.000.000.0039.98
Brooks, Makayla,222526047.320.003578.270.002469.05
King, Caleb, J,2898678.980.000.000.0078.98
Flores, Arianna,217274132.243578.270.000.00553.97
Price, Miranda,26629699.10699.100.000.000.00
Martin, Lucas, L,221144183.233578.270.000.00604.96
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Turner, Sean,227324133.240.003578.270.00554.97
Brown, Isabella, L,266921266.860.00699.100.00567.76
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Bell, Gabrielle,223735976.320.003578.270.002398.05
Perry, Oscar,227856029.570.003578.272451.300.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Alexander, Thomas,207607.280.000.000.007.28
Watson, Janet, S,2320859.980.000.000.0059.98
Thompson, Ethan,199894495.480.003374.990.001120.49
Clark, William,2902169.990.000.000.0069.99
Jackson, Hannah, G,131432404.970.000.000.002404.97
Hughes, Eduardo,15564188.520.000.000.00188.52
Long, Morgan, H,213522625.390.000.002071.42553.97
Moore, Matthew, W,13267109.950.000.000.00109.95
Suarez, Juan, R,167631700.990.000.000.001700.99
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Thompson, Xavier, R,15761192.410.000.000.00192.41
Patterson, Natalie,16123629.970.000.000.00629.97
Hughes, Anna,197052341.970.000.000.002341.97
Yang, Aaron, C,2519654.980.000.000.0054.98
Wilson, Grace,17539205.920.000.000.00205.92
Ward, Jade, D,14661195.020.000.000.00195.02
Nelson, Jennifer,171471700.990.000.000.001700.99
Walker, Jasmine,134604693.040.000.000.004693.04
White, Edward, J,15847205.460.000.000.00205.46
Hughes, Destiny, P,28027119.980.000.000.00119.98
Martin, Nicholas,233627.280.000.000.007.28
Anderson, Isabella,137432349.980.000.000.002349.98
Phillips, Kyle,12158202.200.000.000.00202.20
Edwards, Madeline,2077146.470.000.000.0046.47
Rodriguez, Taylor,1607166.960.000.000.0066.96
Flores, Nathan, C,2463713.980.000.000.0013.98
Hall, Fernando,2210090.950.000.000.0090.95
Martinez, Kristina, S,2134529.930.000.000.0029.93
Reed, Mariah,263731565.910.000.001000.44565.47
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Foster, Isabel, M,2174571.950.000.000.0071.95
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Miller, Eduardo,14561158.840.000.0049.97108.87
Kelly, Haley,15511128.560.000.000.00128.56
Yuan, Carly,19839194.960.000.000.00194.96
Gonzales, Luis,15856116.250.000.0037.2778.98
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Flores, Brittany,169062359.980.000.000.002359.98
Gonzales, Kayla,214947.280.000.000.007.28
Cooper, Andrea,2932378.980.000.000.0078.98
Richardson, Brian,2860878.980.000.000.0078.98
Brown, Morgan,2919778.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Evans, Jesse,2191639.980.000.000.0039.98
Mitchell, Caleb, K,268064.990.000.000.004.99
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Alexander, Jason,2932849.990.000.000.0049.99
Thomas, David,168363193.790.000.000.003193.79
Garcia, Christian, J,164913106.330.000.00751.342354.99
Washington, Caroline, D,231145996.320.003578.270.002418.05
Powell, Elijah, E,231135997.330.003578.270.002419.06
Washington, Lauren, R,229985329.250.003578.271750.980.00
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Torres, Haley, W,232834828.110.003578.270.001249.84
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Foster, Olivia,238063578.270.003578.270.000.00
Long, Kaitlyn,233964891.610.003578.270.001313.34
Williams, Ethan,243094793.120.003578.270.001214.85
Allen, Aaron, A,200753399.990.003399.990.000.00
Fernandez, Ruth,205463246.550.000.002049.101197.45
Perry, Marcus, L,206563245.900.000.002071.421174.48
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Alexander, Caroline,176541759.970.000.000.001759.97
Moore, Wyatt, F,189712351.960.000.000.002351.96
Evans, Luke,2917615.230.000.000.0015.23
Price, Nicole, N,15815141.830.000.000.00141.83
Reed, Marcus,14582111.790.000.0014.9896.81
Morris, Mason, J,22349124.990.000.000.00124.99
Barnes, Elizabeth, J,249397.280.000.000.007.28
White, Emily, M,159174679.060.000.000.004679.06
Alexander, Edward, E,18524195.950.000.000.00195.95
Barnes, Dalton, C,178581700.990.000.000.001700.99
Peterson, Xavier, R,2645639.980.000.000.0039.98
Hall, Lauren, A,19648100.840.000.000.00100.84
Moore, Chloe, L,2626913.980.000.000.0013.98
Brooks, Victoria, H,16479158.510.000.000.00158.51
Ward, Cole,214907.280.000.000.007.28
Collins, Isaac,260777.280.000.000.007.28
Gonzales, Emily, P,21777180.980.000.000.00180.98
Sánchez, Angela, C,176551750.980.000.000.001750.98
Coleman, Samuel, N,17450123.980.000.000.00123.98
James, Bryce,13466133.450.000.000.00133.45
Jones, Charles,22882101.450.000.000.00101.45
Nelson, Kevin,1476584.970.000.000.0084.97
Robinson, Sarah, A,2702859.980.000.000.0059.98
Lewis, Isabella,2624267.930.000.000.0067.93
Reed, Catherine, M,203807.280.000.000.007.28
Butler, Morgan, E,2050068.490.000.000.0068.49
Simmons, Dakota, T,14110819.460.000.000.00819.46
Sharma, Jackson,16876151.840.000.000.00151.84
Robinson, Ian, D,138522294.990.000.000.002294.99
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Diaz, Trevor, B,2051954.960.000.000.0054.96
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Butler, Cassidy, L,21792114.460.000.000.00114.46
White, Greg, C,174032322.280.000.000.002322.28
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Baker, Eduardo,180921789.450.000.000.001789.45
Barnes, Ian, M,16106133.540.000.000.00133.54
Ma, Tiffany,2157739.980.000.000.0039.98
Foster, Abigail,1982346.470.000.000.0046.47
Watson, Victoria,16125588.960.000.000.00588.96
Blue, Paige,2170313.980.000.000.0013.98
Prasad, Donald,15413318.920.000.00123.98194.94
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Price, Riley, R,139094764.020.000.000.004764.02
Ramirez, Garrett, M,173881763.970.000.000.001763.97
She, Alisha, G,247574343.590.003578.270.00765.32
Garcia, Victoria, V,245013578.270.003578.270.000.00
Long, Caleb, P,250462181.560.002181.560.000.00
Garcia, Carmen, J,247812181.560.002181.560.000.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Ross, Haley, T,253612443.350.002443.350.000.00
Zhao, Karen, L,254082735.530.002181.560.00553.97
Price, Stephanie,258922443.350.002443.350.000.00
Flores, Jordyn,252882721.550.002181.560.00539.99
Coleman, Lucas, A,27060782.990.00782.990.000.00
Harris, Edward,27062782.990.00782.990.000.00
Hall, Wyatt,2382713.980.000.000.0013.98
Williams, Edward, D,14274121.560.000.000.00121.56
Bell, Danielle,140414765.020.000.000.004765.02
Roberts, Rebecca,2800094.480.000.000.0094.48
Lal, Jack, R,185251735.980.000.000.001735.98
Jones, Alexandra, B,2020245.950.000.000.0045.95
Chen, Jack, E,17579151.430.000.000.00151.43
Garcia, Kayla, L,2130881.460.000.000.0081.46
Roberts, Amanda,171752334.980.000.000.002334.98
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Sanchez, Stephanie,1786756.970.000.000.0056.97
Brooks, Evan,2340139.980.000.000.0039.98
Hughes, Isabella,2304851.460.000.000.0051.46
Hughes, Brittany,14387898.460.000.000.00898.46
Lee, Ethan, J,223597.280.000.000.007.28
Butler, Jonathan,261804.990.000.000.004.99
Adams, Connor,214232888.560.000.002049.10839.46
Wilson, Daniel, K,142814746.300.000.000.004746.30
Sanders, Zoe, L,248254.990.000.000.004.99
Luo, Jodi,2921368.490.000.000.0068.49
Anderson, Ryan, W,132712319.990.000.000.002319.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Ward, Destiny,16128539.990.000.000.00539.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Alexander, Julian,132172351.960.000.000.002351.96
Lee, Kayla, M,2078115.230.000.000.0015.23
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Lewis, Ryan, A,203124.990.000.000.004.99
Johnson, Madison, L,15530846.460.000.000.00846.46
Srini, Evelyn,16855150.950.000.000.00150.95
Gomez, Briana, A,2878443.980.000.000.0043.98
Griffin, James,28189567.760.000.000.00567.76
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Carter, Jose, H,12532235.720.000.000.00235.72
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Kumar, Austin,204834400.060.000.002049.102350.96
Miller, Katherine, B,27102782.990.000.00782.990.00
Thomas, Isabella, M,27265782.990.000.00782.990.00
Phillips, Jack, R,259952443.350.000.002443.350.00
White, Christopher, R,260492181.560.000.002181.560.00
Taylor, Victoria,260132443.350.000.002443.350.00
James, Timothy,213312670.890.000.002670.890.00
Stewart, Cody, A,212843223.580.000.002049.101174.48
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Carter, Bailey,213322616.860.000.002616.860.00
Coleman, Ashley,27297782.990.000.00782.990.00
Stewart, Makayla,16649115.940.000.000.00115.94
Campbell, Timothy,2584513.980.000.000.0013.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Hayes, Jason,261764.990.000.000.004.99
Chen, David,2720839.980.000.000.0039.98
Gonzalez, James, M,188421155.480.000.000.001155.48
Flores, Eduardo, S,2896962.980.000.000.0062.98
Moore, Jonathan,2047896.460.000.000.0096.46
Price, Mariah, C,2074549.480.000.000.0049.48
Clark, Emily, R,120862294.990.000.000.002294.99
Thomas, Megan,2907169.990.000.000.0069.99
Bell, Christina,2609939.980.000.000.0039.98
Watson, Marcus,2271585.480.000.000.0085.48
Ross, Seth, M,184332329.980.000.000.002329.98
Lewis, Rachel, J,14900839.480.000.000.00839.48
Moore, Anthony, M,2473039.980.000.000.0039.98
Taylor, Natalie, M,14338828.740.000.000.00828.74
Ross, Miranda,145984839.000.000.000.004839.00
Lee, Samantha, B,2737878.980.000.000.0078.98
Johnson, Ian, E,2173283.470.000.000.0083.47
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
Miller, Kayla, A,236734.990.000.000.004.99
Watson, Michelle, H,262352181.560.000.002181.560.00
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Johnson, Andrew, F,262942443.350.000.002443.350.00
Russell, Jessica,265721000.440.000.001000.440.00
Powell, David, W,266151000.440.000.001000.440.00
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Washington, Riley, L,185441155.480.000.001155.480.00
Sanchez, Jared, J,2585064.470.000.000.0064.47
Peterson, Morgan, J,168341750.980.000.000.001750.98
Prasad, Erick, E,28786127.950.000.000.00127.95
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Allen, Luke,113162349.980.000.002349.980.00
Alexander, Luke,290432447.050.000.002447.050.00
Nelson, Sierra,161322459.620.000.002459.620.00
Thompson, Tyler,2750269.990.000.0069.990.00
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Nelson, Jordan, H,201304.990.000.004.990.00
Thompson, Brianna, X,1864269.970.000.000.0069.97
Howard, Brianna, D,246304.990.000.000.004.99
Martin, Thomas, A,169521735.980.000.000.001735.98
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Hall, Natalie, A,230704.990.000.004.990.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Washington, Hannah, A,291307.280.000.007.280.00
Cooper, Angela,195261179.470.000.000.001179.47
Washington, Aaron, L,246494.990.000.000.004.99
Turner, Samuel,2742069.990.000.0069.990.00
Bell, Timothy, J,2810178.980.000.0078.980.00
_SUM1806517.5068775.49484210.71324292.26929239.04

Generated 2025-11-02 05:50:34.077 UTC