Slice filter

[Tommyfish29]

hi.  Im newbie

table = people

sheet = activity

i have a table that has id, name , loan, payments, balance, date/time

i need a slice filter to only show the last entry for each name.  Now it shows every row so the same name shows up more than once.

i just want the balance for each name to be the list returned 

[Suvrutt_Gurjar]

---

@Tommyfish29 wrote:

i need a slice filter to only show the last entry for each name

---

Please try with a slice filter expression something like below. Please replace table and column names as actual you have.

[ID]= MAXROW("Table Name", "Date/Time", [Name]=[_THISROW].[Name])

MAXROW() - AppSheet Help

[Tommyfish29]

Hi thanks

it didnt work. Still shows same name more than once.  Name is a "ref" from another table.  Is that what is making it not work?

[Suvrutt_Gurjar]

In general, it should not be an issue if you have used the reference column name in the expression. You may want to share more details of the expression screenshots etc. You may also want to take a look at the help article shared on MAXROW()