Apply Top Bottom N Filters

You use the Top Bottom N filter to filter a measure to a subset of its largest (or smallest) values.

You apply top or bottom filters to data elements that are measures. When you add a measure to a filter drop target of a visualization, the default filter type is Range, but you can change the filter type to Top Bottom N from the Filter Type menu option.
You can apply a Top Bottom N filter to either a project canvas (it applies to all visualizations in the project), or to a selected visualization. All of the following steps are optional:
  1. To apply the Top Bottom N filter to the canvas and all visualizations in the project:
    1. In the Visualize canvas, select a filter in the filter bar.
    2. Click the filter menu or right-click and select Filter Type, then click Top Bottom N. You can only convert a range filter to Top Bottom N filter
  2. To apply the Top Bottom N filter to a specific visualization in the project and update the filtered data on the canvas:
    1. In the Visualize canvas, select the visualization to which you want to apply the filter.
    2. In the Grammar Panel go to the Filters drop target.
    3. Select a measure, then right-click and select Filter Type, then click Top Bottom N.
  3. To change which filter method is applied, Top or Bottom, in the Top Bottom N list, click the Method value.
  4. To display a particular number of top or bottom rows, in the Top Bottom N list, click in the Count field and enter the number.
  5. To change which columns to group by, in the Top Bottom N list, click in the By field, or to display the available columns that you can select from, click Plus (+).
  6. To deselect any member from the list of attributes, in the Attributes list, click the member that you want to deselect.
  7. To add a member to the list of attributes, in the Attributes list, click any nonselected member.
  8. Click outside of the filter to close the filter panel.