Using Special Characters in Label of Pivot Table Measure

[hlines_usacs]

Hello,

I would like to add special characters to the Label of a Pivot Table measure.

My expression is Sum(Payments). I would like the label of that to be "  Payments" which is the word Payments with two spaces before the P. This would be chr(32)+chr(32)+"Payments". When I enter this into the Label text box, it just shows at "chr(32)+chr(32)+Payments".

I have also tried having an equal sign before but it just shows at literal text.

Is there a way to accomplish this, or does anyone have any other ideas?

Thanks!

[marcus_sommer]

With chr(32) was only the normal white-space charcter meant. Not to use a function within sense to create them else to create different white-space charcaters in tables or different tools and copying these chars into the label from sense.

- Marcus

[Wuzhong_Zhu]

+1 on answer from Marcus.

Some of the character: eg.[] shows as empty space In my client, but in shows as square in browsers. Depend on your text encoding I guess.

I would still recommend using underscore"__label name" instead of space.