Sorting
The Dashboard Designer allows you to easily change the sort order of values within a dashboard item. You can also enable sorting by parameter values.
Changing Sort Order
The sort order of dimension values is indicated with an arrow.
To change the sort order in the Designer, click the data item. You can also toggle sorting from the data item menu.
Sorting by Measure Values
Dashboard allows you to sort dimension values by summary values calculated for a specific measure.
To enable sorting by measure in the Designer, use the Sort by submenu in the dimension's menu.
You can also sort dimension values by the values of hidden measures.
OLAP Sorting Specifics
In OLAP mode, you can use the following options to specify the sort order for attribute members.
- No Sorting - Specifies the default server sorting for the current attribute.
- Sort by - Allows you to choose the OLAP member property by whose values sorting is performed:
- (Value) - sorting is performed by member values;
- (Display Text) - soring is performed by captions associated with members;
- (Key) - sorting is performed by member keys;
- (ID) - sorting is performed by member IDs.