7 Replies Latest reply on Jul 28, 2014 12:25 AM by Libitha Thinakaran

    Dynamic input values for Parameter

    Libitha Thinakaran

      Hello All,

       

      I have attached a workbook which has data for 2 events. Christmas 2013 and 2014.

      I have created 2 parameters- one for the event and another for the event dates.

       

      Currently selection shows, Event as "Christmas 2013" and corresponding dates(12/20/2013 to 12/26/2013) show up in the second parameter.

      Now my question is, When user selects another program say "Christmas 2014", i want to display corresponding dates(12/21/2014 to 12/27/2014) in the second parameter.

       

      How can this be accomplished?

       

      Thanks,

      Libitha