Get a value from a specific cell based on the filter

vpanzagarcia — Wed, 03 Apr 2019 15:14:08 GMT

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

topic Get a value from a specific cell based on the filter in SAS Visual Analytics