Bar chart Accumlulation of sales-ASAP

[#1]

hi,

i ahve requirement like

sales of years  start from 2000 in 200 sum sales=sum of sales of in the yr 2000 and next year

i.e 2001 it should diplay sum of sales in 2000 and 2001lik that in 2002 the sum of the the sales of three years lik 2000 ,2001 and 2002

lik so if it is 2010 then sum of sales of all prevoius yrs.

[#2]

year     sales  SUM  (sales)

------     --------  ---------------

2000     100     100

2001      150     250

2002      350      700

2003       100      800

lik that

[israrkhan · Accepted solution]

on expression tab use the accumulation option, you can find it left down.

you can define it ,how back step you want to accumulate, and full accumulation as well.

try this option and let us know.

[#4]

Try this..

Goto properties-->Expression--> Accumulation-- > Full Accumulation..

Kabilan K.

[#5]

Thank u i got it.Thanks for timely help

regrds

Mahesh

[israrkhan]

if u got it then close the thread..

[#7]

Hi,

Use Rangesum function.

Regards,

Piyush