Evaluate top 1 field and value

[saradhi_it]

Hi Friends,

Please help me out in getting top one sales in desired format.

Thanks,
PRS

[lironbaram]

hi you can use

firstsortedvalue(Product,-Sales) for the name

and firstsortedvalue(Sales,-Sales) for the value