11 Replies Latest reply: Sep 19, 2016 12:08 AM by Wuzhong Zhu RSS

    Using Special Characters in Label of Pivot Table Measure

    Hannah Lines

      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!