I am currently struggling with the following issue and hope that somebody can help me:

 

Each data set in our DB has a field "Reporting customer" and a field "Affected customer" (String field), where the Reporting customer is also always part auf Affected customer, but Affected customer does contain up to 42 customers. Now I need to create a report which shows all entries affecting one customer and this report needs to be grouped by the customer, but should also show the original Reporting company. Is that somehow possible in a report?

 

Thank you for all your help.

 

Conny