6 Replies Latest reply on Sep 22, 2011 9:59 AM by KristineBell

    Summarizing Items in a Drop Down Field

    KristineBell

      Title

      Summarizing Items in a Drop Down Field

      Post

      Hi there,

      I have a drop down menu containing 5 options (Departments, in this case), and I'm trying to find a script or calculation to summarize the number of instances of each of the 5 options:

      Department 1: 5 instance

      Department 2: 23 instances

      Department 3: 6 instances

      Department 4: 12 instances

      Department 5: 150 instances

      Any suggestions?