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--
_Amount_
ABC--
10000
ABC--
11000
EFG--
50000
MNO--
6000
XYZ--
5000
JKL--
4500
JKL--
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.