We want to check if Sales in any given state is more than 10000
Create Calculated Field:
Name: MoreThan10K
Formula: SUM([Sales])>10000
Using this field as well as States in a table, we have a distinguished color when the criteria is met.
By changing the new Calculated Field from Marks pane to Filter pane, we can filter out the states with less than 10K of Sales