Reporting from worksheet with heirarchy

PeggyLang ✭✭✭✭✭

I have a worksheet that has parent child relationships. I have created a couple of 'helper' rows ('HELP-Phase' and 'HELP-Phase 1') to aid areport in illustrating the parent child relationships (i.e., group by one of the 'helper' rows). The % Complete and the date columns are not displaying in the 'group' heading. I would like them to display, is there a way to accomplish this?

First screenshot is from worksheet.

Second screenshot is from report. I had expected and wanted the the data that rolls up to the parent row based on the children below it to display in the report.


  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭


    I had a go.

    I found that if I use the helper column to group on it works like this.

    I coloured up the phase 1 and 2 for ease. That then gives you the overall phase results at the top.

    Hope that helps.


    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools