I have the following requirement:
As per the attachment, "1" would be my filter selection and "2" would be designed in Design tab: as per the screenshot "Total observations during Calendar Year" is a text used in Design tab and 7,759 is measure.
Now, is there any way that i can dynamically change the Text part (Calendar Year).
For example, from filter part if i choose Last Calendar Month then the text Calendar Year should be replaced Last Calendar Month. Likewise the text in the report should display as per the Prompt/filter selection.