1 Reply Latest reply on Aug 12, 2016 7:40 AM by Michael Hesser

    Filter a row by two columns, depending on a parameterized date

    savas.ziplies

      Hi everyone

       

      I am looking at the following case:

      I have multiple entries/rows of data. There exists two columns with the same values, Pre and Post. The values are A, B, C, and X in both columns. Each row also has a date column.

       

      Now, I would like to add two filters, for Pre and Post. For both you should be able to select A, B, C, and X, independently from each other. The difference should be: In case of Pre, only columns should be filtered based on the made choices, which are before the date column date. And for the Post accordingly after the date.

       

      I cannot see it right now how this is possible.

       

       

       

      Thanks a lot in advance for any help