Show Percentage in Pivot table

[yashcena]

I have the following data in my data model:

I have created a pivot chart:

I want to add one more expression which will show percentage of hours spent on each project.

For AA, time spent on P1 is 20/100=20%, on P2 is 40/100=40%.

What expression should I use to show percentage? There is relative option for expressions in Pie-chart. I was wondering if we have a similar option in Pivot Tables. i have attached a sample app here.

[sunny_talwar · Accepted solution]

Try this expression

Sum(Hours)/Sum(TOTAL <[Resource Name]>Hours)

[yashcena]

Thanks Sunny...it worked!