Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to put the cyclic or drilldown selection value in the title of a chart ?
I have a drilldown group as a dimension in a chart and based on the values of the group, I want to show the same in the chart title.
so based on the next drilldown level, the title should change to 'Count per subunit' ...
In your title put:
='Count by ' & GetFieldSelection('yourgrouphere')
I think it's GetFieldSelection() you need to use - check the F1 help for the other similar functions if not. One of them definitely works! The key is to put your group name in the single quotes.
Hope this helps,
Jason
Hi,
Lets say you have a drill down group called 'DD_Year_Month' .
To display the values of the current selection you can use the following.
subfield(GetCurrentSelections('DD_Year_Month'),': ',2)
Hi,
By using subfield function, you will also be able to get the Selected Field Name.
Hope this helps you.
Regards
Hudson
Hi
Use ='Count by ' GetCurrentField('GroupName')
(Returns the name of the currently active field in a group. )
Kind Regards,
Footsie
GetCurrentField() - that's the one!! (Knew it was one of them...)
count per & GetCurrentfield(drilldown name) should work.Put the drilldown name without any single or double quotes
It worked for me, but without the quotes ('').
Hi,
GetCurrentField ("Cyclic group")