Hierarchy sorting

I have a hierarchy above in my report and it goes down to level 9. I also have a reporting order ID tagged at level 1 and when I try to sort this, it shows the following error. Fro...

Need Help

Tips and Tricks

tearless

Regular Visitor

1 year ago

This is what I did.

I created hierarchy tables Level1... to Level 9 with ID that shows the order of each hierarchy member.

Then I joined these 9 tables with the data table which has those hierarchy member.

Then, I selected each hierarchy table and sorted by those IDs..

But the report still does not get sorted as needed.

Ritaf1983

Super User

1 year ago

Hi tearless
If you’ve correctly defined a sort order for each level in the hierarchy (numeric, which is required), sorted all the tables, and placed the dimensions from the relevant tables into the visualization, with the visualization itself sorted by what’s in the 'Rows', it should work. If it’s not working, something must have gone wrong along the way. To figure it out, I’d need to see the file. Please share a link to it (without sensitive data), and I’ll be happy to check it. Alternatively, I’m attaching a file I created for you with 4 hierarchies—this is enough to understand the logic, as it’s not dependent on the number of levels in the hierarchy.