I need to create a report in which there are three connected objects. For example, Org Unit is connected to Position is connected to Person. I am able to build the report so this is produced.
However, ALL Person objects that are connected to the position are returned. For example, if the Org Unit was Germany Division and the Position was Sales Rep, my report that I have created returns Germany Division and Sales Rep but when it goes to connect the Persons to the Sales Rep, it includes Persons who occupy the Sales Rep Position outside of the Germany Division Org Unit.
Is there a way to filter the results of two connected objects based on a third object?
Let me know I need to explain myself better.
Thanks!