I have a custom column for a sharepoint document library called 'doc type', I can use the normal filter function to filter down a list easily where one tag is selected but if I want to filter a list by two tags using an 'AND' query rather than an 'OR' it is not clear how? Ie if a doc has 'Presentation' and 'Bank' selected as tags if I currently filter these two tags it shows anything tagged Presentation or tagged Bank. How can I get this to only show where it has both those tags?
I was wondering if using the search bar would be possible to do this? I know that you can type Filename:XXX to only search filenames, is there a way to only search a column tag ie Doc Type:xxx and then potentially say AND rather than or?