Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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