I'm trying to report on the Opportunity Data within our organisation in the HQ account. I've managed to report on the data from the child account using the Parent ID as the filter. Unfortunately it doesn't let me filter by both Parent Id and Ultimate Parent ID.
When I set the Parent Id as the filter the report displays as such:
Is there a way to include all of the child, grandchild records and the records from the actual account?