I have three tables. One of them is the line items table. Now I have a list view based on this line items table.
In this layout I have five fields placed: "from" "until" (from line items table), "name" and "status" from tableA and "name" from tableB. There are several records where the "status" is "active" and the fields "from" and "until" are filled with data. Now I want to filter this list that there is only one record per "name" displayed and the "until" date is the most recent date (the newest date).
Thank you for any help!