Hi,
i have multiple rows with the same date field in an internal table , i need to sum up the amount for the same date. could any body let me know how to do the same.
following is the internal table format.
customer no ,| date | amount
123 | 20080720| 100.00
123 |20080720| 200.00
123 |20080715| 100.00
123 |20080715|500.00
ouput format should be
123 | 20080720|300.00
123|20080715|600.00
Thanks in advance.