Get greater amount from table using set analysis

[#1]

Hi,

I have a table that look like this:

Date            Amount

01/01/2013   40,000

01/02/2013   50,000

01/04/2014   55,000

01/06/2015   9,000

I need to take greater amount and the date of this amount.

For example: the result in this case would be 55,000 and 01/04/2014

I have tryied to use FirstSortedValue function but it's doesn't word because it return the first or the las value.

King regards!

[sunny_talwar · Accepted solution]

Try this:

='Geater selling day' & Chr(13) & FirstSortedValue(Date, -Aggr(Sum(Amount), Date)) & Chr(13) & Max(Aggr(Sum(Amount), Date))

[udaya_kumar]

Hi,

Please check this.