I am trying to create a report where I can switch the mother-child relationship such that I can overview all the main tasks and their status.
Currently the project set-up can be viewed as this structure:
Product 1
- Order materials
- Materials received
- Assemble product
Product 2
- Order materials
- Materials received
- Assemble product
Product 3
- Order materials
- Materials received
- Assemble product
Etc.
Now, I want to make a report that switches this hierarchy around such that:
Order Materials
- Product 1
- Product 2
- Product 3
Materials Received
- Product 1
- Product 2
- Product 3
Assemble Product
- Product 1
- Product 2
- Product 3
I tried multiple groupings and filters but I cant quite figure it out. Thank you for the help!