Grouped Table - Only show items based on the Total meeting a certain parameter

[nyiballs]

I have a table where I am showing an item, the number of units sold, and the revenue...

I have subtotaled the table based on the items to show the total for the revenue.

What I want to do, is now find a way to only show the items on the table whose TOTAL is above a certain number.

ie... I have 10 lines for Item A, and the total revenue is $100, 4 lines for Item B and the total revenue is $60, 7 lines for Item C and the total revenue is $120

I would like my table to only show the items whose TOTAL REVENUE is greater than or equal to $100. What's my best course of action?

[dflak]

Without seeing an actual sample, I can only offer general advice. I recommend making a helper column that tests for the condition and filter on that.