Displaying a count as a percentage within subtotals in a pivot tab

  • Thread starter Thread starter jp
  • Start date Start date
J

jp

Excel 2007

I have a count field in a pivot table column that I want to display as a
percentage.

If I have no subtotals, the option "% of column" in Value Field settings
works great.

However if I add subtotals to the column and want the percentages to
calculate WITHIN SUBTOTALS as opposed to the whole column, I can't find an
option in the Value Field settings that does that (I tried "% Of" to no
avail).

Is this even doable?
 
Back
Top