First sorted value() issue?

[#1]

Hi All,

I got table as below

Name              runs         wkts

a1                   10               2

b2                   20                1

c3                   15               3

d4                    10               3

How to show best performance (most wkts and least runs) by name, using firstsortedvalue().

Regards,

Janaki

[#2]

Hi Anbu,

What is dtFSV

[anbu1984]

Load Name,runs,wkts,Date#(dtFSV,'DD-MM-YY') As dtFSV Inline [

Name,runs,wkts,dtFSV

a,10,2, 1-3-15

b, 20,1,  1-2-15  

c, 15,3, 1-2-15

d, 10,3,  2-2-15  

e,  7,3,  1-2-15

f,  7,3,  2-2-15];