I have a calculated field(Sum_of_FICA_OOB) that is auto-filtered added to a pivot table. I need to show ONLY values >1 and <-1. I can't figure out the code to get that filter to only show those values. I had a similar piece of code I used to filer a Pivot Table Item in a similar fashion, but I can't modify it to work with the calculated Field

Here is the code I used to filter the Pivot table Item that did work that I was trying to modify
Please Login or Register  to view this content.
Can anyone provide a modified code to filter the calculated field I added(Sum_of_FICA_OOB) to show only values <1 and >-1?

Thanks,

Craig