Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
+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.