Accumulative Vs Cumulative

[nihhalmca]

Hi All,

Can any body share knowledge on Accumulative Vs Cumulative with example.

Thank you.

Regards,

Nihhal.

[krishna20]

Hi,

Pls find here

Accumulative Sums

[jagan]

Hi Nihhal,

Both are same, I think they are synonyms.

Regards,

Jagan.

[nihhalmca]

Hi Jagan,

Thank for reply.

There is option for Accumulative in chart properties, however i have seen some posts for cumulative writing below script what is difference here.

ex: Rangesum(above(sum(sales),0,rowno()) as expression

Regards,

Nihhal.

[MK_QSL · Accepted solution]

Both are same...

But I think in pivot Table, you don't have option of accumulation which is available in Straight Table. You need to use

RangeSum(Before(SUM(Sales),0,RowNo()))

[jagan]

Both are same but doing in script sometimes for specific purposes.

[nihhalmca]

Thanks Manish.