How to return the value of a column in the last row?

[djmalaka]

Hi all,
I have created a slice out of a table called “Kidney”. In this “Kidney” table, there is a column called [Station], where user has filled in already with different hospital names in the country. What I want is to write a filter expression for the slice to just filter out the rows in the “Kidney” table to only display a set of rows that has the [Station] name decided by the user in a different table called “Analyser”. In the “Analyser” table also there is a column called [Station], and when the user selects a ‘Station’ name and saves it, I have written a behaviour expression to bring out a “Chart” that picks data from the “Kidney” table’s slice. So what I want is this filter expression inside the slice to have that particular ‘Station’ name for the [Station] column so that the Chart would only show relevant data for that ‘Station’.
I tried a few expressions including a LOOKUP, but didn’t work for me.
Since there’s no row level undersanding between these 2 tables, I guess the best way to bring up the filter expression is to call out the last filled row in the “Analyser” table. But how to write an expression for that? Would appreciate your help!