Worksheet Hierarchy Based on Department Managers

Content

We use the line manager hierarchy to determine how budgets roll up and approvals are routed in the compensation plan. However, we also have the requirement to allow department managers to view the budgets roll up within their departments (this can be maintained as a secondary hierarchy). Have anyone done that? Do you have to use the department tree hierarchy? Or if department tree is not used, is there other way to do it via formula?

 

Thanks,

 

Jackie