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

10|10000 characters needed characters exceeded

### Related questions

• 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..