I need to model and implement hierarchical data with parent- child relationship for display ex region and country relationship

[Krishna_Chaitanya]

Hi,

I need to model and implement hierarchical data with parent- child relationship for display and analysis.

The visualization must support drill-down functionality where selection a parent entity(e.g, Region) initially shows aggregated data and selecting a child entity (e.g, Country) within that parent disply the child's data while maintaining the context of the parent.

So selecting region shows its data and selecting a country must dimply the country's data alongside the region's data.

 Thanks.

[Or]

That sounds like a pivot table?

Also, you seem to be posting in "Featured Members" for some reason, probably unintentionally? [Edit - I moved it for you]