Select Lesser Values Of An N Record From Every Distinct Value Of X

Use this option to filter records that have a lower value.

For example, a Mail shot campaign to the customer in each household who has the lowest Customer Profit Decile.

Procedure

1. On N per X, select One per Household ID from the customer table.
2. Select a value in the Using field, for example 'Income'.
3. Select Lesser Values.
4. Select the Allow 0's and NULLS to be selected check box.

This ensures that customers with a zero or Null income will be included in the selection.

If there is only one customer in the household, that customer will be selected.

• N Per X and Grid Segmentation Campaigns
  • Selecting N Records From Every Distinct Value of X
  • Selecting N records from every distinct value of X using the greater value of a sort column
  • Select lesser values of an N record from every distinct value of X
  • N Per X Prioritized De-duplication