show max value in table

[omid5ive]

hi

i have a table like below

industry	Asset	Value
A	a1	100
A	a2	120
A	a2	123
B	b1	253
B	b2	200

i want table that show industry with sum of value and show the asset with maximum of value like below

Industry	Industry Value	max asset	asset value
A	343	a2	143
B	453	b1	253

[andrey_krylov]

See attached

[omid5ive]

hi

thanks

but i need the asset name too

after sum(value) field i need to know the name of asset that have 253 value

[andrey_krylov · Accepted solution]

Try this

[omid5ive]

thanks a lot