Is it possible to get excel like filtering?

[antespo]

I'm trying to add excel like filtering with primereact multiselect and running into some problems with the dropdown closing. When I apply a filter I want that to updates all the other filters options instead of keeping the total options always. Here is a codesandbox that shows the problem. In the sandbox I have a button that controls if the filters pull from rows or filteredRows. You can see that when the button says rows it works but that wont filter the dropdowns since it's using the whole dataset. When the button says filteredRows that filters the dropdowns but then also closes the dropdown on change.

Also you would notice this kind of makes a multiselect useless since the current filter your on will always be filtered down to the 1 option you picked. So the current filter being changed should not change options but all the others filter options should change.

To sum it up:

• I want the dropdown to stay open even when any dropdown options change
• The current filter being changed should not change options but all the others filter options should change.