Selecting N Records From Every Distinct Value Of X Using The Greater Value Of A Sort Column

Use this option to filter records which have a greater value.

1. On N per X, select One per Household ID from the Household or Customer table: depending on requirement - See N per X & grid seg campaigns.htm
2. In the Using field select the option. For this example, Income.
3. Select Greater Values.

If the Allow 0s and NULLS to be selected check box is selected, customers with a zero or Null value will be included in the selection.

• N per X
  • 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