Anyone know of a way to count (summarize) the total number of times a Member Status is selected for a particular Campaign?

 

Scenario:

- In Advanced Setup for "Campaign A" I added a new status called "Appointment".

- I want to create a new field within the "Campaign Statistics" section to show the total number of Members who have the "Appointment" status.

 

I looked at creating a roll-up summary formula but didn't see any options to roll up "Appointment".

 

Any guidance on this would be appreciated.

 

Ge

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?