Sorting of Selected Members

In most of the cases the dimension members are sorted by names, but you can override the method of member sorting.

Let us build the following report:

In order to set up sorting, open the member selector and choose the tab “Sorting”:

There are 3 options here:

• Do not sort;
• Sort all levels by a single criterion;
• Sort each level by different criteria.

Let us sort the elements on the level Subcategory in descending order by Reseller Sales Amount in 2017. For this you have to select the last option – “Sort levels using different criterias”. Then select the tab which corresponds to the level Subcategory and switch on the sorting for this level:

Choose “by measure” and in the dropdown list choose “Reseller Sales Amount”:

In order to take into account the values for the year 2017, you have to override context. For this press the button “Override Context for Hierarchy”:

In the dialog box select the “Date.Calendar” hierarchy and press «ОК»:

Again press «ОК». You will have a member selector form where you have to select the year 2017 and press «OK»:

Finally, choose the descending sort order and press «ОК»:

After this you’ll see that all elements of the level “Subcategory” inside each group are sorted in descending order by the value of “Reseller Sales Amount” in the year 2017.

If you expand another product category, you will see that the elements on the “Subcategory” level are sorted in the same way. That is, the sorting is applied to all members of the selected level (in this case – “Subcategory”) inside the categories: