Report - How to show child rows of the one parent which has same child name of the another parent

PYU

hallo,

Two patents (INSTAGRAM ; FACEBOOK) which has childs(QTP WEBINAR; ZEP WEBINAR)

I had created a report for Instagram , but when i filter based on childnames , it shows all the childrows cause of the same child name...

In the Instagram report i want to show only childs under Instagram not under facebook

sheet.png

filter.png

Report.png

can anyone pls help me out

Thank u....

Andrée Starå

Hi @nivi

I hope you're well and safe!

Try something like this.

=JOIN(ANCESTORS([Primary Column]@row), " / ")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @nivi

I hope you're well and safe!

Try something like this.

=JOIN(ANCESTORS([Primary Column]@row), " / ")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PYU

Perfect Mr.Andree....worked out😀.....Thank u so much,,,,

Andrée Starå

@nivi

Excellent!

You're more than welcome!