Re: Filtering a table on one page based on what you selected in a table on the first page

Sheltomt — Wed, 25 Oct 2023 13:11:25 GMT

When I select Table A, and click on Edit Interactions, on Table A all I get is "Filters on Visual" and "Focus Mode".

I know what you're talking about, on the Slicers it has that icon.

Filtering a table on one page based on what you selected in a table on the first page

Sheltomt — Tue, 24 Oct 2023 20:17:21 GMT

So, I have Table A that has a list of broad categories. Table B has subsets of that data, one to many relationship.

I want to be able to click on "Category 1" in Table A, and then get all the "SubCategory" entries in Table B that match what I selected in Table A.

And to make it a little more difficult, I want to be able to reverse filter as well, as in clicking on Table B takes you backwards in Table A to the matching broad categories.

I've looked at drill-throughs, but I'm really unsure if that is the appropriate way to go with my criteria.

Any suggestions/help is appreciated!

Sheltomt Tracker

Re: Filtering a table on one page based on what you selected in a table on the first page

Filtering a table on one page based on what you selected in a table on the first page