How to only show workers who have multiple managers

Question

My org is switching to Oracle, and most of my experience in reporting is in Tableau. I'm struggling on how to filter to only show workers who have more than one manager. I tried count distinct of worker number, but that just returned a 1 in each row, I'm assuming because we only have 1 of each worker number. How can I get a count of managers for each worker?

Multiple Managers XML.txt

Bhaskar Konar · Accepted Answer

https://community.oracle.com/products/oracleanalytics/discussion/24559/how-to-only-show-workers-who-have-multiple-managers

Hi,

Can you please try the following XML?

It should bring all EMPs who is having more than 1 Manager.

XML -- EMPS having more than 1 MGR.txt

It is only having Employee Name, Number & Manager Count. Please check if it is working for you and if it is working then feel free to extend as per your requirement.

Hope this help.

Cheers,