[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
Perez, Jonathan, R,2345512.940.000.000.0012.94
Walker, Jacob, N,29027574.980.000.000.00574.98
Howard, Danielle,28357133.490.000.000.00133.49
Kelly, Bailey, R,28284563.770.000.000.00563.77
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Williams, Sydney, J,15334848.470.000.000.00848.47
Kelly, Erin, D,2351364.470.000.000.0064.47
Adams, Katherine, M,235184.990.000.000.004.99
Torres, Abigail,253674.990.000.000.004.99
Evans, Kaylee,19642133.540.000.000.00133.54
Cooper, Paige,14119148.940.000.000.00148.94
Bailey, Richard, N,220504160.533578.270.000.00582.26
Brooks, Paige,222325985.310.003578.270.002407.04
Andersen, Latoya, J,290578.990.000.000.008.99
Collins, Luis, J,227655978.610.003578.270.002400.34
Sanchez, Stephanie,1786756.970.000.000.0056.97
Wilson, Emily,174002331.950.000.000.002331.95
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Flores, Arianna,217274132.243578.270.000.00553.97
Hall, Morgan,2172641.950.000.000.0041.95
Ye, Alisha, J,220084141.233578.270.000.00562.96
Long, Gabrielle,198305765.923374.990.000.002390.93
Zukowski, Jake,220584118.263578.270.000.00539.99
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Sanchez, Alex, K,131014736.030.000.000.004736.03
Simmons, Mariah,266831270.820.00699.100.00571.72
Morris, Abigail, C,287762.290.000.000.002.29
Campbell, Hunter,17422174.920.000.000.00174.92
Parker, Madeline, H,221826006.320.003578.270.002428.05
Murphy, Richard, M,222994145.540.003578.270.00567.27
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Moore, Taylor, A,199874564.450.003374.990.001189.46
Ross, Antonio,18322148.890.000.000.00148.89
Reed, Erin, I,14353128.840.000.0074.9853.86
Stewart, Hailey,229036054.220.003578.270.002475.95
Griffin, Xavier,228775962.340.003578.270.002384.07
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Flores, Megan, N,230746021.820.003578.270.002443.55
Thompson, Ethan,199894495.480.003374.990.001120.49
Flores, Logan, K,14631848.470.000.000.00848.47
Foster, Eric,229765971.330.003578.270.002393.06
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Wilson, Fernando,16643126.960.000.000.00126.96
Mitchell, Savannah,261153052.800.000.002443.35609.45
Young, Julia, J,274144.990.000.000.004.99
Foster, Olivia,238063578.270.003578.270.000.00
Thomas, Dylan,198737.280.000.000.007.28
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Turner, Wyatt,200345769.960.003399.990.002369.97
Hughes, Luke, I,270141274.080.00699.100.00574.98
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Allen, Amanda,2235339.980.000.000.0039.98
Miller, Alexis, A,12196124.930.000.000.00124.93
Walker, John, M,2858969.990.000.000.0069.99
Watson, Emma,17481126.940.000.000.00126.94
Suarez, Juan, R,167631700.990.000.000.001700.99
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Prasad, Molly,243924329.610.003578.270.00751.34
Hill, Fernando,247634.990.000.000.004.99
Wright, Jackson,11698225.950.000.000.00225.95
Henderson, Caroline,2008256.970.000.000.0056.97
Madan, Carmen, V,155674720.270.000.000.004720.27
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Murphy, Juan, T,246463578.270.003578.270.000.00
Long, Caleb, P,250462181.560.002181.560.000.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Garcia, Carmen, J,247812181.560.002181.560.000.00
Green, Sophia, E,249772181.560.002181.560.000.00
Hughes, Julia,250612443.350.002443.350.000.00
Martin, Morgan,248322181.560.002181.560.000.00
Huang, Kristen,251002443.350.002443.350.000.00
Gray, Alexandria, E,253632443.350.002443.350.000.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Price, Jocelyn, D,258752443.350.002443.350.000.00
Clark, Anthony,27071782.990.00782.990.000.00
Harris, Edward,27062782.990.000.00782.990.00
Sanders, Alexandra,259112181.560.000.002181.560.00
Russell, Fernando,27084782.990.000.00782.990.00
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Blanco, Randall,263211554.410.000.001000.44553.97
Lewis, Isabella,2624267.930.000.000.0067.93
Reed, Catherine, M,203807.280.000.000.007.28
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
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
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Collins, Hailey,11709325.890.000.0021.49304.40
Adams, Hailey, M,121544798.530.000.002379.472419.06
Thomas, Victoria, A,15536249.530.000.000.00249.53
Long, Natalie,14363192.340.000.000.00192.34
Cox, Katelyn, B,2174230.970.000.000.0030.97
Smith, Tyler, J,2034156.970.000.000.0056.97
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Long, Chloe,167841735.980.000.000.001735.98
Clark, Lauren,170341750.980.000.000.001750.98
Griffin, Cassidy,264961000.440.000.001000.440.00
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Cooper, Christina, C,265121000.440.000.001000.440.00
Thompson, Joshua, F,259992181.560.000.002181.560.00
Stewart, Cody, A,212843223.580.000.002049.101174.48
Ward, Nicole, L,212724435.380.000.002071.422363.96
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Washington, Thomas, C,2745137.430.000.000.0037.43
Collins, Connor, J,27270782.990.000.00782.990.00
Townsend, Bryan,14077180.730.000.000.00180.73
Mitchell, Maria, D,27404782.990.000.00782.990.00
Hayes, Carson, A,124472331.950.000.000.002331.95
Diaz, Thomas, O,16020595.960.000.000.00595.96
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Carter, Savannah, M,120902350.960.000.000.002350.96
Adams, Miguel,11659213.520.000.000.00213.52
Liu, Arturo,13222150.410.000.0013.98136.43
Dominguez, Erika, C,21251191.270.000.000.00191.27
Taylor, Christian,2076456.760.000.000.0056.76
Clark, William,2902169.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Roberts, Seth, H,11510258.150.000.0039.47218.68
Smith, Samuel, D,2308349.900.000.000.0049.90
Nelson, Jennifer,171471700.990.000.000.001700.99
Bryant, Gabriel,2765669.990.000.000.0069.99
White, Edward, J,15847205.460.000.000.00205.46
Watson, Michelle, H,262352181.560.000.002181.560.00
Brooks, Mariah,216202620.400.000.002071.42548.98
Edwards, Angel, J,2912469.990.000.000.0069.99
Thomas, Richard,27557782.990.000.00782.990.00
Powell, David, W,266151000.440.000.001000.440.00
Harris, Matthew,14330806.760.000.000.00806.76
Wilson, Victoria, R,27536782.990.000.00782.990.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Washington, Alexia,27613782.990.000.00782.990.00
King, Jordan, C,110202316.970.000.002316.970.00
Washington, Riley, L,185441155.480.000.001155.480.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Scott, Sean, F,2475539.980.000.000.0039.98
Griffin, Haley, L,1892582.180.000.000.0082.18
Flores, Brittany,169062359.980.000.000.002359.98
Martin, John, A,144364776.010.000.000.004776.01
Kelly, Trinity,2609515.230.000.000.0015.23
Clark, Miguel, D,169872414.990.000.000.002414.99
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Diaz, Brandon,236764.990.000.004.990.00
Butler, Jonathan,261804.990.000.000.004.99
Chen, Jack, E,17579151.430.000.000.00151.43
Anderson, Ryan, W,132712319.990.000.000.002319.99
James, Emma,127812329.980.000.000.002329.98
Sanchez, Allison,1666741.720.000.000.0041.72
Shan, Christian, L,2308439.980.000.000.0039.98
Cooper, Amanda, P,146064716.020.000.000.004716.02
Edwards, Amber, B,2051776.970.000.000.0076.97
Simmons, Anna, K,124512367.920.000.000.002367.92
Edwards, Alexandra,133582386.940.000.000.002386.94
Adams, Kyle, E,1881269.990.000.0069.990.00
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Powell, Katherine, C,14574177.600.000.000.00177.60
Hayes, Logan, J,19026113.240.000.0037.2775.97
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Bryant, Dakota, L,176132401.950.000.000.002401.95
Martin, Tyler, L,2772469.990.000.000.0069.99
Washington, Miranda,152014793.020.000.000.004793.02
Stewart, Garrett, O,15762564.480.000.000.00564.48
Diaz, Faith, M,2236356.970.000.000.0056.97
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Deng, Wayne,2145336.960.000.0036.960.00
Williams, Destiny, S,15881564.990.000.00564.990.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Perry, Lauren,248164.990.000.000.004.99
Carter, Jonathan,14578848.470.000.000.00848.47
Stewart, Makayla,16649115.940.000.000.00115.94
Diaz, Gabrielle,14893839.480.000.000.00839.48
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Stewart, Allison, R,18826166.430.000.0069.9996.44
Price, Rachel, D,2532889.970.000.000.0089.97
Flores, Cassidy, L,233684.990.000.000.004.99
Robinson, Madison, W,183772394.970.000.000.002394.97
Perez, Barry, M,2728269.990.000.000.0069.99
Hall, Jason, A,29351119.980.000.000.00119.98
Henderson, Austin,2764354.980.000.000.0054.98
Jackson, Andrew,2047985.480.000.000.0085.48
Lewis, Rachel, J,14900839.480.000.000.00839.48
Kelly, Julia,2379867.930.000.0067.930.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
James, Julia,2497567.930.000.000.0067.93
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Watson, Shelby, J,14911867.970.000.000.00867.97
Simmons, David, E,120172339.970.000.002339.970.00
Martin, Joshua, A,276077.280.000.007.280.00
Russell, Richard,2763322.260.000.000.0022.26
Hughes, Samantha,2721564.470.000.000.0064.47
Watson, Erin, B,227724.990.000.004.990.00
Powell, Sydney, M,14886539.990.000.00539.990.00
Martin, James, M,1987077.250.000.000.0077.25
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Rogers, Faith,2468259.980.000.000.0059.98
Long, Brandon, M,16110650.470.000.000.00650.47
Sanchez, Grace,120802354.990.000.000.002354.99
Hill, Katherine, L,2670139.980.000.000.0039.98
Hughes, Justin, M,181222439.990.000.000.002439.99
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Kumar, Zachary,254334.990.000.000.004.99
Simmons, Jose,2464739.980.000.000.0039.98
Sanders, Isaiah,2587339.980.000.000.0039.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
Robinson, Julia,28121119.980.000.000.00119.98
Zhang, Nathan, L,2910478.980.000.000.0078.98
Simmons, Brittany,2923139.980.000.000.0039.98
Edwards, Madeline,2077146.470.000.000.0046.47
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
Coleman, Dylan,27403132.970.000.000.00132.97
Young, Jenna, W,163652490.180.000.000.002490.18
Rowe, Todd,14586233.940.000.000.00233.94
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Peterson, Xavier, R,2645639.980.000.000.0039.98
Griffin, Miguel,2146476.970.000.000.0076.97
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Alexander, Sarah,1941129.990.000.000.0029.99
Wood, Brittany,2877753.990.000.000.0053.99
Gonzales, Emily, P,21777180.980.000.000.00180.98
Russell, Caleb,23552103.480.000.000.00103.48
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
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Robinson, Ian, D,138522294.990.000.000.002294.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Reed, Megan, A,181181750.980.000.000.001750.98
Phillips, Haley, B,2807939.980.000.000.0039.98
Moore, Ian, L,2463939.980.000.000.0039.98
Foster, Isabelle,2637739.980.000.000.0039.98
Foster, Abigail,1982346.470.000.000.0046.47
Rodriguez, Natalie,2077330.970.000.000.0030.97
Jones, Alexandra, B,2020245.950.000.000.0045.95
Roberts, Noah, S,2704268.490.000.000.0068.49
Brown, Christian,227554.990.000.000.004.99
Ward, Destiny,16128539.990.000.000.00539.99
Foster, Nicole, A,2349489.970.000.000.0089.97
Butler, Jackson, J,183241735.980.000.000.001735.98
Jones, Alexander, I,2002180.960.000.000.0080.96
Hughes, Austin, P,183681754.980.000.000.001754.98
Long, Rachel,2828339.980.000.000.0039.98
Li, Brandon,2933973.960.000.000.0073.96
Ramirez, Emma,29072128.970.000.000.00128.97
Washington, Adam, G,2543713.980.000.000.0013.98
Collins, Eduardo,139872329.990.000.000.002329.99
_SUM1806517.5065197.22486223.00323791.51931305.77

Generated 2025-11-05 12:49:07.451 UTC