I have a report that includes a FosterIntake Date and a FosterDischarge Date. I want users to view the number of youth that entered the program this year (2024) - Year of FosterIntake, and the number of youth that were discharged from the program this year (2024) - Year of FosterDischarge. I can only apply the filter to one field but not both. When I do, no data is displayed. I suspect this is because I need to insert an SQL criteria statement across both FosterIntake and FosterDischarge fields, e.g. 

However, there is not a way to insert these criteria across both FosterIntake and FosterDischarge fields. 

Moreover, I want to enable user filters because my staff using the reports don't know SQL. I attached an image of my report. Is there a way to insert SQL in a Pivot view? 

Or do I need to export Zoho tables into Microsoft Access to customize user queries?