Net Sum on repeating Sales Doc records

Hi Experts,

Iam facing issue in the report user complaining having multiple line items with similar records showing different net values.

i need to find repeating list of line items records having same Sales Doc# and sum up the net values to show as one line items but problem report has a column "Doc Date" which is unique and needed as per the reqd.

Please let me know how can i resolve this. Appreciate quick help on this.