Excel Pivot "% of" sub-total is misleading - how to change

[reemas]

Any way to get the subtotals per year to show 100%? They add up to 100% but display as a % of the total of all 3 years.

I'm trying to avoid copy/pasting values/formats and would like to achieve this in the pivot if possible. Or I'd like to hide just this sub-total, not the whole row.

https://photos-3.dropbox.com/t/2/AAD...60&size_mode=2

[tuph]

Please attach a copy of your workbook so we can work on solutions looking at the actual problem. Remember to remove/replace sensitive data before uploading the file.

[VKS]

Hi, Try this

Click and right click on the value field column

Go to value field setting
Click show value as tab
Select % of parent row total

I guess this should help.

VKS