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
