Good afternoon. My problem is this:
There are 3 levels of dimension hierarchy in the table that can be collapsed and expanded. Each of them should be sorted depending on the selected parameter, which simultaneously determines the type of dimension dimension formula example and the sort order. The idea is that when one of the parameters set to time line, this dimension should be sorted by months, otherwise - by the measure.
In order for the sorting to happen correctly, I created fields for sorting corresponding to each parameter sort field formula example and sorted by field for each dimension sort by field parameters. This works well, except that sorting does not always correct at the second and third levels of dimensions like here: example of incorrect sorting from internet. As a solution of the problem I tried to use nested sorting, but I ran into another problem - when collapsing and expanding the hierarchy, the sort settings for the second and third level were reset to the first level settings. before collapsing and expanding the hierarchy - after collapsing and expanding the hierarchy
Here is a minimal reproducible example of my problem, you can download workbook to inspect the situation.
Please help me resolve this problems or find a way where I can find a solution.