Dynamic Chart Title

[MikeJones]

Hi, I wish to dynamically have the names for the team leaders shown in the chart.  I am using the filter Resource Manager and I have chosen Lewis.  The ResourceTeamLeader shows Darren etc unchecked

The chart for Team Leaders title uses ='Tins for Team Leaders :' & GetFieldSelections(ResourceTeamLeader)

When I click on Darren, Lee.... they do appear in the title.  However, I don't want to be doing this.

Thanks for your help.

[chrismarlow]

Hi,

Maybe try;

='Tins for Team Leaders :' & Concat(DISTINCT ResourceTeamLeader,',')

Cheers,

Chris.

[MikeJones · Accepted solution]

Chris, many thanks for your help.