Forgive if this is a basic question, but I'm looking for a way to create rich filters that can reference a look-up type of query. For instance, I have 4 teams with 5-6 individuals on each team that will be assignees. Rather than creating a filter that I have to enter in each team member's name to get all work assigned to the team, I'd like for the system to recognize which team the assignee is on and create my query with the team name instead.
Is this a possibility and if so, how would the filter be created?