Reporting Hierarchy

I have a sheet with several parent, child and grandchild rows. I'm creating a Report from this sheet but I am unable to filter and see child or grandchild wise. I have created a WBS System (1, 1.1, 1.1.1 -> Parent,Child,Grandchild) as well but unable to group/filter using this. Is there any work around for this?

Find more posts tagged with

Reports

Automations

Accepted answers

All comments

Mark Cronk

Good evening,

Add a helper column [level] and instead the column formula:

=COUNT(Ancestors())

Your parent rows will have a value of 0, children 1, etc. Use your [level] column value to filter.

Work for your project?

Mark

mg3245

Hi Mark,

I already have this formula applied in a separate column. However, the issue comes up where each Parent row refers to a separate client eg: Hyundai/Toyota and the child row refers to its subdivision eg : Hyundai Cars/Toyota Electric Cars while the grandchild row refers to Hyundai Cars South Africa/Toyota Cars New Jersey.

In this case, even with the ancestor formula applied, I am unable to filter in my report to see all the grandchild rows which are listed in my sheet under Hyundai. I hope I've explained my problem well. Else can attach a sample report to explain it better.

J Tech

Otherwise you can create a help field call parent:

=Parent(PrimaryField)

You can then filter than that

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.