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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot issue 4
Extract subtotals (averages) from Pivot Table 1
subtotals using COUNT 2
Pivot table subtotals 2
Pivot-Table - subtotals as % 1
Sorting Subtotals 1
Listing only sub totals in pivot table 1
pivot tabel subtotals 1

Top