hierarchy with regions and related data in table

[shanu_s9]

Hello Experts,

I need to create a hierarchy with regions and related data in table.

Could you please advice how can I achieve this.

Hierarchy is working only on list box object, can we have any option to user same functionality on straight table.

In the below screen shot i have created a hierarchy and table separately and placed one behind other to show my expectation

[eddie_wagt]

Hello Shanu_s9,

You did not provide example data or script so I cannot determine how your datamodel is. I noticed that in your hiearchy that the sum of all countries under the parent East is 2000? It is a bit strange if you ask me. However if you have modelled your data with the Hierarchy prefix you can easily set this up by using a pivot table.  I have provided an example.

Regards

Eddie