Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot % or column tinkering
I have a need for a % of column calculation that does not do the entire
column, but rather does the sections of the vertical length defined by one of my row fields. In other words, I need 100% to appear at the break of each of a particular field. How do I do this, if at all? -- Boris |
#2
|
|||
|
|||
pivot % or column tinkering
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, move one of the row fields to the column area, and use the % Of Column calculation to show the percentages. There's an example he http://www.contextures.com/xlPivot10.html BorisS wrote: I have a need for a % of column calculation that does not do the entire column, but rather does the sections of the vertical length defined by one of my row fields. In other words, I need 100% to appear at the break of each of a particular field. How do I do this, if at all? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
pivot % or column tinkering
Debra, been a while, but we meet again. Thanks. I am not sure if this gets
me exactly to where I want to be, but there are some ideas that have been triggered in reading through that. -- Boris "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, move one of the row fields to the column area, and use the % Of Column calculation to show the percentages. There's an example he http://www.contextures.com/xlPivot10.html BorisS wrote: I have a need for a % of column calculation that does not do the entire column, but rather does the sections of the vertical length defined by one of my row fields. In other words, I need 100% to appear at the break of each of a particular field. How do I do this, if at all? -- 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 | |||
Need to Add Column to Data in Pivot Table | Charts and Charting in Excel | |||
refresh of pivot table clears fields (column headers) | Excel Discussion (Misc queries) | |||
Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
Pivot table column duplicates | Excel Discussion (Misc queries) | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) |