Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
year sales SUM (sales)
------ -------- ---------------
2000 100 100
2001 150 250
2002 350 700
2003 100 800
lik that
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.
Try this..
Goto properties-->Expression--> Accumulation-- > Full Accumulation..
Kabilan K.
Thank u i got it.Thanks for timely help
regrds
Mahesh
if u got it then close the thread..
Hi,
Use Rangesum function.
Regards,
Piyush