cumulative sum in the graph

m_torabi — Wed, 25 Nov 2020 16:16:04 GMT

Using this formula, I can obtain commutative sum for each category:

=Rangesum( above( sum( {$<Month=>} Amount),0,RowNo()))

The problem is, when I use the same formula in a chart, the result obtained is not the same.

In the screenshot below, Graph is the clone of "Table 1", however it doesn't reflect the same values:

My desired graph is the one with the same value as the Table 1 's "Cumulative sum" column for each category.

The problem is RowNo() function has different behavior when used inside the graph rather than as a script.

I would like to apply the solution without using the "Full accumulation" option.

Re: cumulative sum in the graph

WIPER — Fri, 08 Jul 2022 14:16:32 GMT

use this in frontend for your desire result-

aggr(RangeSum(Above((Sum(Amount)),0,RowNo())),Year,Month)