Include Drill Downs in filter results

Nick

Hi everyone,

I want to make a table of users and groups, where the groups consist of multiple users and can be displayed in the drill down. However, I want the built in filtering to include the users inside the groups in the filtering results.

So if I have:

User Chris
User Steve
User Rajesh
Group Sales
User Charles
User Basant

I want User Chris and Group Sales returned when "Ch" is entered in the filter box, and Group Sales returned when "Ba" or "Sa" is entered.

Bonus points if you can make the drill down automatically open and highlight the user if it only matches one in a group, though I think I can handle that given the filtering.

Thanks!!