I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters.
However, I have one column Vendors which is a lookup column to another list. This list will be used elsewhere in the site for other document libraries. I am unable to use that column as a key filter. Are there any work arounds? Is this something I should use a Term Store for?
PS: I attempted to use the key filters to filter by Year first, and then use the dropdown menu in the column header to filter by Vendor and it still wouldn't work. Key filters override everything.