Skip to Content
0
Former Member
Apr 17, 2014 at 07:51 AM

Latest Date with latest date Amount

67 Views

Hi Experts,

I have an issues with latest date with the appropriate amount

I have 3 column

Currency

Date

Amount

data something like below

Currency Date Amount

AUD 1/20/2014 15,625,800

AUD 1/21/2014 15,625,800

AUD 1/22/2014 18,625,800

AUD 1/31/14 26,875,800

GBP 1/20/2014 36,875,800

GBP 1/31/14 19,625,800

so I havbe to display the data Latest date of currency and their corresponding amount like bellow

Currency Date Amount

AUD 1/31/14 26,875,800

GBP 1/31/14 19,625,800

To Achieve this I Have used Max(date) den I got the Max of dates for currencies only

the issues is if I add the amount column to table its giving total amount off all dates with corresponding currencies

Currency Date Amount

AUD 1/31/14 76,753,200 (its showing sum of AUD'S ALL Dates)

GBP 1/31/14 56501600 (its showing sum of AUD'S ALL Dates)

how can I achieve this

thanks

Mahi

Attachments

12.png (10.8 kB)