You can create a hierarchy in Tableau to include all subgroup levels in a tree. Place this on the Rows shelf - then you should be able to drill down by clicking on the + sign.
Do you have a sample data set?
Thanks for the quick response. I could not follow you all the way through. I have attached a portion of data extract from the PostGres.https://drive.google.com/drive/folders/0B-uwwRwqKnpLOUZXdXJOS1JId0E?usp=sharing.
One thing to note. my tree structure is dynamic and depth of the tree is unknown.
To create that hierarchy in Tableau you need to know the tree depth & its structure.
If the tree model changes over time then its a manual process of re-assigning the hierarchy every time.
Do you know what logic drives ur tree ?
My tree is dynamic. i don't have a way to know the depth. another application drives the tree.