Thread: Pivot filter based on Custom values not working

IN the attached sample file. I have created 3 value fields based on USD field. First field shows absolute values, second field to show difference between two months and third field shows difference as % between two months.

I want to filter for values not between -1000000 and 1000000. However the filter does not seem to be working correctly though it restricts the values in the pivot table.

Not sure why it is not fully working. Any help?

VSM

Thanks. I have filtered for Absolute value only in the Opco column