Hello,

I'm trying to create reports for our stats, and I can't figure out how to fine tune the filters in the pivot tables.

Right now the filters that I'm adding are an all or nothing sort of thing.  I want to be able to use the and/or options (like in other filters on Zoho Creator)... but for the pivot tables it seems I can only do the "and" filters.  

For example, I am doing a quarterly report and I want to basicly filter for: status = active OR status = discharged AND discharge date = Jan 1 - March 31, 2019.  As it stands, adding the filters only lets me add to it, but not specify any "OR" criteria.  Is there some way to do this?? 

I can do the filters for the charts added directly onto a Page - but, these charts are very limiting, and don't give me the same level of detail or view that I get from creating a full report.  But the full reports don't let me have the same filter functionality.  I hope someone knows of a way around this!?!