How to get multiple columns on selection of one type?

[Anonymous]

i have data with columns:

- InsuredName

- InsuredAddress

- InsuredCity

- BrokerName

- BrokerAddress

- BrokerCity

On selection of a dropdown consisting values like(Insured, Broker etc..), i need to populated other bar chart with related columns.

Example: On selection of INSURED in dropdown, i need to populated bar chart with INSUREDNAME, INSUREDADDRESS, INSUREDCITY.

Any help would be highly appreciated. Thanks!

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can create a higher level hierarchy. after you select level 1, then drill down to level 2