What I want is sort the values numerically descending depending on the cyclic dimension selection.
Imagine there is a two values on cyclic dimension (dim A, dim B) and one measure (sum of sales), if I select dim A from cyclic dimension, sorting should be numarically decending sum of sales aggregated by dim A.
If I select dim B from cyclic dimension, sorting should be numarically decending sum of sales aggregated by dim B.