cancel
Showing results for 
Search instead for 
Did you mean: 

Change the column header according to the filter value ?

Former Member
0 Kudos

Hello Experts,

I have a requirement in which the customer wants to change the column header of the Sales Volume Key Figure to change according to the filter selected for the Calender Year / Month in the Free characteristics.

I could display the header as 'Sales Volume for OCT 2000' as this is the value restricted intially in the free characteristics for Calender Year / Month.

Any suggestion is appreciated.

Thanks,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

It should work by creating a text variable and a replacement path

Former Member
0 Kudos

Ioan Thanks for the reply.

Probably my previous explanation of the problem was a little incomplete. Let me give a better description.

The situation is something like this.

I have a requirement in which the customer wants the column header to reflect the 'keep filter value' restriction that he does dynamically in the query report.

i.e:

-- usually the kf column header shows 'sales volume'

-- column header with text variable of the Calender year / month variable -- 'sales volume for 2000 oct'

-- but when the report is run, if the user wants to go and change the filter: calender year / month > rt clk > keep filer value > select Jan 2003.

The kf column header still shows 'Sales Volume 2000 Oct'

How to make the column header change to 'sales volume for Jan 2003' ?

Any suggestions greatly appreciated.

Thanks,