How to use accumulated values in a textbox

[#1]

hey guys,

I have an simple diagram with an accumulation over a timeline. Now I want to take "the last accumulated" value for use in an textbox. Is this possible...

Pls look at my example.

Thank you

[sunny_talwar]

Would you be able to share the data in Excel file with the expected output? I am working with Personal Edition

[swuehl · Accepted solution]

Isn't just

=sum(Value1)

in a text box what you are looking for? Just the sum of all Value1 values in global context?