Filters

There are three types of filters available from the Filters menu.

Standard

Matches data values against a condition. For more information, see Standard Filters.

Top/Bottom

Shows only the top or bottom number of values for a data field. For more information, see Managing data.

Group Min/Max

Shows only the highest or lowest value for a data field.

This is useful if you are only interested in viewing the highest or lowest values, such as the most recent hire or highest revenue figure, in a given set.