In a SharePoint 2010 List, I have a list that has a column of "Location of work" which is based on country.
I want to create a Custom View, with a filter that should work like
Every current User can only view the list items that have the same work location as the current User's.
I am trying to work this out as an OOTB solution by modifying the view.
Is there a way I can select the current user's country in the part where I typed [Me]
(obviously the [Me] was a desperate attempt), but is there a simple function I can write there for the current requirement.