How to sort a dynarange by data

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • How to sort a dynarange by data

    Hi,
    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 Palo.data 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

    Thanks,
    Ay