Hello

I am making a chart that sums dated numeral values. like so

the X axis is a string corresponding to tax year and not a full date. however each record is dated by a date field.

each record also contains a Stock Value numeral field.

I want to display on top of this graph, or at least display as text, the latest Stock Value numeral corresponding to each year.

I tried using tabular functions

and adding AVG

can i get any advice on how to display this value regarding latest recorded date?