Evaluate top 1 field and value

[saradhi_it]

Hi Friends,

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

Thanks,
PRS

[maxgro]

make a chart with 3 expressions

'Product'

FirstSortedValue(Product, -Sales)

max(Sales)

[maximiliano_vel]

Products:

LOAD * INLINE [

Product, Sales

a, 10

b, 20

c, 20

d, 50

e, 20

f, 10

g, 10

h, 200

i, 300

j, 100

k, 150

];

NOCONCATENATE

Pro:

LOAD Product,

     Sales

RESIDENT Products

ORDER BY Sales DESC;

LET vMaxProduct = Peek('Product', 0, 'Pro');

LET vMaxSales = Peek('Sales', 0, 'Pro');

DROP Tables Products;