Escape character for special character in Calculated Dimensions

[#1]

Is there an escape character for special character in Calculated Dimensions (in Pivot Table), similar to \ for Python strings ?

I heard that I can use Chr(n) for special character in the script, but this is not working for calculated dimensions...

Thanks in advance

[hic]

No, there is none (yet). What do you want to do?

HIC

[#3]

thanks for reply

I would like to have in a calculated dimension a pick(match('Val1', 'Val2'),'Rep1','Rep2') where 'Rep1' is a string including a single quote, for instance 'Game O'Game'

Thanks

[hic]

Just write the single quote twice, and it should work. Like 'Game O''Game'

HIC

[#5]

Thanks i will try so