Get a value from a specific cell based on the filter

[vpanzagarcia]

Hello, I'm using SAS VA 7.1 and I need to get a value from a cell based on the filtering.

For example, i have this rows:

Group | Name | Product

A         | Oli      |  Gold

B         | Mike   |  Sand

A         | Leon   |  Coal

C         | Toni    |  Oil

B         | Alex    |  Silver

On my "Text Introduction" filter, I want to write, for example "Leon" and doing that, filter Leon

But, on a specific list table, i want to show every row that contains the same Group as Leon(the filtered field).

Showing this:

List table 1:

Group | Name | Product

A         | Leon   |  Coal

List table 2:

Group | Name | Product

A         | Oli      |  Gold

A         | Leon   |  Coal

I hope you can help me.

Thanks