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