using FirstSortedValue function with other source data

[fernandorech]

Hello,

I have two tables: client and phonecalls

clients table stores all clients

the phonecalls table stores all outgoing calls

my question is, how to insert on table's client the latest attempt phone call

Ex:

below the last_phone_call for "erik" should be "13-07-2019 11:00"

for "evan "should be "22-06-2019 10:00"

client table

ID	NAME	last_phone_call
1	erik
2	evan

phonecalls table

id_client	phonecall_date
1	01-04-2019 15:00
2	05-04-2019 9:00
2	22-06-2019 10:00
1	13-07-2019 11:00

[Frank_Hartmann]

see attached qvw

hope this helps

[SumitaKumari]

Try this :

=Aggr(Max(phonecall_date),NAME)