Dynamic title

[rcorcoran]

Hi

I want to put this in a chart title to show the Hospital group and the year that is selected and it works fine but I also want it to show if 'Hospital' is picked as a selection so either hospital or hospital group will  be selected and the year and then the title should show these

I have tried all sorts of and or expressions but it doesnt seem to work

=GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)

[Gysbert_Wassenaar]

GetFieldSelections only returns values that are actually selected. As long as there's only one possible value you can use something like =only(HospitalGroup). Otherwise try concat(distinct HospitalGroup, ' / ')

[#3 · Accepted solution]

Hi Rhona,

If i understand well, if Hospital is selected you want hospital name, if not you want Hospital group selected

=if(count(distinct  Hospital)=1,
GetFieldSelections(Hospital)& ' , ' & GetFieldSelections(ReferredYYYY) ,

GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)

)

best regard

Chris

[rcorcoran]

thanks to all and to Chris that is great.