New query based on column value

Good morning. Is it possible to create a drill down query based on a particular value in an existing query? For example, I have a count of clients per business category. I want to be able to click on that count and pass the category value to a list of the actual clients in that category. Thanks and have a great day.