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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
James, Christina,17409219.920.000.000.00219.92
Martinez, Matthew, L,16009170.450.000.000.00170.45
Jackson, Hannah, G,131432404.970.000.000.002404.97
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Butler, Benjamin, C,189722369.970.000.000.002369.97
Morris, Seth,189592341.460.000.000.002341.46
Torres, Mackenzie,28153570.470.000.000.00570.47
Lee, Ian,19646197.040.000.000.00197.04
Bryant, Gabriel,2765669.990.000.000.0069.99
Thompson, Xavier, R,15761192.410.000.000.00192.41
Hughes, Anna,197052341.970.000.000.002341.97
Robinson, Julia,28121119.980.000.000.00119.98
Yang, Aaron, C,2519654.980.000.000.0054.98
Simmons, Brittany,2923139.980.000.000.0039.98
Martinez, Kristina, S,2134529.930.000.000.0029.93
Scott, Sean, F,2475539.980.000.000.0039.98
Edwards, Madeline,2077146.470.000.000.0046.47
Flores, Nathan, C,2463713.980.000.000.0013.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Perry, Brandon,22095141.980.000.000.00141.98
Moore, Seth,138512331.950.000.000.002331.95
Brown, Morgan,2919778.980.000.000.0078.98
Miller, Andrew, C,271104.990.000.000.004.99
Lee, Alexander, S,18356149.910.000.000.00149.91
Perry, Natalie,1712669.990.000.000.0069.99
Hayes, Hannah, J,2165656.970.000.000.0056.97
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Coleman, Dylan,27403132.970.000.000.00132.97
Young, Jenna, W,163652490.180.000.000.002490.18
Alexander, Caroline,176541759.970.000.000.001759.97
Morris, Mason, J,22349124.990.000.000.00124.99
Wilson, Eduardo,15323804.470.000.000.00804.47
Hill, Timothy,14871848.470.000.000.00848.47
Thompson, Madison, L,187882351.960.000.000.002351.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Griffin, Marcus,2075634.560.000.000.0034.56
Ross, Kaitlyn,16121614.470.000.000.00614.47
Blue, Melanie, L,178611749.960.000.000.001749.96
Reed, Isaac, D,260747.280.000.000.007.28
Diaz, Jason,17374206.630.000.0089.46117.17
Garcia, Christian, J,164913106.330.000.00751.342354.99
Stewart, Jessica,16097103.550.000.0046.5856.97
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Russell, Ian, T,2474613.980.000.0013.980.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Torres, Taylor,16666205.440.000.00123.9881.46
Alexander, Paige, W,1860459.250.000.0037.2721.98
Ramirez, Brian, M,116182369.960.000.002369.960.00
Phillips, Isaiah,28631144.470.000.00144.470.00
Roberts, Robert, R,1898656.970.000.0056.970.00
Zhao, Clarence, R,1982671.970.000.0071.970.00
Xu, Louis,2010466.530.000.0066.530.00
Hill, Carlos,12919257.880.000.00158.9398.95
Peterson, Brian,12892419.470.000.00156.27263.20
Gray, Sara,292472447.050.000.002447.050.00
Price, Marissa,15826160.740.000.00120.4840.26
Martin, Noah, A,1765775.970.000.0075.970.00
Richardson, Arianna, C,1205534.980.000.0034.980.00
Scott, Eric,282484.990.000.004.990.00
Alexander, Aidan,17387148.190.000.0056.9791.22
Robinson, Joseph,2814194.480.000.0094.480.00
Wang, Austin, A,1463284.970.000.009.9974.98
Adams, Kyle, E,1881269.990.000.0069.990.00
Zhang, Heather,166543056.320.000.00751.342304.98
Davis, Dylan,15556588.960.000.00588.960.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Foster, Carson, L,16959135.350.000.0085.4849.87
Deng, Wayne,2145336.960.000.0036.960.00
Williams, Destiny, S,15881564.990.000.00564.990.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Stewart, Allison, R,18826166.430.000.0069.9996.44
Mitchell, Bailey, B,267067.280.000.007.280.00
White, Abigail, T,15866145.820.000.0038.88106.94
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Martin, Jill, C,11824181.030.000.0069.97111.06
Gill, Robyn, J,127651750.980.000.001750.980.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Cox, Sara, P,2775869.990.000.0069.990.00
Van, Bobby,27757132.970.000.00132.970.00
Harris, Seth, M,161402528.330.000.002528.330.00
Parker, Blake,15008170.530.000.0074.9895.55
Gray, Jared, A,264494.990.000.004.990.00
Coleman, Logan,1868691.950.000.000.0091.95
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Sharma, Thomas, A,18637121.940.000.000.00121.94
Reed, Gabriella, A,2743778.980.000.000.0078.98
Tang, Carl,2123832.270.000.000.0032.27
Smith, Katherine, J,13197105.190.000.000.00105.19
Sanders, Xavier,1672173.750.000.000.0073.75
Suarez, Juan, R,167631700.990.000.000.001700.99
Lewis, Morgan,17410168.740.000.000.00168.74
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Dominguez, Meghan,14370122.560.000.000.00122.56
Wang, Zachary,2214489.970.000.000.0089.97
Hall, Morgan,2172641.950.000.000.0041.95
Sanchez, Martin, E,216317.280.000.000.007.28
Morris, Abigail, C,287762.290.000.000.002.29
Davis, Nicholas,1320173.160.000.000.0073.16
Hughes, Samantha,2721564.470.000.000.0064.47
Flores, Logan, K,14631848.470.000.000.00848.47
Yang, Jordan, K,14458133.950.000.000.00133.95
Sharma, Samuel,27725119.980.000.000.00119.98
Rogers, Faith,2468259.980.000.000.0059.98
Williams, Ian, M,175581750.470.000.000.001750.47
Morris, Richard,2007039.980.000.000.0039.98
Madan, Carmen, V,155674720.270.000.000.004720.27
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Stewart, Julia, L,129022329.980.000.000.002329.98
Perez, Jordan, A,292674.990.000.000.004.99
Washington, Elijah, L,250164.990.000.000.004.99
Powell, Lauren, E,1966275.970.000.000.0075.97
Robinson, Abigail, R,183792362.270.000.000.002362.27
Hughes, Justin, M,181222439.990.000.000.002439.99
Thomas, Emily,2180339.980.000.000.0039.98
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Johnson, Edward, H,23279124.990.000.000.00124.99
Hayes, Oscar,2652729.260.000.000.0029.26
Bryant, Nathan,2145059.980.000.000.0059.98
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Kumar, Zachary,254334.990.000.000.004.99
Gutierrez, Jerome,127832420.460.000.000.002420.46
Phillips, Miguel,2049812.940.000.000.0012.94
Thompson, Isabella,18756128.410.000.000.00128.41
King, Caleb, J,2898678.980.000.000.0078.98
Watson, Janet, S,2320859.980.000.000.0059.98
Clark, William,2902169.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Smith, Justin, P,1982721.980.000.000.0021.98
Alexander, Thomas,207607.280.000.000.007.28
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Garcia, Isabella,18382204.940.000.000.00204.94
Patterson, Natalie,16123629.970.000.000.00629.97
Blue, Makayla,1900029.990.000.000.0029.99
Zhang, Nathan, L,2910478.980.000.000.0078.98
Jai, Logan, H,12031769.490.000.000.00769.49
Hall, Fernando,2210090.950.000.000.0090.95
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Martin, Nicholas,233627.280.000.000.007.28
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Stewart, Olivia, B,1874923.780.000.000.0023.78
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Lee, Don,188392384.970.000.000.002384.97
Evans, Gabriel,2348789.970.000.000.0089.97
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Cooper, Andrea,2932378.980.000.000.0078.98
Richardson, Brian,2860878.980.000.000.0078.98
Campbell, Lucas,2932953.990.000.000.0053.99
Flores, Julia, E,172631700.990.000.000.001700.99
Ward, Emma, W,2179659.980.000.000.0059.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Gray, Isabella,168203217.790.000.000.003217.79
Moore, Chloe, L,2626913.980.000.000.0013.98
Jones, Samantha,1831721.980.000.000.0021.98
Alexander, Sarah,1941129.990.000.000.0029.99
Collins, Isaac,260777.280.000.000.007.28
Carter, Jesse, E,22141166.280.000.000.00166.28
Russell, Caleb,23552103.480.000.000.00103.48
Edwards, Hailey,242584.990.000.000.004.99
Kennedy, Bridget,2202639.980.000.000.0039.98
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Gonzales, Jordan,2368113.980.000.000.0013.98
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Butler, Cassidy, L,21792114.460.000.000.00114.46
Howard, Erin, L,183621725.210.000.000.001725.21
Anderson, Jasmine, A,235534.990.000.000.004.99
Hayes, Dalton, C,188822322.280.000.000.002322.28
Reed, Melanie, A,28160574.980.000.000.00574.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Barnes, Blake, A,178651789.970.000.000.001789.97
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Moore, Ian, L,2463939.980.000.000.0039.98
Collins, Allison,28581119.980.000.000.00119.98
Price, Caroline,180511735.980.000.000.001735.98
Foster, Abigail,1982346.470.000.000.0046.47
Ward, Natalie, J,132412325.960.000.000.002325.96
Sandberg, Chase,2190475.970.000.000.0075.97
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Roberts, Amanda,171752334.980.000.000.002334.98
Lewis, Ethan,27998144.470.000.000.00144.47
Edwards, Elijah, D,281577.280.000.000.007.28
Mitchell, Evan, R,247314.990.000.000.004.99
Perry, Jackson, J,213064.990.000.000.004.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Sanchez, Stephanie,1786756.970.000.000.0056.97
Jackson, Victoria,270194.990.000.000.004.99
Luo, Jodi,2921368.490.000.000.0068.49
Hall, Grace, A,201894.990.000.000.004.99
Alexander, Julian,132172351.960.000.000.002351.96
Alvarez, Melody,2507068.490.000.000.0068.49
Scott, Mason,2355139.980.000.000.0039.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Garcia, Kayla, L,2130881.460.000.000.0081.46
Reed, Morgan, E,2877923.970.000.000.0023.97
Bryant, Dakota, L,176132401.950.000.000.002401.95
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Baker, Mason, A,132702394.950.000.000.002394.95
Richardson, Devin, G,2131836.960.000.000.0036.96
Rivera, Hailey, R,2079239.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Malhotra, Brenda,133912405.470.000.000.002405.47
Sanchez, Rachel, C,267304.990.000.000.004.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Reed, Michelle,2804669.990.000.000.0069.99
Zhang, Connor, R,138532329.980.000.000.002329.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Perry, James,192051249.840.000.000.001249.84
Hall, Jason, A,29351119.980.000.000.00119.98
Coleman, Ian,2127639.980.000.000.0039.98
Henderson, Austin,2764354.980.000.000.0054.98
Ross, Seth, M,184332329.980.000.000.002329.98
Lee, Samantha, B,2737878.980.000.000.0078.98
Srini, Evelyn,16855150.950.000.000.00150.95
Johnson, Madison, L,15530846.460.000.000.00846.46
James, Julia,2497567.930.000.000.0067.93
Howard, Danielle,28357133.490.000.000.00133.49
Li, Brandon,2933973.960.000.000.0073.96
Ramirez, Emma,29072128.970.000.000.00128.97
Williams, Joshua,260514.990.000.000.004.99
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Evans, Alexandra,2432268.490.000.000.0068.49
Perez, Timothy, L,227304.990.000.000.004.99
Foster, Isabelle,2637739.980.000.000.0039.98
Baker, Eduardo,180921789.450.000.000.001789.45
Chen, Ethan,2054756.970.000.000.0056.97
Nath, Kenneth, W,170372334.970.000.000.002334.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Flores, Miguel,1975077.250.000.000.0077.25
Johnson, Cameron, R,137201155.480.000.000.001155.48
Sanders, Zoe, L,248254.990.000.000.004.99
Anderson, Ryan, W,132712319.990.000.000.002319.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Jones, Alexandra, B,2020245.950.000.000.0045.95
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Stewart, Marcus, R,2063221.980.000.000.0021.98
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Davis, Jonathan,2925913.980.000.000.0013.98
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Gray, Marcus, T,183892401.450.000.000.002401.45
Thomas, Jeremiah,183721760.470.000.000.001760.47
Ward, Destiny,16128539.990.000.000.00539.99
Ward, Eduardo, I,139162354.980.000.000.002354.98
Li, Eugene, A,15283865.950.000.000.00865.95
Thompson, Lucas, O,212774.990.000.000.004.99
White, Emma, N,16090604.960.000.000.00604.96
Alexander, Gavin, K,2932249.990.000.000.0049.99
Jones, Alexander, I,2002180.960.000.000.0080.96
Griffin, James,28189567.760.000.000.00567.76
_SUM1806517.5068775.49483427.72324653.52929660.77

Generated 2025-11-04 03:49:31.455 UTC