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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Parker, Caleb, A,2631813.980.000.000.0013.98
Hughes, Riley,2928449.990.000.000.0049.99
Martinez, Matthew, L,16009170.450.000.000.00170.45
Robinson, Joseph,2814194.480.000.000.0094.48
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Reed, Michelle,2804669.990.000.000.0069.99
Rivera, Makayla, A,2878334.990.000.000.0034.99
Perry, Samuel,18811100.960.000.000.00100.96
Anderson, Madison, G,2835978.980.000.000.0078.98
Zhang, Connor, R,138532329.980.000.000.002329.98
He, Micah,2740169.990.000.000.0069.99
Collins, Jose,2474839.980.000.000.0039.98
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Lee, James, J,2881769.990.000.000.0069.99
Rivera, Ariana,261734.990.000.000.004.99
Taylor, Edward, C,17442319.880.000.000.00319.88
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Russell, Arianna,22728149.930.000.000.00149.93
Martin, Brandon, S,2169139.980.000.000.0039.98
Wang, Austin, A,1463284.970.000.000.0084.97
Diaz, Jason,17374206.630.000.0089.46117.17
Diaz, Brandon,236764.990.000.000.004.99
Hughes, Isabella,2304851.460.000.000.0051.46
Anderson, Daniel,20694146.970.000.000.00146.97
Lewis, Morgan,17410168.740.000.000.00168.74
Perry, Benjamin,291652407.040.000.000.002407.04
Roberts, Amber, W,215822638.060.000.002049.10588.96
Davis, Dylan,15556588.960.000.000.00588.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Bryant, Rachel,220197.280.000.000.007.28
Lee, Ethan, J,223597.280.000.000.007.28
Gonzales, Cameron, L,2900569.990.000.000.0069.99
Morris, Mason, J,22349124.990.000.000.00124.99
Ramirez, Richard, C,282397.280.000.000.007.28
Martinez, Jonathan,1330366.250.000.000.0066.25
Hughes, Caroline, C,2830278.980.000.000.0078.98
Flores, Julia, E,172631700.990.000.000.001700.99
Mohamed, Samantha, A,292772419.060.000.000.002419.06
Robinson, William,20103103.480.000.000.00103.48
Deng, Wayne,2145336.960.000.000.0036.96
Barnes, Elizabeth, J,249397.280.000.000.007.28
Hernandez, Sierra,27393123.980.000.000.00123.98
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Williams, Destiny, S,15881564.990.000.000.00564.99
Long, Sydney,279217.280.000.000.007.28
Kelly, Bailey, R,28284563.770.000.000.00563.77
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Sanchez, Jeremiah, E,2226521.980.000.000.0021.98
Wilson, Madison, H,1982821.980.000.000.0021.98
Hughes, Austin, P,183681754.980.000.000.001754.98
Carter, Savannah, M,120902350.960.000.000.002350.96
Lewis, Jeremiah,1437187.260.000.000.0087.26
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Ross, Aaron, N,118882376.960.000.000.002376.96
Wilson, Daniel, K,142814746.300.000.000.004746.30
Nelson, James, L,245257.280.000.000.007.28
Bradley, Alexandria,176911779.470.000.000.001779.47
Robinson, Lauren,2719668.490.000.000.0068.49
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Mitchell, Bailey, B,267067.280.000.000.007.28
Reed, Isaac, D,260747.280.000.000.007.28
Torres, Dalton,235037.280.000.000.007.28
Edwards, Angel, J,2912469.990.000.000.0069.99
Allen, Madeline,2924068.970.000.000.0068.97
Smith, Austin,13707149.050.000.000.00149.05
Gonzales, Gavin,2448813.980.000.000.0013.98
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Long, Rachel,2828339.980.000.000.0039.98
White, Greg, C,174032322.280.000.000.002322.28
Parker, Jeremy,2866878.980.000.000.0078.98
Bell, Christina,2609939.980.000.000.0039.98
Gill, Robyn, J,127651750.980.000.000.001750.98
Richardson, Brian,2860878.980.000.000.0078.98
Watson, Erin, B,227724.990.000.000.004.99
Watson, Marcus,2271585.480.000.000.0085.48
Kumar, Cameron, S,185711120.490.000.000.001120.49
Jai, Hunter, M,28272111.950.000.000.00111.95
Harris, Seth, M,161402528.330.000.000.002528.33
Bryant, Nathan,2145059.980.000.000.0059.98
Smith, Nathan,217647.280.000.000.007.28
Evans, Alexandra,2432268.490.000.000.0068.49
Powell, Sydney, M,14886539.990.000.000.00539.99
Taylor, Natalie, M,14338828.740.000.000.00828.74
Cox, Sara, P,2775869.990.000.000.0069.99
Griffin, Marcus,2075634.560.000.000.0034.56
Martin, Alfredo, P,2148039.980.000.000.0039.98
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Van, Bobby,27757132.970.000.000.00132.97
Watson, Devin, A,18875114.950.000.000.00114.95
Kapoor, Preston,2143156.970.000.000.0056.97
Harris, Destiny, M,137102341.460.000.000.002341.46
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Alexander, Julia, J,15291889.470.000.000.00889.47
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Murphy, Chase, J,2472958.980.000.000.0058.98
Ramirez, Emma,29072128.970.000.000.00128.97
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Williams, Sydney, J,15334848.470.000.000.00848.47
Miller, Kayla, A,236734.990.000.000.004.99
Williams, Joshua,260514.990.000.000.004.99
Thomas, Richard,27557782.990.000.00782.990.00
Foster, Kayla,1969371.950.000.000.0071.95
Gray, Jared, A,264494.990.000.000.004.99
Washington, Alexia,27613782.990.000.00782.990.00
Long, Jordyn,1733847.250.000.000.0047.25
Henderson, Justin, P,235917.280.000.000.007.28
Davis, Richard, R,15549574.980.000.00574.980.00
Rodriguez, Taylor,1607166.960.000.000.0066.96
Johnson, Jonathan,220597.280.000.000.007.28
Jackson, Edward,290422420.340.000.002420.340.00
Lee, Don,188392384.970.000.000.002384.97
Torres, Abigail,253674.990.000.000.004.99
Chen, Ethan,2054756.970.000.000.0056.97
Gray, Isabella,168203217.790.000.000.003217.79
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Henderson, Abigail,2044139.980.000.000.0039.98
Stewart, Lucas, J,2934198.970.000.000.0098.97
Jones, Charles,22882101.450.000.000.00101.45
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Anderson, Jasmine, A,235534.990.000.000.004.99
Ross, Kaitlyn,16121614.470.000.000.00614.47
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Blue, Melanie, L,178611749.960.000.000.001749.96
Murphy, Maria,160113657.260.000.000.003657.26
Long, Sarah,173721729.970.000.000.001729.97
Howard, Natalie,1349154.960.000.0014.9839.98
Young, Courtney,176222374.980.000.000.002374.98
Kennedy, Bridget,2202639.980.000.000.0039.98
Alexander, Julian,132172351.960.000.000.002351.96
Flores, Kevin,15878225.920.000.000.00225.92
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Lee, Kayla, M,2078115.230.000.000.0015.23
Robinson, Zachary, L,137092332.280.000.000.002332.28
Russell, Caleb,23552103.480.000.000.00103.48
Coleman, Dylan,27403132.970.000.000.00132.97
Hayes, Dalton, C,188822322.280.000.000.002322.28
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Bailey, Maria, C,1915034.980.000.000.0034.98
Watson, Michelle, H,262352181.560.000.002181.560.00
Stewart, Marcus, R,2063221.980.000.000.0021.98
Ward, Stephanie, A,27429782.990.000.00782.990.00
Martin, Tyler, L,2772469.990.000.000.0069.99
Bell, Julia,216522646.060.000.002646.060.00
Robinson, Ian, D,138522294.990.000.000.002294.99
Powell, David, W,266151000.440.000.001000.440.00
Rivera, Sara,187852350.960.000.000.002350.96
Wilson, Victoria, R,27536782.990.000.00782.990.00
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Bryant, Zachary,216552648.070.000.002049.10598.97
Gonzales, Jordan,2368113.980.000.000.0013.98
King, Jordan, C,110202316.970.000.002316.970.00
Diaz, Trevor, B,2051954.960.000.000.0054.96
Washington, Riley, L,185441155.480.000.001155.480.00
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Morgan, Brianna, D,111362380.470.000.002380.470.00
Reed, Megan, A,181181750.980.000.000.001750.98
Nath, Kenneth, W,170372334.970.000.000.002334.97
Phillips, Haley, B,2807939.980.000.000.0039.98
Roberts, Rebecca,2800094.480.000.000.0094.48
Allen, Luke,113162349.980.000.002349.980.00
Thomas, Zachary, D,28045119.980.000.000.00119.98
Foster, Isabelle,2637739.980.000.000.0039.98
James, Adrian, C,253404.990.000.000.004.99
Price, Caroline,180511735.980.000.000.001735.98
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Martin, Katherine, J,2027339.980.000.000.0039.98
Griffin, Miguel,2146476.970.000.000.0076.97
Russell, Nicole, M,182372318.960.000.000.002318.96
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Thomas, Jessica,1684894.480.000.0094.480.00
Thompson, Madison, L,187882351.960.000.000.002351.96
Coleman, Miguel, D,2740069.990.000.0069.990.00
Ward, Cole,214907.280.000.000.007.28
Hall, Natalie, A,230704.990.000.004.990.00
Rivera, Amanda,11131115.920.000.000.00115.92
Evans, Maria,22544127.280.000.00127.280.00
Butler, Jonathan,261804.990.000.000.004.99
Diaz, Gabrielle,14893839.480.000.000.00839.48
Luo, Jodi,2921368.490.000.000.0068.49
Yuan, Brendan, S,247444.990.000.000.004.99
Anderson, Ryan, W,132712319.990.000.000.002319.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Rogers, Bryce,174022304.980.000.000.002304.98
Walker, Ian,16771104.550.000.000.00104.55
Edwards, Hunter,2422067.930.000.000.0067.93
Coleman, Samuel, N,17450123.980.000.000.00123.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Baker, Gabriella,174041709.980.000.000.001709.98
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Alexander, Luke,290432447.050.000.002447.050.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Allen, Jack, M,291372419.060.000.002419.060.00
Diaz, Hailey, W,116932294.990.000.002294.990.00
Baker, Eduardo,180921789.450.000.000.001789.45
Foster, Abigail,1982346.470.000.000.0046.47
Watson, Victoria,16125588.960.000.000.00588.96
Baker, Mason, A,132702394.950.000.000.002394.95
Nelson, Jordan, H,201304.990.000.004.990.00
Stewart, Makayla,16649115.940.000.000.00115.94
Butler, Trevor,2741569.990.000.0069.990.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Jones, Kayla, C,1854194.260.000.000.0094.26
White, Judith, R,148851155.480.000.000.001155.48
Foster, Emma,15468436.350.000.000.00436.35
Davis, Jonathan,2925913.980.000.000.0013.98
Sanchez, Rachel, C,267304.990.000.000.004.99
Mitchell, Evan, R,247314.990.000.000.004.99
Flores, Luke, L,247337.280.000.000.007.28
Thomas, Dalton,230097.280.000.000.007.28
Alexander, Paige, W,1860459.250.000.000.0059.25
Ramirez, Brian, M,116182369.960.000.000.002369.96
Lee, Samantha, B,2737878.980.000.000.0078.98
Flores, Morgan,19817118.940.000.000.00118.94
Zhao, Clarence, R,1982671.970.000.000.0071.97
Martin, James, M,1987077.250.000.000.0077.25
Gonzalez, Molly,1637021.980.000.000.0021.98
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Shan, Gabriel, T,2773169.990.000.000.0069.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Perry, James,192051249.840.000.000.001249.84
Walker, Jacob, N,29027574.980.000.000.00574.98
Johnson, Xavier, R,2325539.980.000.000.0039.98
Rodriguez, Julia, A,264884.990.000.000.004.99
Li, Jordan,17026261.390.000.000.00261.39
Peterson, Isabella,2808039.980.000.000.0039.98
Smith, Zachary, W,2378358.980.000.000.0058.98
Perez, Charles,266937.280.000.000.007.28
Adams, Mason, T,2052864.470.000.000.0064.47
Richardson, Erin, R,1633188.850.000.000.0088.85
Moore, Jennifer, A,2175964.470.000.000.0064.47
Johnson, Madison, L,15530846.460.000.000.00846.46
Howard, Danielle,28357133.490.000.000.00133.49
Hernandez, Eduardo, J,18919300.940.000.000.00300.94
Jones, Alexander, I,2002180.960.000.000.0080.96
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Anderson, Tyler, E,131481137.430.000.000.001137.43
Harris, Noah,292562393.060.000.000.002393.06
Martin, Joshua, A,276077.280.000.000.007.28
Li, Brandon,2933973.960.000.000.0073.96
Washington, Adam, G,2543713.980.000.000.0013.98
Campbell, Timothy,2584513.980.000.000.0013.98
Collins, Eduardo,139872329.990.000.000.002329.99
Chen, David,2720839.980.000.000.0039.98
Hughes, Antonio, P,15913712.270.000.000.00712.27
Collins, Charles, B,29041628.450.000.000.00628.45
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Sanchez, Grace,120802354.990.000.000.002354.99
Hill, Katherine, L,2670139.980.000.000.0039.98
Kelly, Erin, D,2351364.470.000.000.0064.47
_SUM1806517.5025543.71493581.21255540.501031852.08

Generated 2025-12-21 21:14:14.618 UTC