Exclusion From ListBox

[vanderson009]

Hi folk,

I have Year field on my Dashbord,

I have taken Year field twice time, Suppose i click on one Year listsbox then,

I want second ListBox showing irrelivant Data.

For example... Year :- 2007,2008,2009,2010,2011,2012,2013

If i select 2007 On ListBox1 then Second ListBox Shown 2008,2009,2010,2011,2012,2013

Regards,

Villyee

[MayilVahanan · Accepted solution]

Hi

Are you looking for this?

[vanderson009]

Hi Mayil,

Yes U right......

But How u did it??

Regards,

Villeyy

[MayilVahanan]

Hi

Check in this

Setting -> Document properties -> Trigger -> Field Event Triggers -> OnSelect

[#5]

Hi,

Try below:

For the second list box, use the below expression:

=Aggr(Only({<Year= e({<Year= {$(=GetFieldSelections(Year,',',20))}>})>} Year), Year)