How to eliminate % totals
 

Hi,
In my PT, I have a field in the Column part which contains differen
types of data (from a DB).
For example, I have months results from Jan. to Dec. and % of colums
Vs column Y.
Now, given that I only use one field to include this data, I have th
issue that in the Subtotals and Totals I get the % column summed up.
I cannot eliminate the Sub or Totals because I need them to show in th
months.
How can I eliminate the problem of the % summing up?

I was thinking to conditional formatting, but I cannot say when Cell
is showing "Hide it", because the cells where the totals appear ar
variable in their position.

Thanks for any help
Ale

--
Message posted from http://www.ExcelForum.com