Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have created a group within a dimension in chart properties, I have 5 different selections that the user can
choose to change the dimensions.
I would like the chart title to change according to the user selected dimension(1 of the 5 choices) from within the group.
How do i do this ?
TIA
Hi,
use
=GetCurrentField([group name])
Good luck!
Rainer
in the title
put the formula getcurrentfield(YourGroupName)
Hi in chart properties write in window title
= ' YOUT TITLE ' & yourdimension
I am putting what you suggested:
=GetCurrentField([group name])
in the expression after I click "show title in chart".
I could not find the group I created from within the Edit expression/Fields/Field
Please advise
Actually I want the TITLE to be in the General Tab/ Window Title.
But either way in the expression I am not able to find the Group I created so I can select that in
the expression you suggested
How do I put a static string field before the expression you gave me.
example: FY09 Chart for: GROUP NAME EXPRESSION THAT YOU GAVE ME.
(btw, the expression works.)
Hi,
type your group name into the brackets like
=GetCurrentField([TimeDrill])
as example.
Add text do the following: ='Your text: ' &GetCurrentField([TimeDrill]
Hope it helps.
Rainer
THANK YOU
Hey Rainer
your answer has been helpful, however I'm still having a small issue, where I've edited the Label of the fields in the Group settings. ie original field name "Charge_cust", and i edited the label to "customer"..
when executing the code as per example, it displays the original field name instead of the edited label name.
else where int he chart is displaying the edited label name.
any pointers would be great.
Thanks.
Bon.