Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
