13 Replies Latest reply: Apr 17, 2012 4:43 AM by Joaquin Lucas RSS

    Text alignment in a pivot table header

    Joaquin Lucas

      Hi,

       

      I need to align the header text to the right in a table for an expression name. I included the character chr(13) and after this I can't get the text aligned to the right as you can see in the attached image.

       

      The expression for the expression label is: ='Gross Amount' & Chr(10) & ' £k'

       

      Any idea?

       

      Thank you.