About Top Bottom N Filters
You can use Top Bottom N filters for all filter scopes to filter an attribute or measure to display a subset of its highest or lowest values.
For information about filter scopes, see Filter Scopes.
For example, you can filter a visualization by the top 10 cities based on sales. You can define a Top Bottom N filter in the filter bar to show the top 10 cities with the highest sales.
Description of the illustration filters_topbottomn_salesbycity.png
You configure the following three properties to create a Top Bottom N filter:
- Method - Specifies whether to filter by Top (highest values) or Bottom (lowest values).
- Count - Specifies the number of values to display. For example, the top 10 or the bottom 5.
- By - Specifies which measures or attributes to limit the filter by. If your filter is an attribute, you can choose which measures to limit it by. If your filter is a measure, you can choose which attributes to limit it by.