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

    Counting text occurrences

    Jeff123

      Title

      Counting text occurrences

      Post

      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!