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.

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
he

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

Tiffany C. wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote:

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
he

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

Tiffany C. wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome. You can send suggestions to:



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


Tiffany C. wrote:
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" wrote:


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
he

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

Tiffany C. wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html