Thread: suppresssing zero in pivot table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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

Reply With QuoteReply With Quote