Pivot Table - Hiding Zero Rows

[compd]

Hi All,


I have come across an issue which I am unable to resolve and was hoping someone could assist.


Basically I have created a pivot table which automatically (default) suppresses zero rows. However when i add a calculated field i.e. column 1+column 2 and if column 1+comlumn 2 has no values this still shows the zero row. If I have 100 rows with no data, since I have added the calculated field they now all appear in the report.

Any help would be appreciated.

 

[NARAYANK991]

Hi ,


Have you tried creating an auto-filter , so that you can deselect the rows with zero values ?


Narayan