Milestone Report - Parent Row


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.

Best Answer

  • BullandKhmer
    BullandKhmer ✭✭✭✭✭
    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….