Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all two list boxes in one contains year values 2013,20140,2015 and other list box contains month values jan,feb,....dec.
Now my requirement is when i click on 2015 month list box should only jan feb and march
Thanks
Hi,
Go to the list box properties and select Hide excluded
in month filter give it as ,
=Aggr(Only( {< month= p(month) >}month),month)
hi
i tried but i need other than hide exclude option.
Hi!
I've tested Simson's approach and found it well except one particular thing.
There is a calendar table in my model with dates till 2015-12-31.
If I select 2015, I will see all of the 12 months.
I've just a little bit changed Simon's expression.
=Aggr(Only( {<month= p({$<date={'<=$(=date(today()))'}>}month) >}month),month)
Why want to just show those months do they have some conditional association with the years.
Yes !! sujeeth ,
it has to show only jan feb and march in 2015.
Hi ,
Is it possible for current problem
if(getcurrentselection(Year=2015),'jan','feb','mar')