Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have situation where I must extract records with highest starting date if they are more than one SifDat values..
Was tried with FirstSortedValue, but I always get blank records..
Any idea and thanks in advance,
Igor
Try below expression in chart
=FirstSortedValue( [Starting Date],- aggr( max([Starting Date]),SifDat,SifraCen))
could u pls share some sample data
sample data is in attached qwv, Thx
Try below expression in chart
=FirstSortedValue( [Starting Date],- aggr( max([Starting Date]),SifDat,SifraCen))
Thx a lot ..