don't understand - the LOD workbook seems to be sorted properly - what is it that you expected
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Problem is when I compress the Sub-Category and expand again the sorting is disturbed
The sorting has to be fully functional with the drilldowns
When I click the "+" symbol on dimension in sheet then I see this issue. How do I fix this issue since a measure cannot be added to the hierarchy.
Is there any other approach ?