How to achieve Flexible Hierarchy Selection in Management Reporting

Hello Community,

We have a requirement related to dynamic hierarchy selection in our account reporting structure.

Our account hierarchy is structured as follows:

• AC1000A (parent)
  • AC1000B (child of AC1000A)
    • AC1000C (child of AC1000B; contains all level-0 members as its children)

When running reports, our business users would like the ability to select which hierarchy level to view:

• At AC1000A (top level)
• At AC1000B (intermediate level)
• At AC1000C (lowest level before individual accounts)

Ideally, the report should display aggregated data based on whichever node the user selects at runtime, showing consolidated values for the chosen level.