To pull direct and indirect managers list from Compensation Worksheet page
We have a requirement to pull all the indirect and direct managers in a single column along with their direct line manager from Compensation Worksheet through OTBI and further get the manager respective direct and indirect employees count.
Name | Direct Manager Name | Direct Employees Count | Indirect Employees Count
Top Level Manager | - | 10 | 2000
Manager 1 | Top Level Manager | 4 | 40
Manager 2 | Manager 1 | 5 | 30
Please help us with this.
Content (required): Indirect and direct Manager Names, Their direct line manager name
Version (include the version you are using, if applicable): 22B
Code Snippet (add any code snippets that support your topic, if applicable):