In my site each 'User' as a profile (created using Profile 2). One of the fields in the profile is a 'Select list field' that allows the user to choose his/her State of origin.
Please how can I create a View which displays to each "currently logged in user", the people who come from his/her State.
I have tried the following but it returned empty.
I created a User view.
I added some fields
I added the following relationship- "User:Profile"
I added the contextual filter on "(Profile) Profile:State" to provide default value from "User ID from logged in user" if filter value is not in the URL.
I added the contextual filter on "User:uid" to provide default value from "User ID from logged in user" if filter value is not in the URL.