Help me in displaying the latest record in straight table?

[durgabhavani]

Hi All,

Help me in displaying only latest record based on date for distinct customers.

please find attached sample.

thanks,

Durga

[miguelbraga]

Why not using a pivot table?

Check if this solve your problem.

Regards,

MB

[Anonymous]

if you use this expression

aggr(Max(date),business)

you get this result

that's what you want?

[durgabhavani]

It is not solving the problem. i need to show only one customer id having the latest date. here it is showing three records for 123 id.

i need to show 123 abc10/25/2015 record. no other records for 123 id.

[durgabhavani]

my expected output like to below.

Id	business	date
123	abc	10/25/2015
456	abc	9/26/2015
789	lmn	8/10/2015

help me to get it

[miguelbraga]

Try this out:

=aggr(Max(date),Id)

[Anonymous]

maybe like that

use this Expression aggr(Max(date),Id)

[miguelbraga · Accepted solution]

Here have a look:

[durgabhavani]

Thanks rudolf and MB.

it is working perfect.

[miguelbraga]

No problem, have a good job and a great weekend