Milestone Report - Parent Row

Question

Hi All

I have built a milestone report (showing all tasks with a duration of 0d)

I would like to have the "parent" row show up then those milestones for that parent follow.

For example: We have parent rows "design" and "build", we have 5 milestones underneath each parent.

Is this possible? I believe I have done this in the past, but cannot for the life of me recall how this was done.

BullandKhmer · Accepted Answer

There are a few ways to do this.

I suggest adding a couple of helper columns to your source sheet as detailed below:

Ancestors: =COUNT(ANCESTORS())

Stage: =IF(ancestors@row=0,[task name]@row,PARENT([task name]@row))

Then in your report add a filter 'Stage' is one of….