5 Replies Latest reply: Aug 9, 2011 9:06 AM by Siarhei Karpusenka RSS

    Filtering a table based on a calculated field

      I have a table e.g.

       

      EngineerSubjectCreatedDays
      Engineer NameDocument explaining how to 18/04/201127
      Engineer Namereport on 27/07/20114
      Engineer NameStatus Refresh 07/06/20111

       

      The "Days" column is a calculated field

       

      I have created a new input box on the Sheet and assign the value entered to the variable $DaysSinceLastUpdate

       

      I would like to filter the rows displayed in the table so that only the rows with a value in the "Days" column that matches the value in the variable $DaysSinceLastUpdate are displayed

       

      So if I entered "4" in my input box the only row displayed in the table would be

       

      EngineerSubjectCreatedDays
      Engineer Namereport on 27/07/20114