Forum Discussion
Anonymous
5 years agoNot applicable
Filtering a table based on another table's filter
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
pls see the attachment below