Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
Hi there
I want to calculate % of subtotals in a Pivot Table - I have a column where I calculated the % of Total turnover but also want to have the % of subsector totals. Name Name1 Sum of Number % of Sector A A 1 ? A1 2 ? A2 3 ? A Total 6 100% B B1 1 ? B2 2 ? B Total 3 100% |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
There's no calculation to show percent of subtotal. Perhaps you could
put Name1in the row area, and Name in the column area. Then, add a second copy of Number to the data area, and change it to % of Column, as shown he http://www.contextures.com/xlPivot10.html Amanda wrote: Hi there I want to calculate % of subtotals in a Pivot Table - I have a column where I calculated the % of Total turnover but also want to have the % of subsector totals. Name Name1 Sum of Number % of Sector A A 1 ? A1 2 ? A2 3 ? A Total 6 100% B B1 1 ? B2 2 ? B Total 3 100% -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |