Select row in table to filter another table to show all related rows

[Dan492813]

I have a table of data which has all contacts and another table with all actions related to that contact.

The relationship is one contact_no to many action_cd

All actions have a reference number in the contact table. I have a table that I have filtered to show a specific action if it is overdue but if I click that action I want it to show all related actions using the contact_no. It's kind of working back from the row context. 

So when I click on any of these actions I want another table to show me all actions related to the contact_no. 

Any help would be appricated. Thanks, Dan.

[johnt75 · Accepted solution]

I don't think that that is possible. When you select a row in your existing table visual, I think that the values for all the columns will be passed to the 2nd table as filters, and that will result in only the selected row being displayed again.

As an alternative you could use either a tooltip or a drillthrough page, passing the contact_no as the parameter.

[Dan492813]

Thanks for looking though