Field content according last date

[#1]

Hi everybody,

here is a simple problem (i'm sure) i can't solve.

I want to display the status corresponding to the last date for each Name

Aggr function seems to give the right result but ONLY if status are the same.

My goal is to fill Status with the value according the last date

Thank you for your help

best regards

chris

[jerem1234]

Do u want as expression or calculated dimension?

For expression and with Name as a Dimension, any one of these expressions should do the job:

=firstsortedvalue(Status,-Date)

=subfield(concat(Status,'|',-Date),'|',1)

=Concat(IF(aggr(Rank(Date),Name,Date)=1,Status))

If you want as calculated dimension with Name as Dimension:

=IF(aggr(Rank(Date),Name,Date)=1,Status)

Hope this helps!

[MayilVahanan]

Hi

Try like this

=firstsortedvalue(Status,-Date)