Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Christophe, check attachment to see if that's what you want.
Hi Christophe, check attachment to see if that's what you want.
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.
Works fine ! Thank you !