Choices for select filters in pivot

A user asked me if it’s possible to have a select filter only show options that are compatible with other already set filters.

See example: https://snippet.webix.com/fd2uom9a

Europe is set in filter, so I would like the ‘name’ (i.e. country) filter to only shows countries in Europe.

I know Excel does not do it, and it seems kind of tricky, because each dropdown needs to work out what constraints are imposed by all the other filters, but I thought I’d ask.

Thanks!

technically it is possible
https://snippet.webix.com/qbwn71vu
probably there is a better way

Seems interesting, but I will need to understand the exact logic so I can generalize it to making sure that every single condition is constrained based on all other filters. I’ll extend it and come back. Thanks!