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.