Formular for the Last Value (Stockvalue) of Month / Year

[marco_81]

I need a Easy Formular for the Last possible Value in Month or Year in a Pivot Table. (see attachement Stock.qvw)

Maybe someone can help...

Thanks

[Gysbert_Wassenaar · Accepted solution]

Maybe FirstSortedValue({<Kalender.Datum={'=sum(Value)>0'}>}aggr(sum(Value),Kalender.Datum),-Kalender.Datum)

[marco_81]

Thanks a lot... it works