Pivottable %'s

J

jmenche

If I have nested row fields in pivottable, is there a way to get a "% of
parent" vs. just a "% of column"??
Sumof...
Parent A 100 100%
Child1 40 40% <====
Child2 60 60%
Parent B 200 100%
Child3 100 50%
Child4 100 50%
 
D

Debra Dalgleish

You can't get a % of subtotal in a pivot table.

If you put Parent in the Column area, and Child in the Row area, you
could use % of Column.
 

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

Top