BEX queries- MAX value

Hi,

I have a situation where a queryhave a similar structure, where i need to display all the line items of the Order with the details of Price, qty and amount as well as calculated KF computed as (f Max Amount for an Order in all the lines of the order) .

any suggestions is appreciated

thanks

PP