I have created alv report with 5 fields in display. In this I am fetching the data from p0057, p0001, p0002 and displaying. I am fetching as Employee number(PERNR), Employee Name(NACHN), policy Number(MTGLN), policy Amount (BETRG) and from this amount(BETRG) is another field for which this will be the total amount of the policy. So, as of my scenario is one employee can have 1 or more policy this will be fetched and policy amount will be displayed and all the policy amount should be calculated and displayed as single amount. As of now I am getting is
Employee number Employee Name Policy Number Policy Amount Amount
12345 King 2345889 100.30 0.00
9874536 300.50 400.80
Here I am unable to sort the Amount field because the amount is not similar. I have sorted the emp. no. & emp. name. But I am unable to hide that amount 0.00. Could some one can help me to resolve this issue.