I'm reading over your post and looking at your screenshot, but I'm not sure exactly what you need help with. Can you provide a twbx (packaged workbook) that shows what you've worked on so far, and maybe some more details about where you are stuck?
Appreciate your response, I have actually built a worksheet. Unfortunately I will not be able to share any data or info , below is a screenshot. 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...)
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.
there isn't really a way to combine filter using 'or' operator, you are right that it does default to AND.
You can check our Community Ideas for a similar suggestion and vote it up, or add one.