View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
HMallen HMallen is offline
external usenet poster
 
Posts: 4
Default Pivot Table - with blank rows

Do you know if there is a way to use a value filter to eliminate rows with
zero value and also a label filter to remove specific items in a field at the
same time? Whenever I try to filter some items out using the label filter,
it removes the value filter I had set that removed the zero value rows.

Thanks.

"Herbert Seidenberg" wrote:

You can do it with Excel 2007
PivotTable Value Filter:
http://www.savefile.com/files/1749561