How to group child rows when creating a report?

I have a sheet where the a person is in one column and the projects that he's assigned to are in the next column called "Projects".

I am trying to create a report to measure the allocation% percentage a person has for each project by month.

To do this I placed all of the projects that each person is assigned to in Children Rows, hence the minimize button in the "Person" row.

Screen Shot 2022-02-15 at 9.07.57 AM.png

The problem I'm running into is that when I create a report and try to group by "Person" it is grouped wrong because it's not counting the "Project" column as a Child. So the blank spaces in the "Person" column is also being counted as a group.

Screen Shot 2022-02-15 at 9.26.44 AM.png

Anyway to solve this? I saw similar threads and it was suggested to create "Helper" columns. Not sure how to use them in this case.

Find more posts tagged with

Reports

Accepted answers

Genevieve P.

Hi @mbsamuel6

I would also suggest creating a "helper" column! I would create a column in your source sheet (that can be hidden) with a column formula applied. The formula would be really simple PARENT formula, like so:

=PARENT(Person@row)

Screen Shot 2022-02-16 at 12.31.01 PM.png

This will bring the name of that top row into all the Child Rows. You can then Filter by this column in your Report to get rid of the top rows, and Group by this helper column as well.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @mbsamuel6

=PARENT(Person@row)

This will bring the name of that top row into all the Child Rows. You can then Filter by this column in your Report to get rid of the top rows, and Group by this helper column as well.

Cheers,

Genevieve

mbsamuel6

Thank you so much Genevieve. I knew I needed the helper column just wasn't sure what formula to use.

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.