2 Replies Latest reply on Jul 11, 2018 3:09 PM by Peter Fakan

    Filter 'OR' instead of 'AND'

    Jay Jesus

      Appreciate your response, I have actually built a worksheet. Unfortunately I will not be able to share any data or info. This worksheet consists Case id, Issue Id and other columns of data. I do have 7 columns of data which have the summary information displayed as filters to the right, the users would like to filter on keyword selections on the 7 different summary columns ( lied, misled, UDAAP, bankruptcy, deceptive etc...)

       

      Question ?

       

      Will I be able to have the filters as 'OR' as users could input filtering criteria on multiple columns and would like to see all data (matching the filters), I am assuming the current filters are executed by 'and' operation.