It seems to me that I am missing something obvious.
I have a set of profiles authored by two separate groups of people with almost identical fields.
I want the current user to be able to run a view to find all the nodes of type Profile that have the same value of the field Primary Area of Interest as the logged in user. The logged in user and authors of the other nodes will have different roles.
I have tried contextual filters and also using the views field views module to little effect. Any help appreciated.
Thank You