Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Please help me out in getting top one sales in desired format.
Thanks,
PRS
hi you can use
firstsortedvalue(Product,-Sales) for the name
and firstsortedvalue(Sales,-Sales) for the value