Thanks for posting your question to the Community.
Did you discover what the issue was here? Please share it here, you might help somebody with a similar issue.
Hi Michael, unfortunately I have not.
I did read somewhere on here (forgot which thread) that another user who with similar issue was getting feedback and it was indeed a limitation of the design.
Looks like I will have to create a query for each separate location after all.
If anyone reading this and knows otherwise it would be awesome.