Get the last event

[#1]

Hi,

You will find enclosed a rental car project example (it's filled with excel files)

My goal is to create a graphic table filtered with only "fin location" event (done) and in wich one the column GestionnaireDossier is filled with the name present in GestionnaireDossier for the event "debut location" for the same car

Actual :

What I try to do :

I tryed with firstsortedvalue and rank parameter but i can't figure out how it works ...

Any help will be great ...

Thanks in advance

[rubenmarin · Accepted solution]

Hi Christophe, check attachment to see if that's what you want.

[jagan]

Hi,

Try like this

Dimension: Marque, Modele, DateEvenement

Expression:

NomEvenement = FirstSortedValue({<NomEvenement={'Fin Location'}>}NomEvenement, -DateEvenement)

GestionnaireDossier =If(IsNull([NomEvenement]), Null(), MaxString(TOTAL <Marque>GestionnaireDossier))

Hops this helps you.

Regards,

Jagan.

[#4]

Works fine ! Thank you !