Controling the MemberCaption of a hierarchy

[backhandx]

Hi all,

I have a problem in defining the membercaption in a hierarchy.
Actually, I have a hierarchy populated with attributs from a table A which contains 3 fields: Date, id: BusinessKey and Name:memberCaption .


suppose that we have 3 sets (  {'date': 01/2017 ;  'id' : 1 ; 'Name': X  } , {'date': 02/2017 ;  'id' : 2 ; 'Name': Y  }, {'date': 02/2017 ;  'id' : 1 ; 'Name': Z  } ).

When I test the hierarchy, I get to lines {'date': 01/2017 ;  'id' : 1 ; 'Name': X  } , {'date': 02/2017 ;  'id' : 2 ; 'Name': Y  }.

I am wondering if is there a way to filter the hierarchy to retrieve the last version of each id, I mean to retreive the id =1 and name =Z not x because the name x is not valid.

Thanks