pivot table value filter

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?
 
A

alexrs2k

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table 1
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters 1
date filter in a pivot table 1
XL2007: Pivot table date filter 1
Pivot Table Refresh 1
Rows disappear in pivot table 1
Value filter missing in pivot table 3
Filter pivot table zero values 1

Top