Filtering Pivot Table according to Grand Total

[kdj]

Hello

I am trying to reduce a Pivot Table to show just those lines where the total is greater than 5 and am getting no where, short of copying the data out of the pivot table and doing it there. Any suggestions would be greatly appreciated!

Thanks!
kdj

 

[Mark W.]

Not sure how your data looks, but you could add a column to your data to perform your test for inclusion in the PivotTable. Then you could use that new column in your PivotTable's PAGE area.