Store end amount of accumulation graph as a variable.

[#1]

Hi community,  I have an line graph with full accumulation that has an ending value.  I put the same set analysis in a variable and for some reason it's slightly off.  All I want is the accumulation value with current selections stored as a variable.  Is there anayway to do this?

[Jason_Michaelides · Accepted solution]

Assuming your chart dimension is something like Month, and your chart expression is Sum(Sales), try:

=Max(Aggr(RangeSum(Above(Sum(Sales),0,RowNo())),Month))

Hope this helps,

Jason