Qrew LegendLet's start with ther basics to see if there is an easy answer.
On this Relationship Projects>Project Members
You can create a combined text summary field to summarize the Contact Names.
Then make a field called perhaps [Contacts (DF)] (ie Dynamic Filter).
Formula Multi Select Text
Split(ToText([my combined text summary field]))
You will find that that field will work as a Dynamic Filter allowing one or more unique contacts to be selected. You can the look up that field down from Projects to Opportunities and use it as a Dynamic Filter on your chart report.
Understood but can formula queries work with dynamic filters. I thought they dont support that and would not filter the data based on the dynamic filter since the query is explicitly pulling records? Or do I need to use that field in the query itself?
