Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Funcionou assim:
FirstSortedValue({<Tipo = {'Entradas'}>} VALOR,-DATA)
Fica a dica!
sum( {<AnoMesDia = {'$(=MAX(AnoMesDia))'} >} VALOR )
sum( {<AnoMesDia = {"$(=MAX(AnoMesDia))"} >} VALOR )
Anyone have any suggestions?
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 |
Funcionou assim:
FirstSortedValue({<Tipo = {'Entradas'}>} VALOR,-DATA)
Fica a dica!