Counting text occurrences
I am trying to figure out how to find out the number of text occurrences throughout a single field in all present records.
For example, I have a field with a drop down list of each of the 50 states. How would I create a field to determine that, for example, there are 3 Californian records, 4 Alabama records, etc.
The reason for this is to hopefully be able to get a pie chart showing the percentage of each state. I am having a terrible time trying to get it working though.
Thanks in advanced for any help!