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.

Find more posts tagged with

Formulas

Reports

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.