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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Sanders, Mason, G,2345939.980.000.000.0039.98
Moore, Anthony, M,2473039.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Cox, Arianna, D,1892789.250.000.000.0089.25
James, Emma,127812329.980.000.000.002329.98
Morris, Mason, J,22349124.990.000.000.00124.99
Foster, Jose, C,2878534.990.000.000.0034.99
Flores, Julia, E,172631700.990.000.000.001700.99
Cooper, Christina, C,265121000.440.000.001000.440.00
Barnes, Elizabeth, J,249397.280.000.000.007.28
Cox, Julia, A,206703228.570.000.002049.101179.47
Long, Sydney,279217.280.000.000.007.28
Diaz, Hunter, S,27242782.990.000.00782.990.00
Martin, Christian, V,19709197.250.000.000.00197.25
Stewart, Andrea, M,27252782.990.000.00782.990.00
Sanders, Lucas, W,268024.990.000.000.004.99
Thompson, Devin,207084406.400.000.002071.422334.98
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Phillips, Kaylee,211384371.380.000.002049.102322.28
Miller, Destiny,251577.280.000.000.007.28
Jones, Zachary, J,27285782.990.000.00782.990.00
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Jones, Kayla, C,1854194.260.000.000.0094.26
Long, Gavin,13762186.030.000.0036.59149.44
Flores, Caleb, S,12165280.640.000.00243.3737.27
Edwards, Hunter,2422067.930.000.000.0067.93
Reed, Kaylee, R,17371151.920.000.000.00151.92
James, Morgan, E,2324539.980.000.000.0039.98
Morgan, Evan, G,14725318.830.000.0069.97248.86
Patterson, Aaron, W,191131184.460.000.000.001184.46
Parker, Jordan,216212616.860.000.002049.10567.76
Reed, Morgan, E,2877923.970.000.000.0023.97
Foster, Aaron,155664912.470.000.000.004912.47
Baker, Gabriella,174041709.980.000.000.001709.98
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Allen, Mason,176252431.950.000.000.002431.95
Perez, Barry, M,2728269.990.000.000.0069.99
Clark, Joseph, D,153954780.020.000.000.004780.02
Rogers, Paige, H,17125539.990.000.000.00539.99
Stewart, Alexandria,174761700.990.000.000.001700.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Edwards, Madeline,2077146.470.000.000.0046.47
Li, Eugene, A,15283865.950.000.000.00865.95
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Coleman, Ian,2127639.980.000.000.0039.98
Russell, Arianna,22728149.930.000.00149.930.00
Li, Thomas,181162376.960.000.000.002376.96
Evans, Jordan,2920939.980.000.0039.980.00
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Stewart, Olivia, B,1874923.780.000.000.0023.78
Harris, Anthony,2144721.980.000.000.0021.98
Perry, Brandon,22095141.980.000.000.00141.98
Turner, Eduardo,158764789.020.000.000.004789.02
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Nath, Alison, J,171161764.960.000.000.001764.96
Anderson, Daniel,20694146.970.000.00146.970.00
Bell, Julia,216522646.060.000.002646.060.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Russell, Jessica,265721000.440.000.001000.440.00
Jai, Hunter, M,28272111.950.000.000.00111.95
Powell, David, W,266151000.440.000.001000.440.00
Miller, Andrew, C,271104.990.000.000.004.99
Moore, Fernando,265821000.440.000.001000.440.00
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Wang, Zachary,2214489.970.000.000.0089.97
Hayes, Logan, J,19026113.240.000.0037.2775.97
Wilson, Andrew, R,182362414.990.000.000.002414.99
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Washington, Christian, R,2668639.980.000.000.0039.98
Foster, Jessica,2606951.460.000.0051.460.00
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Deng, Wayne,2145336.960.000.0036.960.00
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Williams, Destiny, S,15881564.990.000.00564.990.00
Davis, Justin,2807412.940.000.000.0012.94
Peterson, Mason, A,185701174.480.000.001174.480.00
James, Julia,2497567.930.000.000.0067.93
Barnes, Dalton, C,178581700.990.000.000.001700.99
Allen, Luke,113162349.980.000.002349.980.00
Alexander, Luke,290432447.050.000.002447.050.00
Nelson, Sierra,161322459.620.000.002459.620.00
Allen, Jack, M,291372419.060.000.002419.060.00
Robinson, Abigail, R,183792362.270.000.000.002362.27
Thomas, Emily,2180339.980.000.000.0039.98
Hernandez, Marcus,185952329.990.000.000.002329.99
Thomas, Jessica,1684894.480.000.0094.480.00
Nelson, Jordan, H,201304.990.000.004.990.00
Martin, Tyler, L,2772469.990.000.000.0069.99
Griffin, Haley, L,1892582.180.000.000.0082.18
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Baker, Mason, A,132702394.950.000.000.002394.95
Phillips, Devin,18759112.060.000.000.00112.06
Jones, Samantha,1831721.980.000.000.0021.98
Martin, Katherine, J,2027339.980.000.000.0039.98
Murphy, Chase, J,2472958.980.000.000.0058.98
Alexander, Sarah,1941129.990.000.000.0029.99
Rivera, Hailey, R,2079239.980.000.000.0039.98
Moore, Hunter,14897196.270.000.0071.58124.69
Blue, Melanie, L,178611749.960.000.000.001749.96
Reed, Sean, L,145974803.310.000.000.004803.31
Ward, Emma, W,2179659.980.000.000.0059.98
Gray, Mariah,222787.280.000.007.280.00
Adams, Gabriel, S,195271219.450.000.000.001219.45
White, Emily, M,159174679.060.000.000.004679.06
Gill, Robyn, J,127651750.980.000.001750.980.00
Foster, Paige,2742894.480.000.000.0094.48
Alexander, Edward, E,18524195.950.000.000.00195.95
Coleman, Samuel, N,17450123.980.000.000.00123.98
Hayes, Jason,261764.990.000.000.004.99
Davis, Thomas,167641760.470.000.000.001760.47
Hayes, Dalton, C,188822322.280.000.000.002322.28
Malhotra, Brenda,133912405.470.000.000.002405.47
Butler, Dalton, A,133454759.510.000.000.004759.51
Reed, Melanie, A,28160574.980.000.000.00574.98
Washington, Emma,191231170.480.000.000.001170.48
Stewart, Alex, M,2008463.150.000.000.0063.15
Edwards, Hailey,242584.990.000.000.004.99
Ramos, Derrick,18449100.940.000.0030.9769.97
Young, Adam,12984200.200.000.00107.2692.94
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Gray, Isabella,168203217.790.000.000.003217.79
Peterson, Melissa, S,249954.990.000.004.990.00
King, Sara,2235439.980.000.000.0039.98
Foster, Carson, L,16959135.350.000.00120.3714.98
Martin, Joshua, A,276077.280.000.007.280.00
Turner, Mary,220154.990.000.000.004.99
Torres, Victoria,17551160.920.000.000.00160.92
Robinson, Ian, D,138522294.990.000.000.002294.99
Chandra, Allen,2932753.990.000.000.0053.99
Moore, Chloe, L,2626913.980.000.000.0013.98
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Nelson, Katherine,2802178.980.000.000.0078.98
Harris, Samantha, A,244874.990.000.000.004.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Ross, Seth, M,184332329.980.000.000.002329.98
Richardson, Evan, J,15488165.300.000.000.00165.30
Diaz, Trevor, B,2051954.960.000.000.0054.96
Lewis, Rachel, J,14900839.480.000.000.00839.48
Baker, Isaiah,12106169.540.000.000.00169.54
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Diaz, Jason,17374206.630.000.0089.46117.17
Green, Eric,2738069.990.000.000.0069.99
Phillips, Haley, B,2807939.980.000.000.0039.98
Russell, Richard,2763322.260.000.000.0022.26
Phillips, Andrea,1857383.740.000.000.0083.74
Cox, Sara, P,2775869.990.000.0069.990.00
Watson, Michelle, H,262352181.560.000.002181.560.00
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Van, Bobby,27757132.970.000.00132.970.00
Johnson, Andrew, F,262942443.350.000.002443.350.00
Henderson, Abigail,2044139.980.000.000.0039.98
Harris, Seth, M,161402528.330.000.002528.330.00
Thomas, Richard,27557782.990.000.00782.990.00
Martin, Samuel,15874225.440.000.0069.99155.45
Ma, Tiffany,2157739.980.000.000.0039.98
Patterson, Grace, M,27560782.990.000.00782.990.00
James, Maria,1624391.970.000.0069.9921.98
Henderson, Justin, P,235917.280.000.007.280.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Collins, Jonathan,16849119.980.000.000.00119.98
Garcia, Lucas,27545782.990.000.00782.990.00
Zhao, Karen, L,254082735.530.002181.560.00553.97
Hall, Wyatt,2382713.980.000.000.0013.98
Blue, Marcus, L,27550782.990.000.00782.990.00
Fernandez, Cesar,200355694.980.003374.990.002319.99
Flores, Luke, L,247337.280.000.000.007.28
Washington, Alexia,27613782.990.000.00782.990.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Johnson, Jonathan,220597.280.000.000.007.28
Jackson, Edward,290422420.340.000.002420.340.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Reed, Gabriella, A,2743778.980.000.000.0078.98
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Griffin, Madison, A,250932181.560.002181.560.000.00
Lal, Jack, R,185251735.980.000.000.001735.98
Long, Xavier,112512318.960.000.000.002318.96
Wood, Alexandria, M,248242181.560.002181.560.000.00
Zhang, Connor, R,138532329.980.000.000.002329.98
Watson, Shelby, J,14911867.970.000.000.00867.97
Hughes, Julia,250612443.350.002443.350.000.00
Gray, Sebastian, B,138782366.960.000.000.002366.96
Johnson, Ian, E,2173283.470.000.000.0083.47
Turner, Amanda, L,203183241.900.002071.420.001170.48
Walker, Jacob, N,29027574.980.000.000.00574.98
Morgan, Isabella, L,28602144.470.000.000.00144.47
Gomez, Renee, L,253712181.560.002181.560.000.00
Foster, Nicole, A,2349489.970.000.000.0089.97
Sharma, Samuel,27725119.980.000.000.00119.98
Clark, Anthony,27071782.990.00782.990.000.00
Howard, Danielle,28357133.490.000.000.00133.49
Williams, Ian, M,175581750.470.000.000.001750.47
Howard, Isaiah,259813018.330.002443.350.00574.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Martin, Madison, C,2049271.970.000.0071.970.00
Cook, Steven, J,27053782.990.00782.990.000.00
Long, Rachel,2828339.980.000.000.0039.98
Bryant, Samantha,18345115.470.000.000.00115.47
Chen, Jackson, S,270751371.950.00782.990.00588.96
Campbell, Timothy,2584513.980.000.000.0013.98
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Coleman, Lucas, A,27060782.990.00782.990.000.00
Morris, Alyssa,28072548.980.000.000.00548.98
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Kumar, Zachary,254334.990.000.000.004.99
Turner, Kaylee, M,16213154.540.000.000.00154.54
Butler, Trevor,2741569.990.000.0069.990.00
Parker, Blake,15008170.530.000.0074.9895.55
Coleman, Miguel, D,2740069.990.000.0069.990.00
Howard, Natalie,1349154.960.000.0014.9839.98
Wright, Jennifer,2650559.980.000.0059.980.00
Scott, Allison,14497804.480.000.000.00804.48
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Ashe, Alexis, S,194141145.480.000.000.001145.48
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Hernandez, Jamie,27283119.980.000.00119.980.00
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Morris, Seth,189592341.460.000.000.002341.46
Powell, Miranda, J,153044843.000.000.000.004843.00
Torres, Mackenzie,28153570.470.000.000.00570.47
Blue, Paige,2170313.980.000.000.0013.98
Alexander, Thomas,207607.280.000.000.007.28
Phillips, Kyle,12158202.200.000.000.00202.20
Lopez, Bailey, R,185571179.470.000.001179.470.00
Prasad, Donald,15413318.920.000.00123.98194.94
Wu, Randy, J,116472365.940.000.002365.940.00
Perez, Timothy, L,227304.990.000.000.004.99
Blue, Makayla,1900029.990.000.000.0029.99
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Yang, Aaron, C,2519654.980.000.000.0054.98
Cooper, Angela,195261179.470.000.000.001179.47
Lee, James, J,2881769.990.000.0069.990.00
Barnes, Ian, M,16106133.540.000.000.00133.54
Scott, Eric,282484.990.000.004.990.00
Taylor, Brianna,17027230.900.000.00145.4285.48
Hughes, Destiny, P,28027119.980.000.000.00119.98
Thomas, Edward, E,19147133.710.000.000.00133.71
Martin, Nicholas,233627.280.000.000.007.28
Bailey, Olivia,238924.990.000.000.004.99
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Stewart, Lucas, J,2934198.970.000.000.0098.97
Thomas, Zachary, D,28045119.980.000.000.00119.98
Patterson, Eric, A,2738478.980.000.000.0078.98
Roberts, Carlos,2319639.980.000.000.0039.98
Jai, Kevin,1983678.960.000.0038.9839.98
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77

Generated 2025-10-31 21:53:15.368 UTC