Expression Labels

[pkelly]

Currently working on a pivot table...

The title for the column in the attached picture is made up from the following...

='£ : ' & varQuarter_Label & ' ' & varCurrentFinancialYear & ' - ' & varQuarter_Label & ' ' & varLastFinancialYear & ' GP'

What I want to show is....

£ : Q1 2010 -

Q1 2009 GP

Have tried mucking about with spacing between the '-' sign with noc success.

Is there anyway to force a new line at a certain point in the expression title?

[disqr_rm · Accepted solution]

Try adding a carriage return chr(10) or chr(13) manually:

='£ : ' & varQuarter_Label & ' ' & varCurrentFinancialYear & ' - ' & chr(10) & varQuarter_Label & ' ' & varLastFinancialYear & ' GP'

[pkelly]

Many Thanks Rakesh - I was hoping it would be something straightforward like this...