Need to show percentage in a table display as per defined column

[Vish24]

Hello, I have a data table (Named - Goal) with 10 names and their goals and in separate data table(Named-AllSales) I have all sales done by those 10 people over the years.  I am making a table display in my report where I want to show the column with % of sales achcieved as per the goals. Like: 

Name    Goal    Total Sales   %Sales Achieved

A           100           10                   10%

B             80          40                       50%

C            120         90                      75%

I have made the name,goal,and total sales but I am not getting how to do the %.

Please suggest!

Thank you!

[mwegener · Accepted solution]

Hi @Vish24 ,

create a Measure and set the format to percentage.

%Sales Achieved = DIVIDE(SUM(Table[Total Sales]),SUM(Table[Goal]))

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support. 

[Vish24]

Thank you so much! It worked perfectly.