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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2023202420252026
Jai, Edwin,169211754.980.000.001754.980.00
Luo, Donna, E,248054.990.000.004.990.00
Scott, Adam,15863243.010.000.00171.4371.58
Gonzales, Miranda,11660324.720.000.00200.74123.98
Henderson, Ashley,111851381.370.000.00350.911030.46
Tang, Carl,2123832.270.000.0032.270.00
Cooper, Ariana,17348205.420.000.0084.96120.46
Brooks, Mariah,216202620.400.000.002620.400.00
Gonzales, Ashley, C,1860051.970.000.0021.9829.99
White, Edward, J,15847205.460.000.00119.9885.48
Alexander, Luke,290432447.050.000.002447.050.00
Alexander, Aidan,17387148.190.000.00148.190.00
Peterson, Christina,2897694.480.000.0094.480.00
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Perez, Dalton,110911125.360.000.00471.29654.07
Harris, Matthew,14330806.760.000.00806.760.00
Stewart, Amanda, M,1531094.440.000.0059.5534.89
Torres, Pedro, E,16958168.020.000.00168.020.00
Sun, Arturo, C,11498557.540.000.00321.57235.97
Smith, Austin,13707149.050.000.000.00149.05
Russell, Samantha,11211723.560.000.00369.40354.16
Young, Kaylee, S,13756298.490.000.00298.490.00
Evans, Connor, J,15402131.550.000.0074.9856.57
Butler, Victoria,132844767.530.000.004767.530.00
Barnes, Emily, G,15996564.990.000.00564.990.00
Garcia, Patricia,11651226.430.000.00204.9421.49
Morris, Abigail, C,287762.290.000.000.002.29
Brown, Nicholas, S,11506675.640.000.00401.27274.37
Roberts, Hunter,282607.280.000.007.280.00
Dominguez, Meghan,14370122.560.000.000.00122.56
Jenkins, Samantha,113311290.330.000.00822.35467.98
Rowe, Todd,14586233.940.000.000.00233.94
Rogers, Carlos,19645134.440.000.00134.440.00
Thompson, Ryan, M,113301111.360.000.00623.78487.58
Kennedy, Bridget,2202639.980.000.000.0039.98
Flores, Emily,13206163.190.000.0069.9793.22
Bell, Christina,2609939.980.000.0039.980.00
Allen, Allison, A,1975737.270.000.0032.284.99
Walker, Charles,11677298.210.000.0021.49276.72
Watson, Marcus,2271585.480.000.0085.480.00
Barnes, Dalton, C,178581700.990.000.000.001700.99
King, Morgan,196811179.970.000.000.001179.97
Phillips, Jackson, D,233785317.230.003578.271738.960.00
Green, Marcus, C,15974208.410.000.0091.95116.46
Chandra, Brandy, P,11501603.530.000.00128.21475.32
Bailey, Jessica, L,12945218.440.000.0049.97168.47
Martinez, Andrew, C,11530523.810.000.00327.08196.73
Reed, Erin, I,14353128.840.000.00128.840.00
Hernandez, Jonathan, J,1901465.950.000.0030.9734.98
Hayes, Logan, J,19026113.240.000.0037.2775.97
Russell, Jacqueline,18391100.960.000.00100.960.00
Rubio, Kellie,27653128.970.000.00128.970.00
Hayes, Luis,12880200.730.000.0037.27163.46
Wilson, Tyler, L,15879196.930.000.00126.9669.97
Turner, Morgan,11823178.470.000.0063.96114.51
Gonzales, Luis,15856116.250.000.00116.250.00
Garcia, Cameron,186411120.490.000.001120.490.00
Murphy, Chase, J,2472958.980.000.0058.980.00
Davis, Daniel,11711999.220.000.00330.95668.27
Griffin, Julian, M,113284718.040.000.004718.040.00
Kelly, Angel, E,15418232.230.000.00232.230.00
Martinez, Carol, D,17656578.460.000.000.00578.46
Yang, Thomas, A,14108839.480.000.00839.480.00
Davis, Ethan,136604750.010.000.002351.962398.05
Campbell, Hailey,15507267.840.000.00228.9638.88
Roberts, Thomas, J,219394163.243578.270.00584.970.00
Suri, Carolyn, S,12972175.710.000.0098.4577.26
Powell, Jasmine, A,11505846.770.000.00626.65220.12
Miller, Alexis, A,12196124.930.000.0054.9669.97
Kelly, Haley,15511128.560.000.00128.560.00
Price, Lauren, J,14079184.740.000.00115.7768.97
Walker, John, M,2858969.990.000.0069.990.00
Davis, Thomas,167641760.470.000.001760.470.00
Roberts, Mason, D,111761106.680.000.00693.99412.69
Perry, Ana,112151155.520.000.00839.29316.23
Wright, Carol, C,12928247.410.000.00128.46118.95
Diaz, Luis, D,11203801.770.000.00469.77332.00
Suarez, Juan, R,167631700.990.000.001700.990.00
Butler, Dalton, A,133454759.510.000.004759.510.00
Brown, Jonathan,11875265.420.000.00100.47164.95
Yang, Justin, S,153634719.040.000.002334.972384.07
Stewart, Alex, M,2008463.150.000.0038.8824.27
Smith, Chloe,17619163.920.000.0071.9791.95
Townsend, Bryan,14077180.730.000.000.00180.73
Yuan, Leonard, F,167911729.970.000.001729.970.00
Morgan, Jada, A,11520702.990.000.00425.30277.69
Jones, Nicole,14504112.270.000.000.00112.27
Jai, Samuel, L,1635887.950.000.0083.963.99
Griffin, Miguel,2146476.970.000.000.0076.97
Davis, Nicholas,1320173.160.000.000.0073.16
Torres, Xavier,16840176.950.000.00176.950.00
Diaz, Jason,17374206.630.000.00167.3839.25
Perez, Angel, S,213362628.350.000.002628.350.00
Green, Mackenzie, C,280737.280.000.007.280.00
Adams, Carlos,1982236.960.000.0036.960.00
Ross, Natalie, J,12916261.220.000.0068.97192.25
Coleman, Logan,1868691.950.000.0069.9721.98
Washington, Emma,191231170.480.000.001170.480.00
Russell, Isabella, A,11507645.780.000.00278.85366.93
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Garcia, Christian, J,164913106.330.000.00751.342354.99
Wright, Jackson,11698225.950.000.00204.4621.49
Foster, Samuel, M,18523160.940.000.00128.9731.97
Prasad, Donald,15413318.920.000.00198.96119.96
Hughes, Samantha,2721564.470.000.000.0064.47
Hill, Jordan, J,16005198.730.000.00102.2796.46
Perez, Timothy, L,227304.990.000.000.004.99
Stewart, Grace, H,247737.280.000.007.280.00
Walker, Jasmine,134604693.040.000.002294.992398.05
Gomez, Rebekah,13486225.440.000.00104.96120.48
Isla, Julian, A,13732108.960.000.0073.9635.00
Henderson, Logan, C,2236656.970.000.000.0056.97
Flores, Caleb, S,12165280.640.000.00280.640.00
Griffin, Jennifer, B,14244154.960.000.0069.9984.97
Sanchez, Jared, J,2585064.470.000.0064.470.00
Peterson, Julia, P,16497132.710.000.0048.9683.75
Barnes, Fernando,113001390.550.000.00480.17910.38
Phillips, Andrea,1857383.740.000.0083.740.00
Jenkins, Alexandra, D,11632924.610.000.00549.40375.21
Reed, Marcus,14582111.790.000.0061.8149.98
Hu, Gilbert, L,2876769.990.000.0069.990.00
Lee, Emma,16948176.430.000.00176.430.00
Robinson, Sarah, A,2702859.980.000.0059.980.00
Lee, William,13185149.840.000.00117.2432.60
Griffin, Marcus,2075634.560.000.000.0034.56
Lewis, Isabella,2624267.930.000.0067.930.00
Carter, Isaac,137191129.480.000.001129.480.00
Bell, Julia,216522646.060.000.002646.060.00
Smith, Lucas, P,1809064.910.000.0064.910.00
Lal, Kyle,17360122.180.000.0035.2386.95
Edwards, Logan,250024.990.000.004.990.00
Lopez, Katelyn,11820232.710.000.00127.74104.97
Simmons, Jennifer,112621010.560.000.00488.15522.41
Simmons, Sarah, V,11500651.980.000.00155.22496.76
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Hall, Fernando,2210090.950.000.000.0090.95
Thomas, Jessica,1684894.480.000.0094.480.00
Peterson, Jared,11502829.370.000.00446.84382.53
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Jai, Jose,12944164.210.000.0086.2577.96
Ross, Alexia, S,13231247.900.000.00104.97142.93
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Martin, Madison, C,2049271.970.000.0071.970.00
Green, Blake, P,11719287.200.000.00224.9262.28
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Martin, Gina, E,11078793.270.000.00480.26313.01
Ramirez, Sydney,267007.280.000.007.280.00
Walker, Isabella,243864143.740.003578.27565.470.00
Hughes, Morgan, T,11642392.890.000.00193.93198.96
Davis, James,11922275.500.000.00131.55143.95
Prasad, Molly,243924329.610.003578.27751.340.00
Miller, Eduardo,14561158.840.000.0049.97108.87
Lal, Luke, L,11019698.230.000.00305.18393.05
Garcia, Brandon, V,244184329.610.003578.27751.340.00
Watson, Olivia, S,1386093.850.000.0054.9738.88
Harris, Emily, P,1986298.480.000.004.9993.49
Fernandez, Cesar,200355694.980.003374.990.002319.99
Jackson, Charles, P,112771305.660.000.00790.61515.05
Green, Gabriella, C,2803569.990.000.0069.990.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Moore, Taylor, A,199874564.453374.990.001189.460.00
Smith, Alexandra,2829261.960.000.0061.960.00
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Richardson, Nathaniel,120894710.030.000.004710.030.00
Hall, Amber,20106131.950.000.00131.950.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Morgan, Andrea, M,16870149.040.000.00149.040.00
Flores, Logan, K,14631848.470.000.000.00848.47
Richardson, Victoria, C,248172181.560.002181.560.000.00
Ramos, Derrick,18449100.940.000.00100.940.00
Ward, Angela, M,2775669.990.000.000.0069.99
Gray, Brianna,249603008.820.002443.35565.470.00
Powell, Katherine, C,14574177.600.000.00138.7238.88
Yang, Jordan, K,14458133.950.000.000.00133.95
Sanders, Paige,252872983.340.002443.35539.990.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Young, Julia, J,274144.990.000.000.004.99
Jai, Adam,250952443.350.002443.350.000.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Ross, Haley, T,253612443.350.002443.350.000.00
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
Morris, Paige, W,220414167.233578.270.000.00588.96
Gray, Alexandria, E,253632443.350.002443.350.000.00
Rodriguez, Morgan,237304828.110.003578.271249.840.00
Zukowski, Jake,220584118.263578.270.000.00539.99
Lazecky, Petr,258642443.350.002443.350.000.00
Rodriguez, Anthony, G,238294802.110.003578.271223.840.00
Reed, Paige,221126047.323578.270.002469.050.00
Price, Stephanie,258922443.350.002443.350.000.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Powell, Vanessa,26630699.10699.100.000.000.00
Henderson, Jackson, A,221215997.333578.270.002419.060.00
Smith, John,198555709.963399.990.000.002309.97
Brown, Isabella, L,266921266.86699.100.000.00567.76
Collins, Luis, J,227655978.613578.270.000.002400.34
Turner, Courtney, A,229753578.273578.270.000.000.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Miller, Chloe, V,228936056.510.003578.272478.240.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Long, Jordan,199884555.470.003399.990.001155.48
Flores, Megan, N,230746021.820.003578.270.002443.55
Powell, Elijah, E,231135997.330.003578.270.002419.06
Thompson, Ethan,199894495.480.003374.990.001120.49
James, Juan,232674862.090.003578.271283.820.00
Diaz, Elijah,200004495.480.003374.990.001120.49
Ware, Dennis, L,237254828.110.003578.271249.840.00
Bryant, Connor,238424828.110.003578.270.001249.84
Rodriguez, Joshua, A,235114843.110.003578.271264.840.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Campbell, Evan, W,243424828.110.003578.270.001249.84
Martinez, Jill,242354829.390.003578.270.001251.12
Allen, Aaron, A,200753399.990.003399.990.000.00
Mitchell, Katelyn, A,244964349.610.003578.27771.340.00
Ross, Elizabeth, E,141184741.340.000.002322.282419.06
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Diaz, Luke,12054402.530.000.00139.97262.56
Bennett, Maria, G,229837.280.000.000.007.28
Griffin, Jordan,13095328.890.000.0069.97258.92
Roberts, Amber, W,215822638.060.000.002638.060.00
Hayes, Brittany,13941286.820.000.0038.88247.94
Rodriguez, Lucas, P,15942191.870.000.0069.99121.88
Long, Brandon, M,16110650.470.000.000.00650.47
Brooks, Lucas, S,16089342.030.000.00180.98161.05
Moore, Andrew, A,13944150.130.000.00107.8542.28
Parker, Morgan, S,1677236.960.000.0014.9821.98
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Robinson, William,20103103.480.000.00103.480.00
Deng, Damien, A,16873578.460.000.000.00578.46
Bell, Danielle,140414765.020.000.002351.962413.06
Perez, Jordan, A,292674.990.000.000.004.99
Price, Riley, R,139094764.020.000.002344.962419.06
Parker, Blake,15008170.530.000.0074.9895.55
Hall, Noah, A,1525175.250.000.0068.976.28
Thomas, Emily,2180339.980.000.000.0039.98
Thomas, Victoria, A,15536249.530.000.000.00249.53
Washington, Elijah, L,250164.990.000.000.004.99
Walker, Emma, M,2520998.960.000.000.0098.96
Hernandez, Marcus,185952329.990.000.000.002329.99
Brown, Benjamin, D,151874725.320.000.002304.982420.34
Washington, Alexandra, E,15498256.520.000.00223.9232.60
Parker, Katherine,13268289.700.000.0068.97220.73
Diaz, Thomas, O,16020595.960.000.00595.960.00
Rodriguez, Alexis, L,15244179.190.000.00125.2353.96
Jai, Kevin,1983678.960.000.0038.9839.98
Turner, Amanda, L,203183241.900.002071.420.001170.48
Perez, Kaitlyn, A,120812366.960.000.002366.960.00
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77

Generated 2026-07-21 19:50:36.224 UTC