Find the amount of the last transaction per client

[Anonymous]

Hi all

I have the following basic info: Client (multiple), Transaction Date (multiple per client, and multiple per day, but only max one per client per day), and Amount. I want a table showing me a list of clients with the last transaction date and amount.

Please can you help.

Thanks.

Joao

[tresesco · Accepted solution]

PFA

Amount: FirstSortedValue(Aggr( Sum(Amount),Client,TransDate), -TransDate)

Date: Date(Max(TransDate))

[Anonymous]

Genius!

Thank you so much.

Joao