I'm hoping some genius in this community has a solution to this!
I am attempting to use a custom form to address our organizational structure needs and allow a Director to pull reports that include all staff under them, even those that report through Managers or Supervisors. To do this, I need to have a calculated custom field that I can use as a report filter, and that will respond to the $$UserID wildcard. Right now, I would have to input the Director's name to get anything to work.
Hopefully this makes sense?
Thanks in advance for any advice!
Topics help categorize Community content and increase your ability to discover relevant content.
Hi Alison. I invite you to consider our Executive Dashboards solution, which includes the technique you're after for pulling reports by director (or at any level of the corporate hierarchy, in fact).
Hi Alison, about a month ago I found this interesting idea.
The calculation on the post is not correct but I managed to figure out the correct format through trial and error. It is as follows:
CONCAT(Manager, ", " , Manager.Manager , ", ", Manager.Manager.Manager, ", ", Manager.Manager.Manager.Manager)
Hope this helps!