Skip to Content
avatar image
Former Member

Display a column Based on variable input

Hi ,

I have a requirement where i have to display a key figure in a column based on the input of the variable screen.

For example if the user enters the customer X in the customer name variable.

The report should contain an extra key figure as a column.

Thanks

VRVJ1

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 20, 2010 at 06:18 PM

    not clear about the requirement. what is the relationship between the extra column key figure and the customer entered in the variable screen?

    can you explain in detail abt the requirement?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2010 at 09:34 PM

    Hi VRVJ1,

    first of all, create this formula variable and hide this as a key figure in the query (Can be shown).

    Then create a condition based on this key figure and activate it to a view only using this key figure.

    Then you can insert this view right to the normal query and create a workbook to get what you wants.

    Regards,

    Feng

    Add comment
    10|10000 characters needed characters exceeded