Using an expression to add text to a chart title

[Anonymous]

I am using the following expression to add dynamic text to a chart title -

='Full breakdown of the number of entrants from,  ' & region

I would like to alter the expression to show the 'region' OR the 'institution' if a specific institution is selected.

I'm not very good with IF statements or programming in general.  Is there an easy way to do this?

Thanks

Greg

[marcus_sommer · Accepted solution]

You could try something like this:

='Full breakdown of the number of entrants from,  ' & if(getselectedcount(institution) = 1, institution, region)

- Marcus

[Anonymous]

Thanks Marcus.  I'm very grateful.

Greg

[maxgro]

this is to show the institution if one instititution is selected (getselectedcount), else the regions

='Full breakdown of the number of entrants from,  ' & if(GetSelectedCount(institution)=1, institution, concat(distinct region, ', '))