I want to be able to filter a column with multiple selection (whether it is a choice, lookup or managed metadata based) by the otherwise common logic of AND operator.
Example: I have a column with choices A, B and C
When I filter by A and B in choice or managed metadata currently sharepoint would show me all items which contains either A or B.
I would like to only get items, which contain A and B.
Until now I have found no possibility to do that, either with OOB nor Nintex Forms I am using.
Is there any way to accomplish that?
P. S.: I am currently using Sharepoint 2016 and Nintex Forms. The p
No one has an idea for a solution here?
In the mean time I have at least found a very clumsy workaround. I create multiple copies of the column from where the data is being looked up and then use these multiple columns to filter by. This works as intended, thus with AND condition, however you need X columns to filter by X values simultaneously, so we typically use 2 or 3.
This is better than nothing, but of course far from a real solution.
Thus, it would be great, if someone could come up with a brilliant solution here.