View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default pivot table value filter

I'm comparing quarterly volume in a pivot table (I brought in the values and
am showing them as "difference from" the prior quarter). I have many rows
with no Q/Q change and would like to filter them out, but when I filter the
rows selecting a value filter with "difference" <0, I still see the rows
with zero change.

any suggestions?