first sorted value with multiple activities on one date

[#1]

I need to screen for certain activities. Here's the list for one customer:

Date     Activity

8/28     SOE

8/28     SMC

8/26     SNC    

8/26     SNC

I want to find the SMC activity, but when I try FirstSortedValue (FSV) as FSV(Activity,-Date,1), FSV(Activity,-Date,2),FSV(Activity,-Date,3),

my results are "SOE", "SNC", "SNC". What am I doing wrong?

[whiteline]

You can't find SMC by date with FSV, because SMC and SOE has the same date.