Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can i hide parts of a Pivot tables subtotals???
Hi all,
I am wondering if there is a way to hide parts of a pivot tables subtotals. I have data in numerical form and percentage form. For the numerical data I would like to use the Sum function for the subtotal; and for the percentage data I would like to use the Average function for the subtotal. However I can not get one of each and end up with a summation of the percentage data which is meaningless. e.g. Data: numbers Data: percentages Subtotal1: sum(numbers) Subtotal1: sum(percentages) *** Subtotal2: Average(numbers) *** Subtotal2: Average(percentage) I wish to hide the lines with *** Thanks in advance for your help!! A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can i hide parts of a Pivot tables subtotals???
Excel 2007 accommodates dynamic
conditional formatting for PivotTables. See example he http://www.mediafire.com/file/znj3dnhmhtu/12_31_08.xlsx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can i hide parts of a Pivot tables subtotals???
On Dec 31 2008, 7:48*pm, Herbert Seidenberg
wrote: Excel 2007 accommodates dynamic conditional formatting for PivotTables. See example hehttp://www.mediafire.com/file/znj3dnhmhtu/12_31_08.xlsx thanks, but unfortunately I am using Excel 2003. Any other ideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentages of Subtotals for Pivot Tables | Excel Discussion (Misc queries) | |||
Formulas using Subtotals in Pivot Tables | Excel Discussion (Misc queries) | |||
Subtotals in Pivot Tables | Excel Worksheet Functions | |||
how do i only see subtotals in a pivot and hide the detail | Excel Worksheet Functions | |||
copying subtotals in Pivot tables | Excel Worksheet Functions |