Show date with the highest Amount

[#1]

How I can display the date with the highest amount of a month?

(max(total aggr(sum({<ExisteTiquet={'Si'},Año={$(=Max(Año))}>}Amount),Mes,[Posting Date])))

This function gives me the amount . But what date?

Thanks in advence

[MK_QSL · Accepted solution]

FirstSortedValue([Posting Date], -aggr(sum({<ExisteTiquet={'Si'},Año={$(=Max(Año))}>}Amount),Mes,[Posting Date]))

Check number of brackets at the end...

[teiswamsler]

Hi Paco

Is it possible to get some sample date/qvw?

/Teis

[#4]

Very good Thanks

[sujeetsingh]

Here is a sample by samuel‌