How to group child rows when creating a report?

Options

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.

Tags:

Best Answer

Answers