Skip to Content

Logic for Drop Down Combo Box

Jan 23, 2017 at 02:29 PM


avatar image


I am trying to implement a logic in two combo boxes in Xcelsius. One is for Quarter and another is for the Months falling in that quarter.

If a user selects 'ALL', in Quarter combo box, Months combo box should display ALL only. If user selects Q1, month Combo box should display ALL, April, May, June respectively. When user selects April/May etc, the graph should be drill down accordingly.

Bex query is the source and it does not have 'ALL' in data, for quarters 1,2,3,4 is the value and for months also only numbers. So What could be the solution for this ? I have designed it but for Month selection I am using IF condition for each month in nested but after 7 nested ifs I can't use more as it's the limitation with excel. Please help.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers