Suppressing 0's in pivot table - Please help

  • Thread starter Gaurab Hazarika
  • 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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Data Aggregation 0
N/A in pivot table become 0 1
Suppressing 0's in pivot table 0
pivot table help 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Excel does not accept text format! 0
pivot table missing rows? 0

Top