1 Reply Latest reply on Apr 5, 2010 9:17 AM by mrvodka

    Counting text occurrences



      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!