I am really surprised the Dynamic view is only capable to filter a single criteria where it should be more functional, practical tool and allow you to filter down multiple criteria or scenarios, just like a regular sheet or report. I currently struggle with all my team members who report to the us on Dynamic view to only show/filter those tickets need attention. e.g. I need to filter those rows (Greater than the value 100 & Less than 50) OR (I need to filter these rows when "Provider Supply Status" is either No or Partial) in the attached screenshot
..etc.