how to Get Max value

31 Views

Hi Experts

I am stuck with with a problem unable to find solution . i want to find maximum value for this

material Ordernumber  Operation KEy        measurevalue
aaa            55                  20                     0
aaa            55                  30                    0.44
aaa            56                  10                    6.59
aaa            56                  20                       0
aaa            56                  30                    1.82

i want the maximum value for each order number like .For order number 55 max value is 0.44 and for 56 is 6.59 . both gets summed and display in material 7.03

finally i want the table like this

material   measurevalue
aaa              7.03

Please suggest the answers ASAP ..its urgent