Skip to Content
0
Former Member
Mar 10, 2011 at 06:59 AM

Summing up items of the same date in crystal report

182 Views

Hi Experts,

I am doing a sales analysis report in crystal and I have grouped the report by the BP Name hence showing sub totals per BP. I would also like to go further and sum up same sales items done on the same date under one item description i.e

Date Code Description Amt $

02-Mar-2011 NTE01 Handling Charges 1,000

02-Mar-2011 NTE01 Handling Charges 1,000

02-Mar-2011 NTE01 Handling Charges 1,000

03-Mar2011 NTE02 Storage Charges 2,000

03-Mar2011 NTE02 Storage Charges 2,000

03-Mar2011 NTE02 Storage Charges 2,000

Expected Results

Date Code Description Amt $

02-Mar-2011 NTE01 Handling Charges 3,000

03-Mar2011 NTE02 Storage Charges 6,000

Patrick

Edited by: Patrick Makanga on Mar 10, 2011 8:05 AM

Edited by: Patrick Makanga on Mar 10, 2011 8:17 AM