calculate a summary of a drop down list field...
I'm trying to create a field that will dynamically calculate the count of a particular identifier in a drop-down list. I tried using the Summary setting but it doesn't seem to be able to calculate individual items from a drop-down list.
In detail, I have a drop-down list field named "Categories". Within the drop-down list is "Clients". I'd like to place a field in my table that will always show the total number of records that are set to "Clients" in my "Categories" field.
Any suggestions on how to set this up?