View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jack jack is offline
external usenet poster
 
Posts: 186
Default Surpressing rows and columns with zero values in a pivot table

Let's say I want a report showing the number of times that my employees,
grouped in offices, markets and regions, makes a particular kind of error.
At the end of the month, I'd like to create a pivot table that says, "This
office had this number of errors of this type." I can create a pivot table
that does that, but it includes all the employees that have zero errors,
making the report unwieldy.

How can I format the pivot table to hide any row or column that has no value
in it?