suppresssing zero in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I suppress zero data rows in the new 2007 pivot tables?

Thanks,
Mike
 
Use a Value Filter in the Row Labels area:
Click the dropdown arrow on the Row Labels cell
If there are multiple fields in the Row Labels area, select the field
you want to filter for zero
Click Value Filters, and then click Does Not Equal
Type a zero, and then click OK
 
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

Pivot using 250,000 rows of data in Excel? 1
Pivot tables 2
Excel VBA For excel 0
Pivot table does not automatically update when underlying data cha 4
Excel 2000 Pivot table in Excel 2007 5
Pivot Tables with different groupings based on same data table 2
Pivot table overwrites neighbouring cells 1
I don't see the Pivot table field list window 2

Back
Top