...
- Sort type
- Affects : Axis to which ranking is applied
- Sort: Dimensions you wish to sort
- Sort by : Element by which you wish to sort the dimension
Sort type
It specifies if the elements of one dimension are to be sorted within the dimension itself, or if the dimension will be sorted according to the elements of a dimension located on the other axis. The options are "Sort dimension" and "Sort By" respectively.
Axis to which sorting is applied
Which axis is to be affected by the sorting should be indicated. If a graph is viewed, the options are "X" or "Series". If a table is viewed, the options are "Columns" or "Rows".
Sort
This section shows the dimensions for which it is possible to define a sorting operation, according to the option chosen in the "Affect" section. In case there are embedded dimensions in the selected axis, the user must define which dimension the sorting operation will be applied to.
Sort by
The first part of this section is enabled only for the sort type referred to as "Sort By"
According to the choice in the "Affect" section, the dimension on the opposite axis to the chosen one and its elements are displayed. The user may specify if they will "Sort By" all the dimension (that is by the whole of its elements), or if they will "Sort by " some element in particular.
The second part of this section is enabled only for the sort type "Sort Dimension". It allows users to define if the sorting will be by the values of the analyzed measure (option "Totals"), or by that dimension's element's labels, (option "Labels")
Steps to follow to sort elements from the "Ranking" option from the "Explore" menu or through the corresponding icon in the Toolbar:
...