Excel 2007 Pivot Tables - do not display zero values
Change the number format to suppress them using, for example:
General;General;;@
as a custom format.
Hope this helps
Adam
On 10/03/2010 14:19, Barb Reinhardt wrote:
How do I set my pivot table so that it does not display any sums of values
that are equal to zero?
Thanks,
Barb Reinhardt
|