Reorder members in the Account Dimension in HFM
I have created all the members in the Account dimension with the correct parents. As an example, the P&L account hierarchy is in the following order:
Profit After Tax (PAT)
- Tax Expense
- Profit Before Tax (PBT)
- Expenses
- Revenue
This means that when the user expands PAT, he/she will see Tax Expense and PBT first, and then Expenses and Revenue (when PBT is expanded). Is there a way to re-order the view (to something like below), without impacting the Consolidation parent rollup?
Profit After Tax (PAT)
Revenue
Expenses
Profit Before Tax (PBT)
Tax Expense
Thanking you in advance