Acumulative Sales

[Anonymous]

Hello,

I would like to make an expression than accumalates sales per month.

i have data from 2015 to ytd so i would like on the new year to start accumlating from 0

i mean imagine that on December 2015 i have 3000 sales, and on January 16 54 sales.

the data on jan 16 should be 54.

i have seen this formula, however it sums all the data and it doesn´t take into account the year.

=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

How to Calculate the Cumulative Month sales

thank you

[adamdavi3s]

I think you just need to remove your first total so make it

=RangeSum(Above( Sum(Sales), 0, RowNo(TOTAL)))

[sunny_talwar · Accepted solution]

or this

=RangeSum(Above(Sum(Sales), 0, RowNo()))