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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Sharma, Samuel,27725119.980.000.000.00119.98
Hughes, Edward,200234530.470.003374.990.001155.48
Flores, Xavier,238664828.110.003578.270.001249.84
Smith, Tyler, J,2034156.970.000.000.0056.97
Williams, Ian, M,175581750.470.000.000.001750.47
White, Miguel, S,13988195.520.000.000.00195.52
Jones, Madison,246614181.760.003578.27603.490.00
Bennett, Seth,244933578.270.003578.270.000.00
Hall, Luke, E,14745902.460.000.000.00902.46
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Russell, Xavier,12964119.950.000.000.00119.95
Shan, Logan,1867760.960.000.0029.9930.97
Washington, Ian, M,246644368.580.003578.270.00790.31
Hall, Natalie, A,230704.990.000.004.990.00
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Diaz, Katherine, P,115262376.960.000.002376.960.00
Hayes, Austin,202083219.580.002049.100.001170.48
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Hill, Fernando,247634.990.000.000.004.99
Chen, Jonathan, G,13096200.690.000.000.00200.69
Cook, Megan, J,2029956.970.000.000.0056.97
Lee, Don,188392384.970.000.000.002384.97
Adams, Haley, M,247862443.350.002443.350.000.00
Evans, Gabriel,2348789.970.000.000.0089.97
Richardson, Victoria, C,248172181.560.002181.560.000.00
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Ross, Haley, T,253612443.350.002443.350.000.00
Martin, Brandon, S,2169139.980.000.000.0039.98
Huang, Kristen,251002443.350.002443.350.000.00
Coleman, Joan, W,2669964.470.000.000.0064.47
Flores, Emma, P,15543180.940.000.000.00180.94
Blue, Paige,2170313.980.000.000.0013.98
Price, Stephanie,258922443.350.002443.350.000.00
Martinez, Jonathan,1330366.250.000.000.0066.25
Brown, Samantha, G,2514739.980.000.000.0039.98
Perez, Timothy, L,227304.990.000.000.004.99
Price, Jocelyn, D,258752443.350.002443.350.000.00
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Morgan, Angela,24665109.970.000.000.00109.97
Price, Riley, R,139094764.020.000.000.004764.02
Flores, Jordyn,252882721.550.002181.560.00539.99
Rubio, Ruben, D,1887186.960.000.0086.960.00
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Alexander, Jordan,2141259.980.000.0059.980.00
Washington, Thomas, C,2745137.430.000.000.0037.43
Ross, Jose,2744178.980.000.0078.980.00
James, Christina,17409219.920.000.000.00219.92
Washington, Hannah, A,291307.280.000.007.280.00
Harris, Edward,27062782.990.00782.990.000.00
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Sanders, Alexandra,259112181.560.002181.560.000.00
Ramirez, Brian, M,116182369.960.000.002369.960.00
Russell, Fernando,27084782.990.000.00782.990.00
Morgan, Isaiah,18978118.730.000.000.00118.73
Stewart, Grace, H,247737.280.000.000.007.28
Campbell, Gabriella,188411145.480.000.000.001145.48
Richardson, Olivia,204683169.590.000.002049.101120.49
Bell, Timothy, J,2810178.980.000.0078.980.00
Hill, Sydney,264821000.440.000.001000.440.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Griffin, Cassidy,264961000.440.000.001000.440.00
Lee, Ethan, J,223597.280.000.000.007.28
Wilson, Christian,27085782.990.000.00782.990.00
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Thomas, Isabella, M,27265782.990.000.00782.990.00
Bell, Danielle,140414765.020.000.000.004765.02
Bailey, Mariah, L,2724354.980.000.000.0054.98
Stewart, Lucas, J,2934198.970.000.000.0098.97
Alexander, Taylor,17482146.940.000.0076.9769.97
Thomas, Zachary, D,28045119.980.000.000.00119.98
Phillips, Jack, R,259952443.350.000.002443.350.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Foster, Deb,215012661.400.000.002661.400.00
Xu, Louis,2010466.530.000.0066.530.00
Coleman, Ashley,27297782.990.000.00782.990.00
Jones, Natalie, A,11845197.200.000.0082.26114.94
Mitchell, Maria, D,27404782.990.000.00782.990.00
Lewis, Ryan, A,203124.990.000.000.004.99
Coleman, Vanessa,215892589.090.000.002049.10539.99
Campbell, Alex,119844730.320.000.002329.982400.34
Bryant, Gabriel,2765669.990.000.000.0069.99
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Bryant, Brittany,2254548.970.000.000.0048.97
Flores, Miguel,1975077.250.000.000.0077.25
Hughes, Jasmine,276284.990.000.000.004.99
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Henderson, Logan, C,2236656.970.000.000.0056.97
Sanders, Sean,14341175.150.000.000.00175.15
White, Edward, J,15847205.460.000.000.00205.46
Lewis, Ethan,27998144.470.000.000.00144.47
Martinez, Kristina, S,2134529.930.000.000.0029.93
Rubio, Javier, E,1972664.240.000.0064.240.00
Patterson, Jeremy,130272319.260.000.000.002319.26
Martinez, Joseph, E,2921459.980.000.0059.980.00
Clark, Miguel, D,169872414.990.000.000.002414.99
Anderson, David, A,2209761.960.000.0061.960.00
Robinson, Sarah, A,2702859.980.000.000.0059.98
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Zeng, Jake,18054106.930.000.000.00106.93
Carter, Savannah, M,120902350.960.000.000.002350.96
Alexander, Jason,2932849.990.000.000.0049.99
Wilson, Daniel, K,142814746.300.000.000.004746.30
Rivera, Rachel, S,2899678.980.000.000.0078.98
Sanders, Hailey,19647282.040.000.000.00282.04
Parker, Caleb, A,2631813.980.000.000.0013.98
Wilson, Emily,174002331.950.000.000.002331.95
Bryant, Samantha,18345115.470.000.000.00115.47
Jackson, Victoria,270194.990.000.000.004.99
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Walker, Richard, T,19640224.550.000.000.00224.55
Morgan, Marcus, W,289682.290.000.000.002.29
Morris, Jessica,289678.990.000.008.990.00
Hall, Noah, A,1525175.250.000.000.0075.25
Taylor, Tyler, A,12032614.960.000.00614.960.00
Wilson, Madison, H,1982821.980.000.000.0021.98
Brooks, Ian, W,2829064.470.000.000.0064.47
Morris, Alyssa,28072548.980.000.000.00548.98
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Turner, Morgan,11823178.470.000.000.00178.47
Rogers, Andrea, L,14328308.660.000.00112.95195.71
Kumar, Zachary,254334.990.000.000.004.99
Robinson, Joseph,2814194.480.000.0094.480.00
Roberts, Amber, W,215822638.060.000.002049.10588.96
Johnson, Xavier, R,2325539.980.000.0039.980.00
Watson, Michelle, H,262352181.560.000.002181.560.00
Walker, Ian,16771104.550.000.0054.5849.97
Johnson, Andrew, F,262942443.350.000.002443.350.00
Chen, Jack, E,17579151.430.000.000.00151.43
Thomas, Richard,27557782.990.000.00782.990.00
Sanders, Zoe, L,248254.990.000.000.004.99
Patterson, Grace, M,27560782.990.000.00782.990.00
Luo, Jodi,2921368.490.000.000.0068.49
Garcia, Lucas,27545782.990.000.00782.990.00
Anderson, Ryan, W,132712319.990.000.000.002319.99
Blue, Marcus, L,27550782.990.000.00782.990.00
Peterson, Christina,2897694.480.000.000.0094.48
Washington, Alexia,27613782.990.000.00782.990.00
Bryant, Zachary,216552648.070.000.002648.070.00
Jackson, Edward,290422420.340.000.002420.340.00
Russell, Melanie, B,15478182.830.000.00167.8514.98
Washington, Hailey, S,2588559.980.000.000.0059.98
Morris, Seth,189592341.460.000.000.002341.46
Torres, Mackenzie,28153570.470.000.000.00570.47
Alexander, Thomas,207607.280.000.000.007.28
Carter, Jesse, E,22141166.280.000.000.00166.28
Ramirez, Ian,166783162.310.000.00742.352419.96
Blue, Makayla,1900029.990.000.000.0029.99
Yang, Aaron, C,2519654.980.000.000.0054.98
Martin, Madison, C,2049271.970.000.0071.970.00
Washington, Alexis,1978146.260.000.007.2838.98
Hughes, Destiny, P,28027119.980.000.000.00119.98
Martin, Nicholas,233627.280.000.000.007.28
Flores, Nathan, C,2463713.980.000.000.0013.98
Kennedy, Bridget,2202639.980.000.000.0039.98
Flores, Kevin,15878225.920.000.0069.97155.95
White, Greg, C,174032322.280.000.000.002322.28
Butler, Trevor,2741569.990.000.0069.990.00
Coleman, Miguel, D,2740069.990.000.0069.990.00
Wright, Jennifer,2650559.980.000.0059.980.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Moore, Seth,138512331.950.000.000.002331.95
Butler, Isabel,16241126.960.000.000.00126.96
Jai, Samuel, L,1635887.950.000.0039.9947.96
Rivera, Makayla, A,2878334.990.000.000.0034.99
Green, Gabriella, C,2803569.990.000.000.0069.99
Cooper, Brianna,2592513.980.000.000.0013.98
Cox, Katelyn, B,2174230.970.000.000.0030.97
He, Micah,2740169.990.000.000.0069.99
Rivera, Ariana,261734.990.000.000.004.99
Harris, Matthew,14330806.760.000.000.00806.76
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Bell, Christina,2609939.980.000.000.0039.98
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Taylor, Edward, C,17442319.880.000.00230.9088.98
Hernandez, Jamie,27283119.980.000.00119.980.00
Jackson, Brianna,1537797.910.000.0074.9822.93
Long, Chloe,167841735.980.000.000.001735.98
Nelson, Jose,19217185.020.000.0091.9593.07
Brown, Julia,18065155.470.000.000.00155.47
Diaz, Brandon,236764.990.000.004.990.00
Ward, Natalie, J,132412325.960.000.000.002325.96
Foster, Alyssa, I,14875839.480.000.000.00839.48
Lopez, Bailey, R,185571179.470.000.001179.470.00
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Robinson, William,20103103.480.000.000.00103.48
Griffin, Haley, L,1892582.180.000.000.0082.18
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Hill, Eric, G,2525667.930.000.0067.930.00
Diaz, Thomas, O,16020595.960.000.000.00595.96
Bryant, Rachel,220197.280.000.007.280.00
Brooks, Steven, C,14877889.470.000.000.00889.47
Li, Jordan,17026261.390.000.00261.390.00
Edwards, Elijah, D,281577.280.000.000.007.28
Wang, Austin, A,1463284.970.000.009.9974.98
Johnson, Christopher,119794813.760.000.002352.212461.55
Richardson, Brian,2860878.980.000.000.0078.98
Wu, Randy, J,116472365.940.000.002365.940.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Griffin, Jack, L,1768632.280.000.000.0032.28
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Alexander, Nathan, A,187951198.970.000.000.001198.97
Richardson, Charles, I,121144719.020.000.002325.962393.06
Adams, Miguel,11659213.520.000.000.00213.52
Perez, Charles,266937.280.000.007.280.00
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Davis, Dylan,15556588.960.000.00588.960.00
Sanchez, Stephanie,1786756.970.000.000.0056.97
Alexander, Julia, J,15291889.470.000.000.00889.47
Brooks, Evan,2340139.980.000.000.0039.98
Coleman, Dylan,27403132.970.000.000.00132.97
Gonzalez, James, M,188421155.480.000.000.001155.48
Stewart, Allison, R,18826166.430.000.0069.9996.44
Flores, Eduardo, S,2896962.980.000.000.0062.98
Bailey, Maria, C,1915034.980.000.000.0034.98
Price, Mariah, C,2074549.480.000.000.0049.48
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Jai, Edwin,169211754.980.000.000.001754.98
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Richardson, Arianna, C,1205534.980.000.0034.980.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Lee, James, J,2881769.990.000.0069.990.00
Richardson, Erin, R,1633188.850.000.0038.8849.97
Scott, Eric,282484.990.000.004.990.00
James, Adrian, C,253404.990.000.000.004.99
Butler, Jonathan,261804.990.000.000.004.99
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Barnes, Emily, G,15996564.990.000.000.00564.99
Richardson, Devin, G,2131836.960.000.000.0036.96
Watson, Marcus,2271585.480.000.000.0085.48
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rodriguez, Julia, A,264884.990.000.004.990.00
Flores, Brandon, L,2562189.970.000.000.0089.97
Flores, Morgan,19817118.940.000.0039.9878.96
Moore, Hunter,14897196.270.000.0071.58124.69
Russell, Nicole, M,182372318.960.000.000.002318.96
Nelson, James, L,245257.280.000.007.280.00
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Thomas, Edward, E,19147133.710.000.000.00133.71
Adams, Jennifer,153624745.020.000.000.004745.02
Diaz, Gabrielle,14893839.480.000.000.00839.48
White, Judith, R,148851155.480.000.000.001155.48
Baker, Robert, A,273007.280.000.007.280.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Jones, Dalton, T,189512334.970.000.000.002334.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Smith, Megan, J,2671668.970.000.000.0068.97
Robinson, Lauren,2719668.490.000.0068.490.00

Generated 2025-10-31 18:54:50.306 UTC