Filtering a Pivot Table

[rdb90]

Hi there,

I have a pivot table that shows the variance between actual results and their targets. Some of the variances are negative and some are postive. I want to have a PivotChart that shows the highest values, while keeping the sign. I have created a cell that contains the absolute value.

For example,
A 4
B 2
C -5

I would like the pivot table to show A & C. I don't know if there's a way to filter on the absolute value but show the signage or if there's a clever workaround. Any help?

Thanks,

 

[Andrew Poulsom]

Where's the absolute value there?

 

[rdb90]

Sorry about that. I didn't post the ABS.

Item Variance ABS Variance
A 4 4
B 2 2
C -5 5

 

[Andrew Poulsom]

Can't you add ABS Variance to your Pivot Table and filter on that?