How to get only associated values in the list boxes by selecting a value in other list box?

[sn_9052]

Hi all,

I have three list boxes, Year, Month & Title.

I need to an expression where I need to get only associated values in Year & title, by selecting a value in Month.

Please help me out.

Thank You.

[sunny_talwar]

May be try this as your list box expressions

=Aggr(Only({1<Month = p(Month)>} Year), Year)

=Aggr(Only({1<Month = p(Month)>} title), title)

[Peter_Cammaert]

Every listbox has a property called "Hide excluded". Enabling this checkbox will hide all grey values from the current listbox.

[Anonymous]

use CTRL + T and post a screenshot of your data structure please...

[sn_9052]

Hi,

I checked Hide Excluded Option, But still its showing the Empty Grey Color along with Associated values.

Regards,

Hasini

[sn_9052]

Hi,

Please find the below snap, I implemented that function but still it showing Empty grey color along with associated value.

[sn_9052]

Hi,

Please find the below  data structure.

[sunny_talwar]

This needs to go on the general tab and not the expressions tab

[sn_9052]

Hurreh.....

Thank You soo much Sunny.. Its Working now.

Thanks  a lot.

[sunny_talwar]

Awesome