Unbalanced Hierarchy in formatted report

Navan Mehra
Navan Mehra Employee
Third Anniversary 10 Comments 5 Up Votes Level 100: Foundations of Building in Board
edited December 2021 in Platform
Hi experts,
I would like to know how have you all used unbalanced hierarchy in the reports?

I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report
  1. In the report, the parents should be at the bottom whereas an unbalanced hierarchy keeps the parents at the top
  2. To overcome #1 above, I defined the sort order as custom and reordered all members. The issue arises as soon as I go to the relationship and update any parent-child relation. Everything gets reset
Is there a way to put the parents at the bottom when using an unbalanced hierarchy in the data view?

------------------------------
Navan Mehra
Senior Consultant
Board Community
Australia
------------------------------

Answers

Categories