Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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% |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) | |||
Pivottable Dates | Excel Discussion (Misc queries) | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
PivotTable toolbar missing? | Setting up and Configuration of Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel |