Top/Bottom Filters

Version 2017.1 allows you to add Top/Bottom filters, also known as Top N filters, to a report. Top N filters allow you to filter data to only the rows with the top or bottom values, for either data fields or data summaries, per group iteration.

To show only the top or bottom values, for either data fields or data summaries:

  1. On the Filters page, click the Top/Bottom tab.

  2. Select the Limit the report to the top or bottom values of a data set check box.

  3. Select either Top or Bottom, for whether you want to show the top or bottom values.

  4. Enter a number for how many values you want to show.

  5. Choose how you want to limit your data:

  6. Select the data field or group field to filter from the Of list.

  7. Optional: To show the top or bottom values for each iteration of a group:

    1. Click AddBtn.png Add Group.

    2. Select a group field from the For Each list.