Changing Field Name Dynamically without Script Load
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?