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?

pivot table value filter
 

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.
--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"David" wrote:

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?