function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
kvuongkvuong 

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?
jujubejujube

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.