max value for each product ?

[Anonymous]

i have 100 records  in sales field

and to al distinct products are 10 having like

product1,product2,product3....product10

i want get the max value for each product in front end text object..  ?

how to do it this calculation only in front end

[Chanty4u]

u can create a  max(Product1...10)

in script

[Kushal_Chawda]

put the below expression text object. You can select the products from list box

=Product & ' '& max(Value)

[avinashelite]

did not get the exact requirement ... share the sample data and the output that your excepting

try like this

agg(max(value),Product)

[amayuresh]

try this,

I have like

LOAD * INLINE [

    Product, Value

    A, 10

    B, 20

    C, 30

    D, 40

    A, 5

    B, 20

    D, 50

    C, 40

    A, 50

    B, 100

    D, 60

];

Text object expression = concat(if(aggr(Max(Value),Product),Product&' = '&aggr(Max(Value),Product)&CHR(13)))

Get result like

[Digvijay_Singh]

Bit simpler

=Concat(Aggr(Product & '= ' & Max(Value),Product),Chr(13))