Suppressing 0's in pivot table - Please help

  • Thread starter Thread starter Gaurab Hazarika
  • Start date Start date
G

Gaurab Hazarika

All,

I have a pivot table where are sum up the values of a
column. The pivot table shows the information correctly
but shows the rows for which the sum is zero also.

Is there any way I can supress the rows in the pivot table
that have zeroes. If the sum of values is zero, I want to
hide the rows or I want pivot table not to show the row.


Thanks,
Gaurab
 
Gaurab,

No. You can only suppress items with no data. You will need to hide
those rows with 0's manually.

HTH,
Bernie
MS Excel MVP
 
Back
Top