I don't see the "sortable" checkbox for the location field. I am using the Content: Node (type location field), meaning the full node. I tried using the Location: City, Location: Providence, etc... but it kept giving me duplicate entries for fields with multiple locations.
I am attaching a screenshot.
What I want to accomplish is to have a View with the table format (I am using the FooTable in this case) and have the location field display only the City and State for each "company (title)". But if a "company (title)" has more than one location, I want to display the multiple addresses in one field but the "company (title)" only once. I hope this makes sense.