Selecting N Records From Every Distinct Value Of X Using The Greater Value Of A Sort Column
Use this option to filter records that have a greater value.
Procedure
For example, a mailshot for a credit card offer to the customer with the highest income in each household:
- On N per X select One per Household ID from the Customer table.
- Select a value in the
Using field, for example, income.
- Select
Greater Values.
Note: |
If the
Allow 0s and NULLS to be selected check box is selected, customers with a zero or Null income will be included in the selection.
|
|
|