I would like to convert content of the string, For example
Group field has
MTS X series
MTS y Series
MTS Web Series
I need to standardize the value to
Multiple X Series
Multiple Y Seris
Multiple Web Series
I tried Replace function.. Didn't work...Can you please help me which function I can use it to get this value..
Build a calculated field: Corrected Group:
Use it instead of Group dimension.
Hope it helps.