Can i hide parts of a Pivot tables subtotals???

[alan82]

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

 

[Herbert Seidenberg]

Excel 2007 accommodates dynamic
conditional formatting for PivotTables.
See example here:
http://www.mediafire.com/file/znj3dnhmhtu/12_31_08.xlsx

 

[alan82]

Excel 2007 accommodates dynamic
conditional formatting for PivotTables.
See example here:http://www.mediafire.com/file/znj3dnhmhtu/12_31_08.xlsx

thanks, but unfortunately I am using Excel 2003. Any other ideas???