The Top N feature allows you to display only a limited number of values that correspond to the highest or lowest values of a particular measure.
To enable the Top N feature, open the dashboard item Binding menu, select a required data item and go to the Top N section.
Click ON and specify the following settings.
The parameter according to which the top or bottom values will be determined.
The number of values to be displayed.
Specifies whether top or bottom values should be displayed.
Show “Others” value
If enabled, all values that are not the top/bottom ones are consolidated in the “Others” value.
Note that this capability is not supported in OLAP mode.
You can use the hidden measure as a parameter according to which the top or bottom values will be determined.
The “Others” value has the following limitations:
- You cannot set the “Others” element as a Master Filter value.
- Drill down by this value is not supported.
- You cannot obtain Underlying data only for the “Others” value. As an alternative, use the Data Inspector to obtain underlying data for the whole dashboard item.