I am doing an AggregateResult SOQl query on different picklists on a Contact.
List<AggregateResult> results = [select LeadSource, COUNT(id)cnt from Contact where LeadSource != null group by LeadSource];
Where LeadSource is of type Pick list. This basically gives me the number of records for each value in the LeadSource picklist.
The problem however comes when doing this same type of AggregateResult query for a multi-select picklist. It says I cannot do a group by for a multi-select picklist.
Is there any other way I can do AggregateResult for a multi-select picklist?