3 Replies Latest reply: Apr 21, 2017 9:27 AM by Kaushik Solanki RSS

    Depending list boxes

    Sven Stachelhaus

      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/15GJ 15 /16GJ 16 / 17
      201409201509201609
      201410201510201610
      201411201511201612
      201412201512201701
      201501201601201702
      201502201602201703
      201503201603201704
      201504201604
      201505201605
      201506201606
      201507201607
      201508201608

       

      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