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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Russell, Nicole, M,182372318.960.000.000.002318.96
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Patterson, Jeremy,130272319.260.000.000.002319.26
Wilson, Emily,174002331.950.000.000.002331.95
Serrano, Albert, E,133284708.020.000.000.004708.02
Thames, Bernard,2380368.490.000.000.0068.49
Robinson, Julia,28121119.980.000.000.00119.98
Patterson, Grace, M,27560782.990.000.00782.990.00
Howard, Danielle,28357133.490.000.000.00133.49
Simmons, Nicole, S,2617729.480.000.000.0029.48
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Gomez, Krista,12760273.180.000.0036.27236.91
Barnes, Jeremy,2144654.980.000.000.0054.98
Jackson, Edward,290422420.340.000.002420.340.00
Clark, Joseph, D,153954780.020.000.000.004780.02
Lal, Jack, R,185251735.980.000.000.001735.98
Martinez, Matthew, L,16009170.450.000.000.00170.45
Turner, Andrea, A,202093268.550.002049.100.001219.45
Turner, Morgan,11823178.470.000.000.00178.47
Collins, Eduardo,139872329.990.000.000.002329.99
Collins, Xavier, C,16646250.910.000.000.00250.91
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Harris, Edward,27062782.990.000.00782.990.00
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Martinez, Jill,242354829.390.003578.270.001251.12
Miller, Sydney, A,134404818.530.000.000.004818.53
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Rivera, Allison, M,13751224.910.000.000.00224.91
Hall, Taylor, J,169951735.980.000.000.001735.98
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Edwards, Alexandra,133582386.940.000.000.002386.94
Williams, Austin,2035432.220.000.000.0032.22
Chen, Ethan,2054756.970.000.000.0056.97
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Simmons, David, E,120172339.970.000.002339.970.00
Jai, Edwin,169211754.980.000.000.001754.98
Gomez, Renee, L,253712181.560.002181.560.000.00
Morris, Mason, J,22349124.990.000.000.00124.99
White, Jennifer, S,27027782.990.00782.990.000.00
Martin, Christian, V,19709197.250.000.000.00197.25
Washington, Alexia,27613782.990.000.00782.990.00
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Williams, Destiny, S,15881564.990.000.00564.990.00
Martin, Tyler, L,2772469.990.000.000.0069.99
Alexander, Edward, E,18524195.950.000.000.00195.95
Stewart, Olivia, B,1874923.780.000.000.0023.78
Hayes, Hannah, J,2165656.970.000.000.0056.97
Diaz, Richard, A,2668264.470.000.000.0064.47
Walker, Jasmine,134604693.040.000.000.004693.04
Ramirez, Ian,166783162.310.000.00742.352419.96
Smith, Hannah, J,2526554.980.000.0054.980.00
Brown, Dalton, N,218134118.263578.270.000.00539.99
Carter, Bailey,213322616.860.000.002616.860.00
Bradley, Jocelyn,230227.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Lee, Don,188392384.970.000.000.002384.97
Li, Connor,201863191.910.002071.420.001120.49
Flores, Stephanie,259922721.550.000.002181.56539.99
Suri, Carolyn, S,12972175.710.000.000.00175.71
Henderson, Justin, P,235917.280.000.000.007.28
Reed, Megan, A,181181750.980.000.000.001750.98
Jai, Samuel, L,1635887.950.000.0039.9947.96
Alvarez, Melody,2507068.490.000.000.0068.49
Wilson, Madison, H,1982821.980.000.000.0021.98
Griffin, Maria,1840763.250.000.000.0063.25
Ross, Haley, T,253612443.350.002443.350.000.00
Patterson, Maria, G,1333094.950.000.000.0094.95
Coleman, Stephanie,2226489.970.000.000.0089.97
Sanders, Angel,16219553.970.000.000.00553.97
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Coleman, Ashley,27297782.990.000.00782.990.00
Blanco, Armando, F,139182397.950.000.000.002397.95
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Reed, Paige,221126047.323578.270.002469.050.00
Gomez, Rebekah,13486225.440.000.000.00225.44
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Martin, John, A,144364776.010.000.000.004776.01
Hall, Eduardo,16847189.940.000.000.00189.94
Taylor, Taylor,159054899.020.000.000.004899.02
Reed, Sean, L,145974803.310.000.000.004803.31
Morris, Chase, F,26789699.100.00699.100.000.00
Brown, Christian,227554.990.000.000.004.99
Collins, Hailey,11709325.890.000.0021.49304.40
Flores, Arianna,217274132.243578.270.000.00553.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Walker, Emma, M,2520998.960.000.000.0098.96
James, Jeremiah, S,11661287.700.000.000.00287.70
Garcia, Xavier, M,2030071.970.000.000.0071.97
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Simmons, Jose,2464739.980.000.000.0039.98
Campbell, Gabriella,188411145.480.000.000.001145.48
King, Sara,2235439.980.000.000.0039.98
Russell, Richard,2763322.260.000.000.0022.26
Nelson, Sean,11841307.970.000.000.00307.97
Thomas, Jeremiah,183721760.470.000.000.001760.47
Davis, Marcus, T,17337123.910.000.0086.9536.96
Price, Nicole, N,15815141.830.000.000.00141.83
Butler, Jonathan,261804.990.000.000.004.99
Cook, Joan,235544.990.000.000.004.99
Diaz, Hunter, S,27242782.990.000.00782.990.00
Richardson, Victoria, C,248172181.560.002181.560.000.00
Baker, Isaiah,12106169.540.000.000.00169.54
Hayes, Arianna,259912845.520.000.002181.56663.96
Phillips, Devin,18759112.060.000.000.00112.06
Roberts, Wyatt,15900699.970.000.00699.970.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Young, Courtney,176222374.980.000.000.002374.98
Allen, Madeline,2924068.970.000.000.0068.97
Murphy, Chase, J,2472958.980.000.000.0058.98
Blue, Marcus, L,27550782.990.000.00782.990.00
Edwards, Madeline,2077146.470.000.000.0046.47
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Ross, Anna, D,15494275.440.000.0029.99245.45
Gonzales, Jose,2201439.980.000.000.0039.98
Edwards, Angel, J,2912469.990.000.000.0069.99
Moore, Fernando,265821000.440.000.001000.440.00
Williams, Zachary, B,27099782.990.000.00782.990.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Butler, Victoria,132844767.530.000.000.004767.53
Price, Jocelyn, D,258752443.350.002443.350.000.00
Nelson, Jordan, H,201304.990.000.004.990.00
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Alexander, Nathan, A,187951198.970.000.000.001198.97
Hughes, Destiny, P,28027119.980.000.000.00119.98
Garcia, Isabella,18382204.940.000.000.00204.94
Hughes, Luis,130841798.960.000.000.001798.96
Isla, Julian, A,13732108.960.000.004.99103.97
Roberts, Mason, D,111761106.680.000.00494.64612.04
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Bryant, Samantha,18345115.470.000.000.00115.47
Stewart, Grace, H,247737.280.000.000.007.28
Walker, Destiny, M,169961754.980.000.000.001754.98
Hall, Kyle, J,1749169.970.000.000.0069.97
Martinez, Kristina, S,2134529.930.000.000.0029.93
Washington, Victoria,235577.280.000.000.007.28
Ward, Angela, M,2775669.990.000.000.0069.99
Murphy, Dalton, N,27043782.990.00782.990.000.00
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Reed, Isaac, D,260747.280.000.000.007.28
Brooks, Steven, C,14877889.470.000.000.00889.47
Coleman, Lucas, A,27060782.990.00782.990.000.00
Jones, Alexandra, B,2020245.950.000.000.0045.95
Davis, James,11922275.500.000.0034.98240.52
Clark, Destiny, L,28600119.980.000.000.00119.98
Alexander, Ryan, J,14078839.480.000.00839.480.00
She, Kenneth,16096212.010.000.0080.96131.05
Murphy, Emma,198445807.930.003374.990.002432.94
Murphy, Juan, T,246463578.270.003578.270.000.00
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Scott, Mason,2355139.980.000.000.0039.98
Taylor, Lucas, V,115232376.960.000.002376.960.00
Price, Mariah, C,2074549.480.000.000.0049.48
Thompson, Abigail,243324816.090.003578.270.001237.82
Sanders, Paige,252872983.340.002443.350.00539.99
Moore, Logan,2634889.970.000.0089.970.00
Sanchez, Rachel, C,267304.990.000.000.004.99
Bryant, Connor,238424828.110.003578.270.001249.84
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Washington, Riley, L,185441155.480.000.001155.480.00
Taylor, Brianna,17027230.900.000.00145.4285.48
Morgan, Brianna, D,111362380.470.000.002380.470.00
Alexander, Paige, W,1860459.250.000.0037.2721.98
Taylor, Zachary, M,27082782.990.000.00782.990.00
Phillips, Kaylee,211384371.380.000.002049.102322.28
Rogers, Sean, G,18685124.460.000.000.00124.46
Hill, Eric, G,2525667.930.000.0067.930.00
Roberts, Carlos,2319639.980.000.000.0039.98
Lal, Robert, L,14084138.680.000.000.00138.68
Price, Rachel, D,2532889.970.000.000.0089.97
Thomas, Edward, E,19147133.710.000.000.00133.71
Harris, Noah,292562393.060.000.002393.060.00
Ortega, Javier, P,127852294.990.000.000.002294.99
Lewis, Seth,26782699.100.00699.100.000.00
Hall, Charles,234764.990.000.000.004.99
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Patterson, Nicole,1972937.270.000.000.0037.27
Henderson, Ashley,111851381.370.000.00232.801148.57
Lee, Kayla, M,2078115.230.000.000.0015.23
Hayes, Logan, J,19026113.240.000.0037.2775.97
Thomas, Ian,191181120.490.000.000.001120.49
Hall, Noah, A,1525175.250.000.000.0075.25
Ward, Destiny,16128539.990.000.000.00539.99
Gray, Cindy, A,13198114.950.000.0099.9714.98
Howard, Morgan, T,229713578.270.003578.270.000.00
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Foster, Jose, C,2878534.990.000.000.0034.99
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Rogers, Sara,198744544.450.003374.990.001169.46
Peterson, Jared,11502829.370.000.00171.95657.42
Perry, Eric,18314115.730.000.0056.9758.76
Bradley, Melanie, G,133434720.270.000.000.004720.27
Robinson, Ian, D,138522294.990.000.000.002294.99
Rubio, Ruben, D,1887186.960.000.0086.960.00
Peterson, Alex, M,13423132.900.000.000.00132.90
Rogers, Andrea, L,14328308.660.000.00112.95195.71
Young, Sierra, J,11619634.840.000.0034.99599.85
Simmons, Anna, K,124512367.920.000.000.002367.92
Russell, Samuel, V,11652310.930.000.000.00310.93
Gonzales, Luis,15856116.250.000.0037.2778.98
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Gill, Beth,199975814.980.003374.990.002439.99
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Griffin, Marcus,2075634.560.000.000.0034.56
Hughes, Antonio, P,15913712.270.000.00712.270.00
Lal, Luke, L,11019698.230.000.00139.93558.30
Simmons, Jennifer,112621010.560.000.00207.93802.63
Harris, Joshua, L,2028095.940.000.0030.9764.97
Ward, Mariah, J,2158044.910.000.000.0044.91
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Turner, James, E,16841126.960.000.0069.9956.97
Moreno, Renee, C,12936265.220.000.000.00265.22
Reed, Mariah,263731565.910.000.001000.44565.47
Gray, Sebastian, B,138782366.960.000.000.002366.96
White, Abigail, T,15866145.820.000.0038.88106.94
Price, Devin, M,18758158.510.000.0073.5584.96
Shan, Gabriel, T,2773169.990.000.000.0069.99
Clark, Zachary, J,2389358.980.000.000.0058.98
Stewart, Alex, M,2008463.150.000.000.0063.15
Thomas, Isabella, M,27265782.990.000.00782.990.00
Morris, Haley, A,2354848.970.000.000.0048.97
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Green, Chloe, J,1465892.820.000.000.0092.82
Bell, Gabrielle,223735976.320.003578.270.002398.05
Blanco, Randall,263211554.410.000.001000.44553.97
Johnson, Christopher,119794813.760.000.002352.212461.55
Harris, Jacob, G,2367939.980.000.0039.980.00
Foster, Samuel, M,18523160.940.000.00128.9731.97
Lee, William,13185149.840.000.0069.9779.87
Thompson, Ethan,199894495.480.003374.990.001120.49
Zeng, Jake,18054106.930.000.000.00106.93
Washington, Ian, M,246644368.580.003578.270.00790.31
Hughes, Stephanie,263161000.440.001000.440.000.00
Stewart, Cindy,14496804.480.000.000.00804.48
Harris, Megan,232814828.110.003578.271249.840.00
Watson, Erin, B,227724.990.000.004.990.00
Patterson, Natalie,16123629.970.000.000.00629.97
Mehta, Carmen, C,2743694.480.000.000.0094.48
Peterson, Brian,12892419.470.000.00156.27263.20
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Ward, Jade, D,14661195.020.000.000.00195.02
Sanders, Sean,14341175.150.000.000.00175.15
Ross, Alexia, S,13231247.900.000.000.00247.90
Wang, Zachary,2214489.970.000.000.0089.97
Peterson, Xavier, R,2645639.980.000.000.0039.98
White, Emma, N,16090604.960.000.000.00604.96
Richardson, Evan, J,15488165.300.000.000.00165.30
Green, Xavier,2356739.980.000.000.0039.98
Wood, Gavin,16964108.540.000.0093.5614.98
Gonzalez, Morgan,130651700.990.000.000.001700.99
Parker, James,11808610.190.000.00186.77423.42

Generated 2025-11-03 22:43:26.985 UTC