Display latest entered row

[tatiya]

I have billing data of all my customers in a single sheet for last 1 year. Every customer will have arround 20 to 30 entries. I want to display only the entry/row which was last added.
Note all data is in 1 Sheet only.

eg:
Customer Invoice-No. invoice-date
Wallmart 0121 10Jan2019
Wallmart 0121 15Jan2019
Wallmart 0121 19Jan2019
Wallmart 0121 20Jan2019
Wallmart 0121 25Jan2019
Amazon 0123 1Jan2019
Amazon 0123 11Jan2019
Amazon 0123 15Jan2019
Amazon 0123 18Jan2019

I want to display only the latest entered Row which is Wallmart 25th Jan and Amazon 18th jan.

Aim is for my Sales person to know how many days back was the last order given by customer.

[Aleksi]

You could add a virtual column with a formula MAXROW() which will give you the key column’s value as a result. Then you can filter the data with the slice like [VirtualMaxRowColumnName]=[KeyColumnName].

Check this article how to work with MAXROW… https://help.appsheet.com/articles/2357310-maxrow

[tatiya]

I used [RowWithMaxDate]=[Invoice No.] for Slice where RowWithMaxDate is virtual column with formula MAXROW(Sale report,“date”, TRUE)

This Displays only 1 Row with Latest date. For eg in this case
Wallmart 0121 25Jan2019

Other Fields are not displayed. There is still something I am missing.

[Aleksi · Accepted solution]

Instead of using TRUE, use [Customer]=[_THISROW].[Customer]

[tatiya]

Cheers It has worked. Thanks a Ton. May be I will have have to study what the additional formula means.

[Aleksi]

Check that MAXROW article. There is a sample that is doing the same thing.