Bases: Group By / Sorting improvement: make a note fall into multiple groups

There is one. You can use DataviewJS.

+1

I managed to achive something similar with a custom view, but it would be way better to have it as a standard feature.

It would also be awesome (at least IMO) to have the group title to acts as a link, and clicking that link search all the notes with that property (like with tags), for example clicking on Finance will search all the notes that have the area property which contains Finance

+1

This is exactly the behaviour I am after.