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

Drop down for Webi - select two or more options

Hello all,

I am attempting to create a report where the data is manipulated using drop-down filters. However I want to be able to select two values (in this case e.g. [A and B]) in a dimension that will be shown on the table. Below is a visualisation:

DROP DOWN OPTIONS

  1. Drop1 ( A and B)
  2. Drop2 (B and C)
  3. Drop3 (C and A)

TABLE

When Drop1 is selected

Name FORECAST (FIRST LETTER)

FORECAST (SECOND LETTER)

VALUES A B VALUES 2 A B

When Drop2 is selected

Name FORECAST (FIRST LETTER)

FORECAST (SECOND LETTER)

VALUES B C VALUES 2 B C

and so on....

I look forward to your replies.

Kind Regards,

N

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2014 at 04:09 PM

    You can achieve this using a variable using the report filter function and using that to filter the data at block level.. Follow the steps below

    1. Create a dummy table with the dimension that you want to show for user to choose and create a input control on top of it. Then hide this table using a formula in the hide menu of the table

    2. Create a variable to capture user selection of dropdown in input control using =reportfilter([Dimension])

    3. Create another variable to utilize the result and build your logic using IF else condition for both column..

    example

    If [Variable for drop down] = "Drop1" then if [Column 1 ] = "A" or [Column 2 ] = "B" then 1

    else if [Variable for drop down] = "Drop2" then if [Column 1 ] = "B" or [Column 2 ] = "C" then 1 else 0

    4. Now create a block level filter on top the table that you want to show the record conditionally to only show the records where the variable created in the step 3 as 1...

    Once this is do you are all set..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.