Tying parent tasks to children in reports
As far as I can tell this hasn't been brought up recently - hoping there may be new information available.
I'm trying to build a report that pulls in tasks by current user, so that the viewer sees only those tasks that apply to him/her pulled in from multiple sheets. The challenge is that I also want the parent/grandparent tasks to appear in the report - but only for the tasks filtered by current user. I.e., I don't want the report to pull every parent task - only the parent tasks of children that apply to the current user.
For example: I have tasks assigned to me on 5 sheets, and each sheet has 4 sections of tasks divided into categories by parent tasks. But my tasks only appear in one or two sections on each sheet. I don't want to see the parent tasks for the sections where I have no tasks assigned. That's the challenge I'm tasked with solving.
I've figured out a good way to pull in parent tasks when I filter by a specific user, but not a way to do so when the filter criteria changes based on who is viewing the report.
Happy to clarify and give additional context as needed - thank you!