Report grouping by elements in a multiselect list

Report grouping by elements in a multiselect list

Hello,

I have created 2 forms:
  • Phases (ex. P1, P2, P3)
  • Initiatives, containing initiatives and a multiselect lookup with phases that the initiatives belong to (ex I1 ->P1, P2 and I2 -> P2, P3)
Now I want to create a report that displays:
  • Individual phases (as grouping category)
  • Initiatives
And which should show me:
  • P1 -> I1
  • P2 -> I1, I2
  • P3 -> I2

My report produces a grouping category that includes all phases:

  • P1,P2 ->I1
  • P2,P3 ->I2

Can you please help me ?

Norman