Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 307 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to only show workers who have multiple managers
Cole_
Rank 1 - Community Starter
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?
0
Best Answer
-
Hi,
Can you please try the following XML?
It should bring all EMPs who is having more than 1 Manager.
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,
2
