I am using a List View Web Part that will be on several different sites. I want the items shown to filter based on the title of the site the web part is on.
The scenario: I have a list of accounts and each account is under a Sales Territory, each territory has their own site. I want the list to show ONLY the accounts for that Sales Territory, however, I need something that I can use generically because these sales territory sites are created by a workflow and I can't go in and edit the view of every site created by the workflow so I'm looking for something that works like the [me] filter.
I am running SharePoint 2013 Online through Office 365. I have access to SharePoint Designer 2013.
Any options anyone can suggest are greatly appreciated.