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

Hi

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.

PG