How to sort a dynarange by data

    How to sort a dynarange by data

    I have a cube with more than 3 dimensions : products , countries and measures (number of sales)
    I want to do a table where I can read the number of sales per country and per product. So I do a horizontal dynarange with the dimension country, and a vertical dynarange with the dimension products. I then fill the cross-cell with a function.

    My question is how do I sort the countries according to the number of sales that occured there, so that in the column on the left is displayed the country in which I sold a lot of products. I don't know how to use the subsets filters to do this

    In the DynaRange ListEditor:

    1) Activate the PageTab: "Data"

    For every Dimension choos at least one Value. In the measures-dimension choose the key-figure according you would like to sort your countries.

    2) Activate the PageTab: Sort

    Check sorting by Value, check Reverse to reverse the sort.

    Hope this helps,