How can I count each selection on a multiple select field?


#1

Have a case management system that I need to track monthly & yearly numbers. Can’t figure out how to get a total of each selection per year & month. I can only get total no way to get per month/day. Here is an example:

Client A seeks help on “Date of service” has multiple “Needs” then we refer them to multiple “Service Providers”.

I need to know per Year & Month:

How many Clients for Need 1, Need 2, Need 3 (multiple select field)
How many referrals to Service provider 1, Service Provider 2, Service Provider 3 (multiple select field)

Converted date to separate Month & Date. Was able to get for year Month/year all the occurance of each year/month. But how do you count TEXT separated by commas? HELP! ANYONE!

Here is a screen shot of my table


#2

I also tried separating out Need and got in a field all the occurrences of year/month, but again how can I count text separated by commas. Surely there is a way to do this.