Hello all,
I'm trying to build a allocation forecast report - which i've been able to complete. Now I want to be able to show not only my direct reports, but also anyone who reports to them.
Example:
Creative Director
--> Associate Creative Director
---> Art Director
In this view the Creative director would see the forecast allocation of their direct reports ( the ACD's) but also be able to see the forecast allocation of anyone who reports to their direct reports.
I would also want to group them on the report in a way to allow the CD to view the ACD and then be able to expand to the art directors below each ACD.
currently i'm able to get only to my direct reports, but not to a second or third level. Does anyone have any experience on generating a report that shows this level of information ?
