suppresssing zero in pivot table
 

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

Thanks,
Mike

suppresssing zero in pivot table
 

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


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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html