MetaTree - Filter based on parent and parent's parent
I'm trying to build a metatree that looks like this in "Mega" terms
Is there a way to make the Project list exclusive to the Org-Unit selected as "grand-parent". In the queries, I'm able to refer to the parent using the &name parameter.
Select [Project] Where [Achieved Objective] = &"name"
The problem is that I get all projects related to the objective, whatever the parent org-unit. I would like to filter the Org-Unit as well so that the list would represent only the projects of the Org-Unit for the selected objective.
If an objective is shared between 2 org-units, I would like to get the following:
I don't want to "hardcode" the Org-Unit because there are many and names may change over time.