Unique Person

Dear All,

I am using BEx Query Designer. I am making a report on an infoset. I use 0person. and the query gives info on a person basis. Problem is 0person is not unique since 1 person can have 2 hiredates. Is there a way where the query can be designed is such a way that only a unique person would be shown with the latest hiredate, if not that any 1 particular hiredate.Basically 0person should not repeat.

Regards,

Jack Silverz