Acct Hierarchy Sort

Question

So I have an account hierarchy table such as the below:

If Acct is unique and it corresponds to a unique sort value, then when I put my hierarchy (Lev1, Lev2, Lev3) into a matrix it should work as follows?

I don't want to put the actual account in the matrix but will it still sort as follows?

amitchandak · Answer

PowerUser123 , Each level should have a sort column and for that&nbsp; level use that column as a sort column, it should get the correct order 
&nbsp;
How to Create Sort Column and Solve Related Errors: https://www.youtube.com/watch?v=KK1zu4MBb-c

anonymous · Answer

I tend to solve this issue by assigning every level of the hierarchy an id and sorting by that as well ass using for structure inte the matrix.

Forum Discussion

Acct Hierarchy Sort

2 Replies

Related content

Sorting

Date hierarchy

Sort Date Hierarchy

Hierarchy sorting

Table Sort , sort order , comparer