Skip to Content
0
Former Member
Feb 18, 2011 at 09:49 AM

Group totals for Unique customers

26 Views

Hi Friends,

My report is grouped by "Currencycode"(USD,EUR,KRW etc.,). And I am displaying the below details for each group. Let's say below details are for USD

Custname--


_OrderDate_--


_Amount_

ABC--


1/1/2011--


10000

ABC--


2/2/2011--


11000

EFG--


2/2/2011--


50000

MNO--


3/1/2011--


6000

XYZ--


4/2/2011--


5000

JKL--


5/1/2011--


4500

JKL--


5/2/2011--


5000

-


TOTAL----


77000

In my group footer, I need to sum up the highlighted values in the table. Which means, if there are two same customers, then the amount should be taken on max(orderdate) for that customer.

How can I achieve this? Any one please suggest.