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?
Help Article Resources
Check out the Formula Handbook template!