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