I have a field in my list called "Choice". When completing the form, the user can pick from one to a number of choices.
In a workflow, what I need to do is get a summary count for each Choice in the list.
Any easy ways to do this?
I had two thoughts on how to do this and both seem ugly.
1. Maintain two collections. One a list of unique Choices. The section collection would be the total for a particular choice.
2. Create a temporary list of the Choice and a column for the total for that Choice.