Changing Field Name Dynamically without Script Load

[triekong]

i have a field in my dataset called 'sales.DryFruits' which i change in my script load to [Dry Fruits].

i have created a group in my chart called [Items] which is made up of 2 fields: [Dry Fruits] and [Flowers]

in my Chart Title i am changing the field dynamically by using the group 'Items', with the formula:

='Current Sales per ' & ' ' & GetCurrentField([Items])

Problem: in the label, i am trying to make it say [Fruits] instead of [Dry Fruit] without changing it in the Script Load. i want the field in the label to say [Fruit] but everywhere else in the report to say [Dry Fruits].

is there a formula or expression i can use to change this field dynamically in the Title bar? or maybe a workaround without using the script load?

thanks!

[sunny_talwar · Accepted solution]

May be this

='Current Sales per ' & ' ' & If(GetCurrentField([Items]) = 'Dry Fruits', 'Fruit', GetCurrentField([Items]))

[vishsaggi]

May be this? Check attached.

[triekong]

Thank you very much! it worked