I know there have been several posts on this topic but while I think I'm following the approach used by others, it doesn't seem to want to work for me..
I have a pivot table with 5 dimensions (including one calculated dimension) and 5 expressions. On the Presentation tab, I have Suppress Zero-Values selected. The expression fields includes QE Date, Actual Amount, Projected Amount, Difference and Difference Percentage (absolute value). The Difference Percentage contains the following definition: =(fabs(AQ_Amt-PQ_Amt)/PQ_Amt).
In order to hide the rows with a Difference Percentage under 5%, for each of the 5 expressions, I enabled the Conditional option and put in the following:
=if(fabs((AQ_Amt-PQ_Amt)/PQ_Amt) > .05, <expression definition> ). For example, for the Difference Percentage, I have following condition: =if(fabs((AQ_Amt-PQ_Amt)/PQ_Amt) > .05,(fabs(AQ_Amt-PQ_Amt)/PQ_Amt))
Thanks but I was able to suppress the rows using the method I was trying EXCEPT I had the condition for each expression field in the wrong place. I had it in the Conditional box and I needed to have it in the Definition. Now I have everything that has a difference of less than 5% excluded from the table.