This content has been marked as final. Show 1 reply
I've created 2 worksheets, 1 sheet with details and 1 sheet as a clickable action to filter the table. I've also created a a multiple value dropdown list filter for the table. My expected result is when i click on the action filter on the top, it filters the table and the dropdown list only has "Furniture" checked. The action filter should link with the dropdown filter. I've selected "Only relevant values" but doesn't work.
Attached the workbook.