pivot table value filter

  • Thread starter Thread starter David
  • Start date Start date
D

David

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?
 
Hi David. The problem is the format. the 0 is not in the right format
(number). The best way I know to do this is converting to number with the
formula =value(), then you can apply the filte "does not equal" to 0 and it
should work.
 
Back
Top