Combobox filter to show ALL value

[Former Member]

Hi,

I have a requirement to get "All" values in both the combobox filters in the dashboard. Pls. refer the attached screenshot. Do not know how to upload xlf file.

Currently I have "Country" filter with values India and America and "Store" filter with values based on "Country" filter selection.

How to get "All" as a value in both "Country" and "Store"filters.

How to get,

Country ="All"

Store="All"   --- Chart should display all 4 stores sales

Country="All"

Store="Store A"  - Chart should display only Store A sales

Thanks in Advance,

Arun

[former_member190855 · Accepted solution]

Hi Arun

I helped another member recently with similar request... please refer to the thread

http://scn.sap.com/thread/3417765

Runali

[Former Member · Accepted solution]

Hi Runali,

I tried but I am unable to get for 'ALL' in one filter and 'different values' in another filter combination. May be another new table with all possible combinations should be created.

Can you please check the xlf file?

Regards,

Arun

All_ComboBox.txt.zip

[former_member190855 · Accepted solution]

HI Arun

Here are few changes, and you will get what you need

[former_member190855 · Accepted solution]

I added a 3rd combo box called hidden which will map to the formula column Sheet1!$J$4:$J$8 and filter the block with country selected by country combo box - via the default setting mapped to K2    

The hidden combobox places the filtered data in Sheet1!$O$4:$R$8 - the range has to be same as Sheet1!$J$4:$M$8 to accomodate ALL rows.

Then bind the Store combobox label to Sheet1!$Q$4:$Q$8 so that it picks up list based on country filter.

Destination will be Sheet1!$T$4:$U$4 which you will map to column chart.

I have added all the screenshots.

Please let me know if this resolves the issue.

Runali

[Former Member · Accepted solution]

Hi Runali,

Thanks it works for ALL - ALL combination.

I want the second combo box also to have the ALL value when I select "India" or "America" as well. So we can see the values grouped at country level. Now I have it only by store level.

The following combinations are missing now,

Country     Store

India          All

America     All

Thanks for your help.

All_ComboBox_v2.txt.zip

[former_member190855 · Accepted solution]

hI Arun

You can apply the same principle in the second combobox.

Runali

[former_member190855 · Accepted solution]

Hi Arun

If the solution is working, please mark the correct answer and close the thread.

Thank you!

Runali

[Former Member · Accepted solution]

Hi Runali,

I extended the same for Stores combo box also. Now I get all combinations.

Thanks a lot!

Regards,

Arun

[Former Member]

Hi Arun,

You can display the value 'All' in the combo box and send a 'blank' cell to your prompt value. (see image)

I set the prompt to "Optional Prompt" in the Query Browser and it works fine.

You can do this for all your combo boxes and use one query with multiple optional prompts.

Hope this helps

Gerrie

[Former Member]

Hi Runali and Gerrie,

Sorry I have not looked yet since I was in vacation. I will check it and reply you soon.

Thanks,

Arun

[Former Member]

Arun,

The 'All' option is available in our 'Multi Select Combo Box', which is part of our custom add-on component suite for Dashboards. You can check it out at http://www.visualbis.com/blogs/xcelsius/2012/09/18/multi-select-combo-box-for-sap-businessobjects-da...

Thanks.

[Former Member]

Hi Arun,

Try with option of Excel function using Vlookup. Use the reference as attched screen shot.

[Former Member]

Also this may be

http://funandrockin.blogspot.com/2011/04/xcelsius-all-selection-in-combo-box.html

Arun

[Former Member]

Hi,

Check this

http://scn.sap.com/message/6890903

Thanks,
Arun