Selecting some <Audience> records per <Different Audience>
This selection indicates that there are multiple entries per audience.
About this task
In this situation, the input and output audience levels are the same, but a different audience level is used to scope the output. For example, select all customers within each household who have made purchases over $100 (Input audience level is customer, output audience level is customer, scoping by Household level, using Maximum Purchase Value>$100.)
In addition to creating a query, the Based On criterion also supports keywords allowing the functional equivalent of a GROUPBY macro function to be performed.