Merging column titles using Bex

[lou_matura1]

I have a situations where I have set up for my columns, 2 key figures; Current Year Budget  and one for Budget Prior Year.  To complicate the situation, I have the the Descriptions as (due to versioning and changes on a period-by-period basis):

Budget Vers &PVAR_VERSION_001& as Current Year Budget.

Prior Period Budget Vers &PVAR_VERSION_001& for the prior period budget

My rows are revenue centers.  A new budget is done each period.  Each is named starting at B01, B02..., B12.

I have calculated the difference between the two columns and named it Current Budget vs. Prior Period Budget. What is would like to see as a result is, where budget B02 is current period, B01 is the prior period, for the column heading of the calculated (yes it is a formula):

Budget Vers B02 vs.

Prior Period Budget Version B01

Bear in mind, if this is run the following period, the result would be:

Budget Vers B02 vs.

Prior Period Budget Version B02

The calculated result is correct, it is the title that I have issues with.

I'm using Netweaver 7.x.

Thank you in advance.

Lou

[lou_matura1]

Thanks Narasa and Abhijeet.  My apologies for the delay in responding.  The client decided to go with Customer Exit text variables for this.

Lou

[Former Member]

If you are particular about title like 'B01', 'B02" etc. and providing Period as input, try with Text variable of type Customer Exit.

[Former Member]

I did this for one of my clients few years ago...Where we had to give combined heading for multiple columns in an integrated planning application. This is possible in web. You will have to write custom javascript code to add those columns above standard table....The stylesheets will take care of look and feel and user won't even know that the custom columns aren't part of standard BI tables....Works beautifully but every upgrade the technical IDs behind code generated in web application designer might change and you may land up doing some  maintenance.