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.
Measure
| The parameter according to which the top or bottom values will be determined.
|
Count
| The number of values to be displayed.
|
Mode
| 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.
NoteNote 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.
Limitations
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.
See Also