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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Mitchell, Maria, D,27404782.990.000.00782.990.00
Jones, Joshua,184012294.990.000.000.002294.99
Johnson, Edward, H,23279124.990.000.000.00124.99
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Flores, Brittany,169062359.980.000.000.002359.98
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Cox, Devin, C,134184768.050.000.000.004768.05
Brooks, Bryce,12061140.170.000.00112.2527.92
Phillips, Devin,18759112.060.000.000.00112.06
Diaz, Alyssa,139084715.330.000.000.004715.33
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Thomas, Richard,27557782.990.000.00782.990.00
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Hall, Kyle, J,1749169.970.000.000.0069.97
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Serrano, Albert, E,133284708.020.000.000.004708.02
Yuan, Carly,19839194.960.000.000.00194.96
Gonzales, Luis,15856116.250.000.0037.2778.98
Taylor, Zachary, M,27082782.990.000.00782.990.00
Kumar, Austin,204834400.060.000.002049.102350.96
Wilson, Christian,27085782.990.000.00782.990.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Cox, Julia, A,206703228.570.000.002049.101179.47
Phillips, Jack, R,259952443.350.000.002443.350.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Butler, Ana,260403018.330.000.002443.35574.98
Davis, Jasmine, M,265291549.420.000.001000.44548.98
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
Foster, Deb,215012661.400.000.002661.400.00
Simmons, Haley, T,262022749.320.000.002181.56567.76
Anderson, Destiny,12895336.650.000.0037.27299.38
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Patterson, Jeremy,130272319.260.000.000.002319.26
Clark, Miguel, D,169872414.990.000.000.002414.99
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Perry, Natalie,1712669.990.000.000.0069.99
Evans, Jesse,2191639.980.000.000.0039.98
Mitchell, Caleb, K,268064.990.000.000.004.99
Stewart, Grace, H,247737.280.000.000.007.28
Wright, Kyle,2371626.970.000.000.0026.97
King, Aaron, L,117394758.030.000.002359.982398.05
Bailey, Mariah, L,2724354.980.000.000.0054.98
Phillips, James, G,16846180.950.000.00123.9856.97
Reed, Marcus,14582111.790.000.0014.9896.81
Morgan, Marcus, W,289682.290.000.000.002.29
Barnes, Elizabeth, J,249397.280.000.000.007.28
Long, Sydney,279217.280.000.000.007.28
Baker, Sara, M,11827512.470.000.00148.47364.00
Bryant, Nathan,2145059.980.000.000.0059.98
Carter, Elijah,216182611.070.000.002611.070.00
Patterson, Grace, M,27560782.990.000.00782.990.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
King, Jordan, C,110202316.970.000.002316.970.00
Washington, Riley, L,185441155.480.000.001155.480.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Davis, Richard, R,15549574.980.000.00574.980.00
Sanders, Megan, A,15376136.240.000.000.00136.24
Kumar, Zachary,254334.990.000.000.004.99
Jackson, Edward,290422420.340.000.002420.340.00
Simmons, Jose,2464739.980.000.000.0039.98
Rogers, Jade, I,14332102.250.000.000.00102.25
Allen, Luke,113162349.980.000.002349.980.00
Alexander, Luke,290432447.050.000.002447.050.00
Thomas, Seth,14567161.280.000.0096.0765.21
Nelson, Kevin,1476584.970.000.000.0084.97
Ramirez, Ian,166783162.310.000.00742.352419.96
Howard, Natalie,1349154.960.000.0014.9839.98
Thompson, Tyler,2750269.990.000.0069.990.00
Thomas, Jessica,1684894.480.000.0094.480.00
Coleman, Luke, A,11723152.550.000.0069.9882.57
Evans, Kaylee,19642133.540.000.000.00133.54
Reed, Catherine, M,203807.280.000.000.007.28
Gomez, Rebekah,13486225.440.000.000.00225.44
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Russell, Ian, T,2474613.980.000.0013.980.00
Allen, Allison, A,1975737.270.000.000.0037.27
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Cook, Seth,2301064.470.000.000.0064.47
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Chow, Candice,1923260.960.000.000.0060.96
Russell, Elijah, M,118354772.300.000.002319.262453.04
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Wilson, Grace,17539205.920.000.000.00205.92
Rubio, Ruben, D,1887186.960.000.0086.960.00
Moore, Chloe, L,2626913.980.000.000.0013.98
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Harris, Samantha, A,244874.990.000.000.004.99
Perez, Timothy, L,227304.990.000.000.004.99
Washington, Hailey, S,2588559.980.000.000.0059.98
Griffin, Marcus,2075634.560.000.000.0034.56
Nelson, Sierra,161322459.620.000.002459.620.00
Hall, Jose, J,17601225.420.000.00155.4569.97
Diaz, Hailey, W,116932294.990.000.002294.990.00
Ramirez, Brian, M,116182369.960.000.002369.960.00
Henderson, Abigail,2044139.980.000.000.0039.98
Ward, Kaylee, A,244154.990.000.004.990.00
Wright, Carol, C,12928247.410.000.0033.98213.43
Nath, Kenneth, W,170372334.970.000.000.002334.97
Martin, Samuel,15874225.440.000.0069.99155.45
Sandberg, Chase,2190475.970.000.000.0075.97
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Stewart, Lucas, J,2934198.970.000.000.0098.97
Washington, Alexis,1978146.260.000.007.2838.98
Roberts, Rebecca,2800094.480.000.000.0094.48
Lewis, Isabella,2624267.930.000.000.0067.93
Roberts, Robert, R,1898656.970.000.0056.970.00
Smith, Lucas, P,1809064.910.000.000.0064.91
Lopez, Bailey, R,185571179.470.000.001179.470.00
Foster, Trevor, J,2896469.990.000.000.0069.99
Rodriguez, Destiny, J,227397.280.000.007.280.00
Foster, Antonio,12795108.540.000.0066.2642.28
Moreno, Lance, A,2922939.980.000.000.0039.98
Diaz, Katherine, P,115262376.960.000.002376.960.00
Hayes, Brittany,13941286.820.000.000.00286.82
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Edwards, Elijah, D,281577.280.000.000.007.28
Murphy, Maria,160113657.260.000.000.003657.26
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Kennedy, Bridget,2202639.980.000.000.0039.98
Anderson, David, A,2209761.960.000.0061.960.00
Flores, Kevin,15878225.920.000.0069.97155.95
Lee, James, J,2881769.990.000.0069.990.00
Alexander, Jordan,2141259.980.000.0059.980.00
Scott, Eric,282484.990.000.004.990.00
Ross, Jose,2744178.980.000.0078.980.00
Sharma, Kathryn,20740140.940.000.000.00140.94
Harris, Jacob, G,2367939.980.000.0039.980.00
Morgan, Isaiah,18978118.730.000.000.00118.73
Russell, Rachel, C,2158124.270.000.0024.270.00
Stewart, Amanda, M,1531094.440.000.000.0094.44
Martinez, Jonathan,1330366.250.000.000.0066.25
Li, Kevin, S,2518813.980.000.000.0013.98
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Brown, Anthony, J,19399151.430.000.000.00151.43
Chen, Luis, G,2125294.450.000.0094.450.00
Long, Chloe,167841735.980.000.000.001735.98
Brown, Julia,18065155.470.000.000.00155.47
Campbell, Gabriella,188411145.480.000.000.001145.48
Ward, Natalie, J,132412325.960.000.000.002325.96
Collins, Jose,2474839.980.000.0039.980.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Xu, Louis,2010466.530.000.0066.530.00
Young, Courtney,176222374.980.000.000.002374.98
Peterson, Steven, L,234497.280.000.007.280.00
Wang, Austin, A,1463284.970.000.009.9974.98
Jai, Samuel, L,1635887.950.000.0039.9947.96
Adams, Kyle, E,1881269.990.000.0069.990.00
Green, Gabriella, C,2803569.990.000.000.0069.99
Anderson, Daniel,20694146.970.000.00146.970.00
Cooper, Brianna,2592513.980.000.000.0013.98
Foster, Alyssa, I,14875839.480.000.000.00839.48
Smith, Alexandra,2829261.960.000.000.0061.96
Alexander, Julian,132172351.960.000.000.002351.96
Cox, Katelyn, B,2174230.970.000.000.0030.97
Alvarez, Melody,2507068.490.000.000.0068.49
Johnson, Anthony, D,270224.990.000.000.004.99
Lee, Kayla, M,2078115.230.000.000.0015.23
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Rogers, Bryce,174022304.980.000.000.002304.98
Flores, Hannah,1952540.230.000.000.0040.23
Sanders, Mason, G,2345939.980.000.000.0039.98
Wu, Randy, J,116472365.940.000.002365.940.00
Richardson, Charles, I,121144719.020.000.002325.962393.06
Martin, Noah, A,1765775.970.000.0075.970.00
Adams, Mason, T,2052864.470.000.0064.470.00
Martinez, Grace, M,17385208.690.000.0069.97138.72
Bryant, Dakota, L,176132401.950.000.000.002401.95
Taylor, Tyler, A,12032614.960.000.00614.960.00
Martin, Tyler, L,2772469.990.000.000.0069.99
Johnson, Xavier, R,2325539.980.000.0039.980.00
Blue, Melanie, L,178611749.960.000.000.001749.96
Rodriguez, Taylor,1607166.960.000.000.0066.96
Collins, Isaac,260777.280.000.000.007.28
Long, Sarah,173721729.970.000.000.001729.97
McDonald, Aaron, J,27734119.980.000.000.00119.98
Johnson, Cameron, R,137201155.480.000.000.001155.48
Thames, Bernard,2380368.490.000.000.0068.49
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Powell, Katherine, C,14574177.600.000.000.00177.60
Russell, Arianna,22728149.930.000.00149.930.00
Reed, Melanie, A,28160574.980.000.000.00574.98
Hall, Grace, A,201894.990.000.000.004.99
Adams, Julia, N,2607359.980.000.000.0059.98
Perry, Benjamin,291652407.040.000.002407.040.00
Edwards, Hailey,242584.990.000.000.004.99
Hill, Eric, G,2525667.930.000.0067.930.00
Smith, Megan, J,2671668.970.000.000.0068.97
Bryant, Rachel,220197.280.000.007.280.00
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Scott, Mason,2355139.980.000.000.0039.98
Gonzales, Jordan,2368113.980.000.000.0013.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Reed, Megan, A,181181750.980.000.000.001750.98
Robinson, William,20103103.480.000.000.00103.48
Roberts, Jordan, M,1680039.250.000.000.0039.25
Lewis, Ryan, A,203124.990.000.000.004.99
Russell, Gail, L,212634.990.000.000.004.99
Hughes, Luis,130841798.960.000.000.001798.96
Coleman, Stephanie,2226489.970.000.000.0089.97
Foster, Abigail,1982346.470.000.000.0046.47
Hall, Taylor, J,169951735.980.000.000.001735.98
Jones, Michael, A,2210771.970.000.000.0071.97
Wang, Benjamin, R,274547.280.000.000.007.28
Collins, Jonathan,16849119.980.000.000.00119.98
Hall, Wyatt,2382713.980.000.000.0013.98
Mitchell, Evan, R,247314.990.000.000.004.99
Flores, Luke, L,247337.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Bell, Chase,180911750.980.000.000.001750.98
Walker, Destiny, M,169961754.980.000.000.001754.98
Clark, Zachary, J,2389358.980.000.000.0058.98
Jones, Alexandra, B,2020245.950.000.000.0045.95
Garcia, Kayla, L,2130881.460.000.000.0081.46
Cooper, Brooke,195361120.490.000.000.001120.49
Foster, Jose, C,2878534.990.000.000.0034.99
Shan, Gabriel, T,2773169.990.000.000.0069.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Patterson, Austin, O,270247.280.000.000.007.28
Zhang, Connor, R,138532329.980.000.000.002329.98
Flores, Julian,158464943.320.000.000.004943.32
Walker, Jacob, N,29027574.980.000.000.00574.98
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Carter, Jonathan,14578848.470.000.000.00848.47
Kelly, Bailey, R,28284563.770.000.000.00563.77
Sanders, Lucas, W,268024.990.000.000.004.99
Miller, Destiny,251577.280.000.000.007.28
Washington, Adam, G,2543713.980.000.000.0013.98
Murphy, Brianna, K,2834269.990.000.000.0069.99
Miller, Jill,129142329.980.000.000.002329.98
Ross, David, M,171431763.970.000.000.001763.97
Anderson, Madison, G,2835978.980.000.000.0078.98
Turner, Mary,220154.990.000.000.004.99
Nelson, Katherine,2802178.980.000.000.0078.98
Nath, Alison, J,171161764.960.000.000.001764.96
Campbell, Natalie, L,115122319.990.000.000.002319.99
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Davis, Dylan,15556588.960.000.00588.960.00
Hayes, Logan, J,19026113.240.000.0037.2775.97
Hughes, Caroline, C,2830278.980.000.0078.980.00
Williams, Destiny, S,15881564.990.000.00564.990.00
Torres, Mackenzie,28153570.470.000.000.00570.47
Alexander, Thomas,207607.280.000.000.007.28

Generated 2025-11-04 07:33:31.052 UTC