Filter data based off selection in a table

[#1]

Hi -

I have a table which I can filter using the filter pane. I have another table and I want to filter data in the second table based off the selection in the first table. How do I do that?

For eg Table 1:                                Table 2:

1/1/2016                                             1/5/2016

2/1/2016                                              5/5/2016   

3/1/2016                                                2/15/2016

4/4/2016

And I want to show all the rows that have data greater than the selection from table 1.

So if I select 2/1/2016 from table 1, table 2 data should filter to 5/5/2016 and 2/15/2016.

Thanks, Shilpi

[girirajsinh]

something like this

Date(Aggr(max({<DateOut={">=$(=Min(DateIn))"}>}DateOut), DateOut))

replace Dateout with Table1Date and DateIn with Table2Date fields

[#3]

Thanks Girirajsinh.

Do I put that in the column expression? or Filter Pane? When I use that expression, I do see the filtered data, but I need the data in my second table to filter per the selection.

[#4]

Thank you. I got it to work.

[girirajsinh]

I wrote it for Filter pane.

You may use similar for table you look for.