Text alignment in a pivot table header

[j_nlucas]

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.

[jagan]

Hi,

I given this as label

='Gross Amount' &  '  £k'

and set

Chart Properties -> Presentation - > and set Wrap Header Text  Header lines as 3 (By default is 2)

Regards,

Jagan.

[j_nlucas]

Hi Jagan,

The problem with that is that it only fills two lines even though it is set to three, and there are more fields with the same format and it wouldn't work for all of them as they have different lenght.

Regards

Lucas

[Anonymous]

Hi

     You just look jagan solution 

     ='Gross Amount' &  '  £k'  ,

     He just leave some blank space based on the length.

     You just try to use some blank space in the text to wrap the label value into 3 lines.

As the same time fix this too,

Chart Properties -> Presentation - > and set Wrap Header Text  Header lines as 3 (By default is 2)

Regards

Ashok

[j_nlucas]

Hi Ashok  thanks for your reply. I am afraid that that does not solve the problem either...

[rajni_batra]

Is the alignment of header in right in presentation tab  also not working???

[Anonymous]

Hi

     Hope the attached file will be solve  your doubt

Regards

Ashok

[rajni_batra]

anything wrong with this??

[Anonymous]

Hi

     This is(attached Image) you want right and i hope i solve your problem.

Regards

Ashok

[j_nlucas]

Hi Ashok, is that gap at the right of the word "amount" in your file and mine, what I am trying eliminate. Regards