I want to list the states from the state/province field (handled by the Location module) in a content type. I used views, but it shows the same state name more than once.
I enabled distinct in the Views module, but it doesn't works. How can I avoid the same state name is shown more than once?
Current Result: Illinois, Georgia, Alabama, Illinois, Alabama, Alabama, Georgia.
I attached the screen shot of my view (I used table format and views group by module).
Expected Result : Illinois, Georgia, Alabama.
This is my views set up.
This is what I'm getting from my view.
I'm expecting this result no matter how many nodes have the same state; I want to display the state name only once.
This is the table style I used, and views group by module.