Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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: 

StateVar1Var2
Iowax1y1
Californiax2

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! 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you! 

  • Anonymous's avatar
    Anonymous
    Not applicable

    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