4 Replies Latest reply on Jun 14, 2018 11:58 AM by ashish.tamboli

    dynamic Date filter and window calculation

    ashish.tamboli

      Hello team,

       

      i am having a text table which has multiple columns including a Date (Exact Date).

      There is date filter which allows user to select ending date.

      Also there is parameter which has values like -7 or -30 etc.

      so

      for eg if user selects ending date as 31st May 2018 and the parmaeter value selected is -7 then the data in the text table should be shown from 24th May to 30th May.

      or

      for eg if user selects ending date as 30th May 2018 and the parmaeter value selected is -7 then the data in the text table should be shown from 23rd May to 29th May.

       

      same goes for parameter value selection of -30.

       

      I tried with table function using windowmax and window min, but there is already a date filter applied on the sheet, hence window functions are not behaving properly(may be i  am doing something wrong).

      any help is appreciated.

      attached a sample worksheet.

       

      Regards