6 Replies Latest reply: Dec 22, 2017 1:43 AM by Devarasu R

# Cumulative of sales

I want to calculate cumulative of sales monthwise ,means if i select month Apr then it will show me apr.But if i select May ,it will show me the sales of Apr+May .....& it must take the year  >2016

• ###### Re: Cumulative of sales

Hi,

you can try like below, select Year and Month from the list box.

Cumm. Sales

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

Thanks,

Deva

• ###### Re: Cumulative of sales

I have to exclude year 2016 & im showing this in straight table

• ###### Re: Cumulative of sales

Hi,

the same formula will work for straight table too, u can simply exclude specific year by using set analysis

=RangeSum(Above(TOTAL Sum( {\$<Year-={2016}>}Sales), 0, RowNo(TOTAL)))

or use below fxn (it will show always the max year

=RangeSum(Above(TOTAL Sum( {\$<Year={"\$(=Max(Year))"}>}Sales), 0, RowNo(TOTAL)))

Thanks,Deva

• ###### Re: Cumulative of sales

Hi,

Let us know any issue, if not close this thread by marking helpful and correct. Thanks

• ###### Re: Cumulative of sales

THIS IS NOT WORKING.....It is showing me current years data....can you help me  by using YTD formula