Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
something like this
Date(Aggr(max({<DateOut={">=$(=Min(DateIn))"}>}DateOut), DateOut))
replace Dateout with Table1Date and DateIn with Table2Date fields
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.
Thank you. I got it to work.
I wrote it for Filter pane.
You may use similar for table you look for.