Help with “show values as % of row total”

Hi all,
I’m having difficulty to show values as % per row.
For example M3 should be calculated as percentage of =7/1151*100=0.608%

I will appreciate any help

Hi,

You need "Calculated Field" for this. Please see the attached file.

i'm not sure how you had added the fields?
Can you pls explain?
Thanks!

Hi,
Ignore.
Thanks!

BTW, can i change to all the fields in Pivot table the definition from count to average in one click?
Thanks

Please go through the following URL for details on adding a "Calculated Field" on to a Pivot Table.

http://www.contextures.com/excel-piv...tml#Calculated

You need to add one field at a time.