How to apply firstsorted function for below case.

[#1]

Dear All,

I have one requirement to find unique value.so please help me and check how we can do on script level.

INPUT:-

Output:-

[sunny_talwar]

May be like this

LOAD Company,

          Date(Max(Date)) as Date,

          FirstValue([Sales Person]) as [Sales Person]

FROM ....

Group By Company