Hello community,

We are segmenting our contacts using a multi-select field. One contact may belong to multiple segments. Segments are a list of 10 differents entries qualifiying our industry.

Now we want to have some statistics, and build a report listing the number of contacts per segment, and possibiliy the list of these contacts.

Example:

Contact A : Segment 1, Segment 2

Contact B : Segment 2, Segment 3

Contact C : Segment 4

Report should list:

Segment 1 : 1

Segment 2 : 2

Segment 3 : 1

Segment 4 : 1

Problem of the multi-select fields is it's a colon-separated string. Sorting using this fields is not relevant as almost all contacts have different combination of segments...

How would you build this report.

Current solution (not finished):

- create a report for each segemen entries (so we have 10 reports)

- consolidate the results into one main report. How ?!

Any ideas are welcome :) Thanks