Top/Bottom Filters

You can 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 checkbox.

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:

   • If you want to show the rows with the top or bottom data values for a field or group, select Values from the list.

   • If you want to show the groups with the top or bottom summary values for a parent group or the report, select one of the summary calculations, Sum, Avg, Min, Max, Count, or Distinct Count, from the list.

     Note: Only numeric data fields support Sum and Avg calculations.

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 Add Group.

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