Reporting from worksheet with heirarchy
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.