How to retrieve the last occurrence in Set Analysis

[08748190]

I want to mesure yearly membership full-time of salaries,there is some salaries have diffent part-time from period to period.
For exemple: salary x have in 2018 part-time=0,9 and in 2019 part-time =0,5
the issue here that i get the sum of 0,9 + 0,5=1,4 but in my case i want to get the last occuenrce 0,5 not the sum of part times,see the attached screenshot.

My Set analysis is : 

Count({$<__Pivot_Intervall_PeriodType ={'Intervall'}

       , __Pivot_Intervall_Role={'EntreeSortie'}

     , __Period_id = {'$(vdate_analyse)'}

      ,[__Status.FR] = {'(Actif)'},

      [__Contract_Type]-={'IN','PS','TV','ST'}>}

        distinct(__FOLDER_ID) )

        *

        (    (Sum({$<__Pivot_Intervall_PeriodType ={'Intervall'}

       , __Pivot_Intervall_Role={'EntreeSortie'}

     , __Period_id = {'$(vdate_analyse)'}

      ,[__Status.FR] = {'(Actif)'},

      [__Contract_Type]-={'IN','PS','TV','ST'}

>}

        distinct(__FTE)))

So my question how i get the last occurence?

thank you in advance.

[miskinmaz]

You need to filtered out the max date in set analysis, something like:

Count({$<your_dateField={"$(=max(your_dateField))"},.....,etc>}       distinct(__FOLDER_ID) )