Skip to Content
author's profile photo Former Member
Former Member

Change the column header according to the filter value ?

Posted on Jul 19, 2004 at 04:06 PM 11 Views

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,

BW Business Explorer (SAP BEx) Mining Oil and Gas BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2004 at 05:17 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jul 20, 2004 at 02:43 PM

      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,