Hello All,
How can i set up a count of employees that are distinct to the 'Job Title' and report to the reporting Manager?
So i want a gallery with a list of distinct titles and the number of employees for that specific title.
Example table below:
Admin 1
Manager 2
Sales Rep 2
I currently have a variable set as mgrVar= Thisitem.Employee that needs to be incorporated into the formula. It is a onselect variable. Not sure if this matter, but not all reporting will have the same type of job title employee. Some managers will have Specialist, supervisor, etc. That is the why I want it dynamically show whomever is selected their respective employee title and employee count will appear.
| Employee | Job Title | Reporting Manager |
Pluto | Admin | Bugs |
Mickey | Manager | Bugs |
| Minnie | Manager | Bugs |
| Donald | Sales Rep | Bugs |
| Goofy | Sales Rep | Bugs |
Thank you