% of subtotal in pivot Table

[Guest]

We have several complex pivot tables and are trying to get a % of the
subtotal instead of the total. We have infomation by state (the subtotal)
and want to know the % of dollars by state not the % of each bucket of total
of all the data. If this possible. We have tried calculated fields and
nothing seems to work. Thanks for any ideas.

 

[Debra Dalgleish]

There's no option to calculate the percent of a subtotal in a pivot
table. You could do the calculation outside of the PivotTable.

Or, create a second pivot table, based on the first one, and use the %
Of Column calculation to show the state percentages. There's an example
here:

http://www.contextures.com/xlPivot10.html

 

[Guest]

Thanks Debra. I will try the second pivot table option. I do wish they
could throw this in the next time they are updating, we would get a lot of
use out of it in my office.

Thanks again for your thought.

 

[Debra Dalgleish]

You're welcome. You can send suggestions to:

(e-mail address removed)

Put "Excel" in the subject line, so your suggestion will be forwarded to
the Excel product managers.