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.