Show values only in a pivot table

[ymze]

I have a pivottable based on a small database downloading figures from
the master database each month. To ensure that all figures are included
every month I need to include all combinations (accounts, Cost Centers
etc). Several of this combinations might be zero, and it it also shows
zero in the Pivot table. This makes the pivot table big and filled with
a lot of useless information. Is it possible in a pivottable to only
show figures with a value different from zero?


Thanks for your help

Brgds


Knut

 

[William]

Hi

You could format the "databodyrange" within the pivot table using something
like [>0]#,##0_ ;[Red][<0](#,##0);

Or
Remove all zeros from the source data (Edit / Replace, etc) and from the
"Table Options" of the pivot table ensure there is no check mark against
"For empty cells show..."
--


XL2003
Regards

William
(e-mail address removed)

 

[ymze]

Thanks for the tip, however zero figures still shows up.
I have now formatted the cells so empty combinations shows up as empty,
""
I have also removed the mark on "for empty cells show..."

What do I do wrong?

Knut