Combination of clicks on two matrix visuals filter a third table visual

[yasbos]

Hi. I have two matrix visuals, M1, M2 and a table visual T. I wanted to be able to click a row in one of the matrix visuals, say M1, it then filters the other matrix visual, M2, and the table, T. I would like to then be able to click a row in M2 (already filtered by the click in M1) to further filter the table T. What is actually happening is that, once I click any of the filtered rows in M2, the filter in M1 gets lost. Is there a way that I can build on a filter from matrix A, so that I further refine the data in T by adding a fiter from M2?

Thanks.

[vicky_ · Accepted solution]

You can hold CTRL when selecting items from Tables 1 and 2, which should keep the selection.

[yasbos]

@vicky_ you are wonderful. Thanks.