Max Data within Set Analysis

[gleybson_calyx]

Hello people,

I would like to know how to do to return the max (Date) within Set Analysis.

In the image below I show that when selecting the pro product it shows the value and when it does not have product select (Imagem2) it does not bring.

exeples I've already tried:

sum ({<YearMessageDay = {'$ (= MAX (YearMessage))}}}} VALUE)

sum ({<YearMindDay = {"$ (= MAX (YearMindDay))"}>} VALUE)

Imagem1

Imagem2

[gleybson_calyx]

sum( {<AnoMesDia = {'$(=MAX(AnoMesDia))'} >} VALOR )

sum( {<AnoMesDia = {"$(=MAX(AnoMesDia))"} >} VALOR )

[gleybson_calyx]

Anyone have any suggestions?

[gleybson_calyx]

Tabela					o que preciso
nome	dt	valor				nome	dt	valor
abacate	01/01/2018	10				abacate	02/01/2018	9
abacate	02/01/2018	9				abacaxi	04/01/2018	16
abacaxi	03/01/2018	15
abacaxi	04/01/2018	16

[gleybson_calyx · Accepted solution]

Funcionou assim:

FirstSortedValue({<Tipo = {'Entradas'}>}  VALOR,-DATA)

Fica a dica!