When you configure an Audience process to select IDs based on a count, or a statistical function ( MaxOf,
MedianOf,
MinOf) or
Any One, the
Filter button becomes available. When you click
Filter, the
Specify Selection Criteria window appears, which allows you to enter a query expression to specify which records will be used in the
Based On calculation.
Then, if you are computing a Based On calculation that chooses the sum of the
Amount field, only the amounts from transactions within the last year are summed together.