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 to see what customer in each household has the lowest Customer Profit Decile.

Procedure

1. On N per X, select the relevant option from the required table, for example One per Household ID from the Customer table.
2. In Using select the relevant field, for example Income.
3. Select the Allow 0s and Nulls to be selected check box.

This ensures that customers with a zero or null value will be returned.

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

• 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