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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Powell, David, W,266151000.440.000.001000.440.00
Li, Rafael, M,217527.280.000.000.007.28
Flores, Hannah,1952540.230.000.000.0040.23
Foster, Isabel, M,2174571.950.000.000.0071.95
Moore, Fernando,265821000.440.000.001000.440.00
Edwards, Elijah, D,281577.280.000.000.007.28
Jones, Alexandra, B,2020245.950.000.000.0045.95
Jackson, Brianna,1537797.910.000.0074.9822.93
Davis, Richard, R,15549574.980.000.00574.980.00
Lal, Jack, R,185251735.980.000.000.001735.98
Chen, Jack, E,17579151.430.000.000.00151.43
Evans, Jordan,2920939.980.000.0039.980.00
Murphy, Chase, J,2472958.980.000.000.0058.98
Rodriguez, Natalie,2077330.970.000.000.0030.97
Anderson, Ryan, W,132712319.990.000.000.002319.99
James, Maria,1624391.970.000.0069.9921.98
Flores, Madison,14416769.490.000.000.00769.49
Brooks, Evan,2340139.980.000.000.0039.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Peterson, Isabella,2808039.980.000.0039.980.00
Davis, Ethan,136604750.010.000.000.004750.01
Jackson, Victoria,270194.990.000.000.004.99
Edwards, Alexandra,133582386.940.000.000.002386.94
Anderson, Jasmine, A,235534.990.000.000.004.99
Gomez, Krista,12760273.180.000.0036.27236.91
Gonzalez, Molly,1637021.980.000.000.0021.98
Johnson, Madison, L,15530846.460.000.000.00846.46
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Washington, Alexis,1978146.260.000.007.2838.98
Shan, Gabriel, T,2773169.990.000.000.0069.99
Bailey, Maria, C,1915034.980.000.000.0034.98
Edwards, Hailey,242584.990.000.000.004.99
Gutierrez, Jerome,127832420.460.000.000.002420.46
Alvarez, Melody,2507068.490.000.000.0068.49
Reed, Morgan, E,2877923.970.000.000.0023.97
James, Bryce,13466133.450.000.000.00133.45
Parker, Amanda,1808151.970.000.000.0051.97
Scott, Mason,2355139.980.000.000.0039.98
Baker, Gabriella,174041709.980.000.000.001709.98
Smith, Austin,13707149.050.000.000.00149.05
Phillips, Miguel,2049812.940.000.000.0012.94
Sanders, Mason, G,2345939.980.000.000.0039.98
Bryant, Dakota, L,176132401.950.000.000.002401.95
Kennedy, Bridget,2202639.980.000.000.0039.98
Morgan, Angela,24665109.970.000.000.00109.97
Thomas, Jeremiah,183721760.470.000.000.001760.47
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Robinson, Ian, D,138522294.990.000.000.002294.99
Allen, Luke,113162349.980.000.002349.980.00
Perry, James,192051249.840.000.000.001249.84
Alexander, Gavin, K,2932249.990.000.000.0049.99
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Alexander, Ryan, J,14078839.480.000.00839.480.00
Gray, Sebastian, B,138782366.960.000.000.002366.96
Griffin, James,28189567.760.000.000.00567.76
Diaz, Trevor, B,2051954.960.000.000.0054.96
Butler, Dalton, A,133454759.510.000.000.004759.51
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Baker, Mason, A,132702394.950.000.000.002394.95
Reed, Megan, A,181181750.980.000.000.001750.98
Yuan, Leonard, F,167911729.970.000.000.001729.97
Stewart, Marcus, R,2063221.980.000.000.0021.98
Stewart, Alexandria,174761700.990.000.000.001700.99
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Sanchez, Jared, J,2585064.470.000.000.0064.47
Martin, Tyler, L,2772469.990.000.000.0069.99
Hayes, Jason,261764.990.000.000.004.99
Moore, Ian, L,2463939.980.000.000.0039.98
Flores, Devin, A,15559172.040.000.0086.5685.48
Allen, Mason,176252431.950.000.000.002431.95
Malhotra, Brenda,133912405.470.000.000.002405.47
Price, Caroline,180511735.980.000.000.001735.98
Carter, Isaac,137191129.480.000.000.001129.48
Butler, Jackson, J,183241735.980.000.000.001735.98
Russell, Katherine,2877169.990.000.000.0069.99
Watson, Victoria,16125588.960.000.000.00588.96
Prasad, Erick, E,28786127.950.000.000.00127.95
Jones, Alexander, I,2002180.960.000.000.0080.96
Martin, Alfredo, P,2148039.980.000.000.0039.98
Chen, Ethan,2054756.970.000.000.0056.97
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Diaz, Gabrielle,14893839.480.000.000.00839.48
Sandberg, Chase,2190475.970.000.000.0075.97
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Hughes, Austin, P,183681754.980.000.000.001754.98
Sanchez, Rachel, C,267304.990.000.000.004.99
Stewart, Lucas, J,2934198.970.000.000.0098.97
Coleman, Miguel, D,2740069.990.000.0069.990.00
Allen, Madeline,2924068.970.000.000.0068.97
Yuan, Brendan, S,247444.990.000.000.004.99
Thomas, Zachary, D,28045119.980.000.000.00119.98
Russell, Ian, T,2474613.980.000.0013.980.00
Gomez, Briana, A,2878443.980.000.000.0043.98
Li, Eugene, A,15283865.950.000.000.00865.95
Simmons, Nicole, S,2617729.480.000.000.0029.48
Diaz, Katherine, P,115262376.960.000.002376.960.00
Long, Rachel,2828339.980.000.000.0039.98
Hall, Jason, A,29351119.980.000.000.00119.98
Mitchell, Evan, R,247314.990.000.000.004.99
Evans, Maria,22544127.280.000.00127.280.00
Ortega, Sheila, M,2763239.980.000.000.0039.98
Thompson, Lucas, O,212774.990.000.000.004.99
Flores, Miguel,1975077.250.000.000.0077.25
Clark, William,2902169.990.000.000.0069.99
Li, Brandon,2933973.960.000.000.0073.96
Henderson, Austin,2764354.980.000.000.0054.98
Bell, Chase,180911750.980.000.000.001750.98
Jackson, Hannah, G,131432404.970.000.000.002404.97
Stewart, Makayla,16649115.940.000.000.00115.94
Jackson, Andrew,2047985.480.000.000.0085.48
Wilson, Emily,174002331.950.000.000.002331.95
Torres, Mackenzie,28153570.470.000.000.00570.47
Ramirez, Emma,29072128.970.000.000.00128.97
Ross, Seth, M,184332329.980.000.000.002329.98
Long, Sarah,173721729.970.000.000.001729.97
Alexander, Thomas,207607.280.000.000.007.28
Collins, Eduardo,139872329.990.000.000.002329.99
Li, Thomas,181162376.960.000.000.002376.96
Johnson, Cameron, R,137201155.480.000.000.001155.48
Thompson, Brianna, X,1864269.970.000.000.0069.97
Williams, Sydney, J,15334848.470.000.000.00848.47
White, Emma, N,16090604.960.000.000.00604.96
Garcia, Kayla, L,2130881.460.000.000.0081.46
Turner, James, E,16841126.960.000.0069.9956.97
Nath, Yolanda, A,2462513.980.000.000.0013.98
Torres, Abigail,253674.990.000.000.004.99
Butler, Jonathan,261804.990.000.000.004.99
Ruiz, Philip,1807781.460.000.000.0081.46
White, Judith, R,148851155.480.000.000.001155.48
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Harris, Jacob, G,2367939.980.000.0039.980.00
Davis, Jonathan,2925913.980.000.000.0013.98
Luo, Jodi,2921368.490.000.000.0068.49
Robinson, Emily,12183228.420.000.0054.96173.46
Perez, Katherine, J,2207924.270.000.000.0024.27
Roberts, Noah, S,2704268.490.000.000.0068.49
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Lee, Samantha, B,2737878.980.000.000.0078.98
Young, Courtney,176222374.980.000.000.002374.98
Miller, Victoria,15816188.020.000.00118.0569.97
Morgan, Isabella, L,28602144.470.000.000.00144.47
Foster, Alyssa, I,14875839.480.000.000.00839.48
Phillips, Aaron, R,2494739.980.000.000.0039.98
Lee, Kayla, M,2078115.230.000.000.0015.23
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Brown, Christian,227554.990.000.000.004.99
Blue, Makayla,1900029.990.000.000.0029.99
Reed, Michelle,2804669.990.000.000.0069.99
Yang, Aaron, C,2519654.980.000.000.0054.98
Patterson, Austin, O,270247.280.000.000.007.28
Jai, Logan, H,12031769.490.000.000.00769.49
Ward, Destiny,16128539.990.000.000.00539.99
Wilson, Grace,17539205.920.000.000.00205.92
Zhang, Connor, R,138532329.980.000.000.002329.98
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Bryant, Brittany,2254548.970.000.000.0048.97
Ward, Eduardo, I,139162354.980.000.000.002354.98
Cooper, Alexandra,19541131.240.000.000.00131.24
Moore, Jennifer, A,2175964.470.000.000.0064.47
Perry, Justin, E,167583062.340.000.000.003062.34
Blanco, Armando, F,139182397.950.000.000.002397.95
McDonald, Aaron, J,27734119.980.000.000.00119.98
Srini, Evelyn,16855150.950.000.000.00150.95
Bailey, Olivia,238924.990.000.000.004.99
Foster, Nicole, A,2349489.970.000.000.0089.97
Thames, Bernard,2380368.490.000.000.0068.49
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Carter, Jose, H,12532235.720.000.000.00235.72
Martinez, Joseph, E,2921459.980.000.0059.980.00
Martin, Katherine, J,2027339.980.000.000.0039.98
Anderson, Isabella,137432349.980.000.000.002349.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Edwards, Madeline,2077146.470.000.000.0046.47
Flores, Brandon, L,2562189.970.000.000.0089.97
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Campbell, Timothy,2584513.980.000.000.0013.98
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Williams, Joshua,260514.990.000.000.004.99
Lee, James, J,2881769.990.000.0069.990.00
Robinson, Madison, W,183772394.970.000.000.002394.97
Perry, Samuel,18811100.960.000.00100.960.00
Rogers, Paige, H,17125539.990.000.000.00539.99
Hughes, Luis,130841798.960.000.000.001798.96
Gray, Marcus, T,183892401.450.000.000.002401.45
Zhang, Heather,166543056.320.000.00751.342304.98
Coleman, Ian,2127639.980.000.000.0039.98
Russell, Arianna,22728149.930.000.00149.930.00
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Johnson, Ian, E,2173283.470.000.000.0083.47
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Davis, Justin,2807412.940.000.000.0012.94
Hall, Eduardo,16847189.940.000.000.00189.94
James, Julia,2497567.930.000.000.0067.93
Perry, Brandon,22095141.980.000.000.00141.98
Adams, Katherine, M,235184.990.000.000.004.99
Evans, Gabriel,2348789.970.000.000.0089.97
Campbell, Natalie, L,115122319.990.000.000.002319.99
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Bryant, Rachel,220197.280.000.007.280.00
Li, Jordan,17026261.390.000.00261.390.00
Ramirez, Richard, C,282397.280.000.007.280.00
Anderson, Daniel,20694146.970.000.00146.970.00
Bennett, Brittany, J,2233239.980.000.000.0039.98
Andersen, Latoya, J,290578.990.000.000.008.99
Richardson, Charles, I,121144719.020.000.002325.962393.06
Patterson, Jeremy,130272319.260.000.000.002319.26
Clark, Miguel, D,169872414.990.000.000.002414.99
Moore, Jessica, J,2008576.760.000.000.0076.76
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Olivia,188591155.480.000.000.001155.48
Shan, Christian, L,2308439.980.000.000.0039.98
Smith, Chloe,17619163.920.000.000.00163.92
Simmons, Anna, K,124512367.920.000.000.002367.92
Brown, Morgan,2919778.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
James, Morgan, E,2324539.980.000.000.0039.98
Hernandez, Sierra,27393123.980.000.00123.980.00
Stewart, Allison, R,18826166.430.000.0069.9996.44
Mitchell, Caleb, K,268064.990.000.000.004.99
Alexander, Jason,2932849.990.000.000.0049.99
Rivera, Rachel, S,2899678.980.000.000.0078.98
Alexander, Angelica,2271471.950.000.000.0071.95
Carter, Jonathan,14578848.470.000.000.00848.47
Adams, Gabriel, S,195271219.450.000.000.001219.45
Mehta, Carmen, C,2743694.480.000.000.0094.48
Alexander, Caroline,176541759.970.000.000.001759.97
Martin, Joshua, A,276077.280.000.007.280.00
Sanders, Lucas, W,268024.990.000.000.004.99
Flores, Cassidy, L,233684.990.000.000.004.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Barnes, Elizabeth, J,249397.280.000.000.007.28
Wilson, Madison, H,1982821.980.000.000.0021.98
Smith, Nathan,217647.280.000.007.280.00
Harris, Seth, M,161402528.330.000.002528.330.00
Lewis, Christopher,1875586.960.000.0086.960.00
Ross, David, M,171431763.970.000.000.001763.97
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Barnes, Dalton, C,178581700.990.000.000.001700.99
Gray, Jared, A,264494.990.000.004.990.00
Torres, Christina, M,20746119.950.000.0064.9754.98
Gonzalez, Amber, L,2387964.470.000.0064.470.00
Henderson, Justin, P,235917.280.000.007.280.00
Turner, Mary,220154.990.000.000.004.99
Reed, Gabriella, A,2743778.980.000.000.0078.98
Hill, Katherine, L,2670139.980.000.000.0039.98

Generated 2025-11-01 16:50:09.018 UTC