Contact us Blog
Apsona Resource Library

High-value accounts filter

This example shows a filter that finds Account records in specific states that have produced closed Opportunities worth $10,000 or more. The filter includes four terms. Notice the filtering applied to related Opportunity records. The two filter terms on the Opportunity.Closed and Opportunity.Close Date fields, taken together, ensure that only closed Opportunitues that closed this year are retrieved. We next obtain the total Amount of those retrieved Opportunities, and then retrieve the Accounts for those Opportunities. Finally, we restrict the result to accounts in the selected Billing States.