I'm working with a composite hierarchy list in Anaplan for P&L reporting. The structure includes parent items like "Total Revenue" and "Total Purchases", each with their respective child items (e.g., "Revenue from Sales", "Revenue from Miscellaneous", etc.). I've implemented a Sort Order property to sort the list, but it only affects the children within each parent. The parent items themselves remain in their original order and aren't factored into the sort.
Is there a recommended approach to sort both parent and child items in a composite hierarchy? Ideally, I’d like to display the entire hierarchy in a sorted order (e.g., Total Revenue → Revenue from Sales → Revenue from Miscellaneous → Total Purchases → Purchases from Vendors, etc.).
I've considered flattening the hierarchy using a fake list and then importing the sort however this does not lead to any solution. Any best practices or design patterns would be greatly appreciated!
