Selecting rows without filtering

[Anonymous]

Hi All,

Can you please help me with this?

I have the following data

Account	Customer	Customer Name	Customer Name List
A001	C001	Tom Jerry	Tom Jerry
A002	C001	Tom Jerry	Tom Jerry, Luke Skywalker
A002	C002	Luke Skywalker	Tom Jerry, Luke Skywalker
A003	C001	Tom Jerry	Tom Jerry, Jane Jerry
A003	C003	Jane Jerry	Tom Jerry, Jane Jerry
A004	C004	Jack Tim	Jack Tim

And I have 2 filters, Account and Customer Name.

1. When the customer Name filter is on, selecting the account should only highlight the account.

For example, Customer Name filter is Tom Jerry, and selecting Account A002 highlights the row.

Account	Customer Name List
A001	Tom Jerry
A002	Tom Jerry, Luke Skywalker
A003	Tom Jerry, Jane Jerry

1. When NO customer Name is selected, filtering on account should only list that account.

Thanks

  Roop

[Anonymous]

Anyone can help on this?