Pivot Table Calculated Field: % of Subtotal

Question

I've created the above pivot table and no matter what I do I'm unable to create a calculated field in column D of the pivot table.  In cell D5 I am trying to get the percentage: C5/C8, In cell D6 I'm trying to get the percentage: C6/C8, etc.  I can calculate the percentages manually in column E above but why can't I get a formula to work inside the pivot table?  What am I doing wrong?

Thanks for your help.

Answer 1

You don't need a calculated field for that.

Add the Resolution field to the Values area a second time.

Click on the new field in the Values area and select Value Field Settings... from the popup menu.

Activate the Show Values As tab of the Value Field Settings dialog.

Select "% of Parent Row Total" from the "Show values as" dropdown.

Click OK.

Answer 2

HansV,

Thanks for taking the time to respond to my post.  Your instructions worked PERFECTLY.

Much appreciated,

full-count