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.
- 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 |
- When NO customer Name is selected, filtering on account should only list that account.
Thanks
Roop
