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
 
You must log in or register to reply here.

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

N/A in pivot table become 0 1
Pivot Table Suppression 1
Summing Problem In A Pivot Table 1
Pivot table column help 2
Pre-configuring Pivot table "views" 4
Pivot table Help Excel 2007 1
Hiding blank cells within a Pivot Table 1
Subtotals in a Pivot Table 1

Back
Top