How can I create a filter or button to filter along 2 fields?
I want to create a filter or button that can filter on 2 fields based on different parameters. For example, given stage and date being 2 separate fields, I would like the data to filter if in stage x and date within 6 months or if in stage y and date within 4 months or stage z and date within 2 months. I have had success filter by either stage or date but am having trouble trying to connect the two. The issue I have is want the filter to highlight all 3 of these given conditions, so when the filter or button is activated it grabs the x in 6 months, y in 4 months, and z in 2 months and displays them all in the same table.
