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