Pivottable %'s
 

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%

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.

jmenche wrote:
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%


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html