Creating cascading combo Box

[system]

Hi All,

I have to create a two cascading combo boxes.

There are 4 choices in the first combo and
based on the item selected , variable number of options in second

e.g for A1=1 , value of second combo box is A, B , C

and for A1=2 , its D, F , E , J , H …etc.

I applied the logic given by Gaffika in the link

Cascading combo box

Hi All, Like many others I too amo very new to Xcelcius and need your help desperately. My data set is like: Sales sector Business Unit Country Gross Margin Automotive Longs France 100 Automotive UK Portugal 200 RAIL Longs Norway 300 There should be 2 filters Sales sector and Business Unit (I cannot achieve this functionality using filters as there can be multiple rows for a particular sales sector and BU combina…

Though I am able to get the result but only problem left is …for option whose second combo box values are less get 0 for the remaining values.

How can I eliminate these zeroes…

I want to get only valid values.

Regards
Ashu

---

leoashu (BOB member since 2010-08-06)

[system]

Hi,

Looking forward for a response.

Hey guys kindly help.

Regards

---

leoashu (BOB member since 2010-08-06)

[system]

To eliminate the zero values, simply make sure the cells (in the excel spreadsheet) are ‘blank’ (="") when there is no option to be selected, and turn on ‘ignore blank cells’ in the combobox’s properties.

---

gaffika (BOB member since 2012-08-10)