Filter by clicking record in table

Hi,

As you can see from the below I have filters for Company, Product Group and Region. These work as you’d expect in that any filter settings are applied to the tables I created and to the other filters. Is it possible to have the same filter functionality by clicking on values in an table. E.g. If I clicked ‘agl’ in the top table the ‘agp’ row disappears from it and the next two tables update accordingly? I know I could use slicers but was just wondering if I could do something in the tables themselves.

Cheers

Paul