Drilldown in the same table

[abhayneilam]

Hi,

I have a table with 3 columns:

Name , Location , Company

Now, Name column has got 3 values : AAA, BBB and CCC
Location and Company is blank

If I click AAA from the Name Column, value for Location column should populate ( AAA stayed in which of the locations in the past )
If I click BBB from the Name Column, value for Location column should populate ( BBB stayed in which of the locations in the past )\

Likewise,
If I click any value from the Location Column, value for Company column should populate ( In this location which are the company exists )

Kindly help me in achieving this !!

I have only 1 tabular panel in the dashboard.