+ Start a Discussion

counting number of specific multiselect pickist item

I'm trying to create a report that counts the number of times an item is selected from a multiselect picklist.  For example if there are three people and they have the following selected:

    Person A: Item A, B, C
    Person B: Item A, C
    Person C: Item B

The report would tell me that two people did A, two B, two C.  Further, I'd need to be able to sum up the number of times Person A does item A and etc.

Any suggestions?

Hi there. I realized you posted this question several years ago. Did you get any answers? I'm trying to do something similar but can't figure out  how to do it. Essentially, I'm trying to count (sum) the number of times someone selected the Member Status "Appointment" for a particular campaign.