hi oercim,

to: Excel 2013

http://office.microsoft.com/en-ca/ex...803.aspx?CTT=1

Hide zero values in a PivotTable report
1.
Click the PivotTable report.
2.
On the Options tab, in the PivotTable Options group, click the arrow
next to Options, and then click Options.
3.
Click the Layout & Format tab, and then do one or more of the following:

Change error display
Check the For error values show check box under Format.
In the box, type the value that you want to display instead of errors.
To display errors as blank cells, delete any characters in the box.

Change empty cell display
Check the For empty cells show check box. In the box, type the value
that you want to display in empty cells. To display blank cells, delete
any characters in the box. To display zeros, clear the check box.


isabelle