Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have used expressions before for my chart titles which include a specific user selection alongside my text e.g. -
='The number and proportion of entrants to STEM courses,
' &institution &', ' & year
I would like to show other user selections in the chart title too. What is the best way to do this?
Thanks
Greg
in this case I would use getfieldselections (at least the most important ones)
='text blabla ' & getfieldselections(A) & '-' getfieldselections(B) & '-' getfieldselections(C)
you can use
GetFieldSelections(yourselectionfield)
e.g. ='seleciton A: ' & GetFieldSelections(A)
that what you want?
I don't think so. I just want to list in the title of the chart all the selections a user has made.
Thanks
Greg
try this
GetCurrentSelections()
look at: getcurrentselections()
depending of number of selections, I would not show it in title
but maybe ist what you are looking for?
I THINK GetCurrentSelections will work
"I just want to list in the title of the chart all the selections a user has made" you mean all the fields selected ??
if so try with the Getcurrentselection()
Thanks But this also shows the name of the field as well as the selection. Is there a way just to show the selection.
Greg
in this case I would use getfieldselections (at least the most important ones)
='text blabla ' & getfieldselections(A) & '-' getfieldselections(B) & '-' getfieldselections(C)
I don't think we have function like that , you need to make use of multiple getfieldselection() function to achieve this but having the field name with the selection is more informative rite ?? because if 2 fields have similar values then without the field name , end user might get confused in which field he has made the selection