In excel, order the list members (members only, not parents, etc, just the members as they appear in the list in Anaplan) in the order you would like it in Anaplan. Then copy just the list members. In Settings->List->Grid View (not Tree view!) of the list, click Insert, choose Start as the ‘position’, paste in the list, click OK
Solved! Go to Solution.
There is a way to do this with a line item using the rank function. If your list has a code that is a numeric string, convert this to a value then rank it. Then apply the sort based on that rank on the lowest level of the hierarchy.
The syntax I used was RANK(VALUE(CODE(ITEM('List'))), ASCENDING, AVERAGE, TRUE), sorts hierarchy automatically