Depending list boxes

[Anonymous]

Hi,

I'm currently struggling with depending list boxes in my dash board, my plan is to have a user friendly calender based on our business year.

There are three business years

GJ 14/15	GJ 15 /16	GJ 16 / 17
201409	201509	201609
201410	201510	201610
201411	201511	201612
201412	201512	201701
201501	201601	201702
201502	201602	201703
201503	201603	201704
201504	201604
201505	201605
201506	201606
201507	201607
201508	201608

It looks like following

I can select between the business years and I have the month range below, this is working due to this formular in the list box of the month range

=aggr(only({<BusinessYear= P(BusinessYear)>}PostingYearMonth),PostingYearMonth)

If I would only use the

= PostingYearMonth

then I would get all Months from all business years. So the formular is mostly working except when I select one month, then all other months disapears

It would be greate if someone could give me a hint how to change the formular form this listbox to have the other months available, of course base of the selected business year.

I'm grateful for any suggestions.

Many thanks in advance.

Kind regards,

Sven

[kaushiknsolanki · Accepted solution]

Hot sure but you can try this.

=aggr(only({1<BusinessYear= P(BusinessYear)>}PostingYearMonth),PostingYearMonth)

Regards,

Kaushik Solanki

[Anonymous]

Indeed, with the 1 it is working like a dream 🙂

Big props to you!

[kaushiknsolanki]

Great,

Kindly mark the post as correct.

Regards,

Kaushik Solanki