4 Replies Latest reply on Dec 21, 2016 4:21 AM by zack.cocker

    Filter Adjustments

    zack.cocker

      Hi All

       

      I am working with some simple data that is broken down by Year.

       

      I have a Filter in the data for Year which contains:

      S16

      S17

      W16

      W17

       

      I am trying to work out the best way to add to that filter an option called "Present" which when the users selects will filter to "W16, S17 & W17" and exclude "S16" as S16 is in the past.

       

      I wanted to do it without having to duplicate data in the data source as its already a big file. Just wondering if anyone knows a way in which I can add this option to the filter.

       

      Ideally I would like the filter to show the following as options;

      Present

      S16

      S17

      W16

      W17


      This will then allow the user to select either a specific season or select Present which will then show all the data that relates to the current seasons that have not yet passed.

       

      Thanks