1 of 1 people found this helpful
Yep. Create the Parameter as a String with the values you want people to choose from.
Then create a calculated field that creates the title string:
If [UserParam] = "Option1" then "Title for Option 1"
ElseIf [UserParam] = "Option2" then "Option 2 Title"
Then put this calculated field on the level of detail. Then when you edit the title, you will have the option to insert this field into the title text. You can format it and add other text around it aswell.
This didn't work, when i typed in the formula i got an error message, and what do i even do if after i create the calculated field? Do you have a sample workbook?
Is it possible to change 'to' in <Date> measurement into 'between' or any other wording possibilities?
Thank you in advance.