Filtering a table based on another table's filter

[Anonymous]

Hi,

I am working with one data set that has information on several states. For example: 

State	Var1	Var2
Iowa	x1	y1
California	x2	y2
Arkansas	x3	y3

In the report, I have a table with a filter for the state column, so I can only see the information for one state. I want my second table to display the information for another state based on the selection for table 1. For example, if table 1 is filtered for "Iowa", the second table should be for "California" whereas if table 1 is for "Arkansas", table 2 should be for "Iowa". 

Thank you for all your help! 

[Anonymous]

Hi, 

Is there any way to perform this without duplicating the table? I am working with a large dataset and it would make the model very slow. 

Thank you

[Anonymous]

Thank you! 

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@Anonymous 

pls see the attachment below