% of subtotal in pivot Table

T

Tiffany C.

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.
 
D

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
 
T

Tiffany C.

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.
 
Top