How to create Cumulative Trend - Line chart

[teamireport]

HI Folks,

 

After a long struggle i was able to genrate one line  chart .

Now  i would like to genrate a line chart with cumulative trend .

I want to show a  line chart for number of users created  this should be a cummaltive count of created users month wise.

here my  actualldata

 

 

StartDate	EndDate	Created users
1/1/2009	1/31/2009	0
2/1/2009	2/28/2009	71
3/1/2009	3/31/2009	5271
4/1/2009	4/30/2009	394
5/1/2009	5/31/2009	425
6/1/2009	6/30/2009	369
7/1/2009	7/31/2009	426
8/1/2009	8/31/2009	399
9/1/2009	9/30/2009	397
1/1/2009	10/21/2009	244

 

 

for the above actuall data i able to genrate a line chart . But i would like to know how to cumulative and genrate a report in i-report.what are thing to do..

This is pretty much urgent to me .

can anyone guide me please ?

 

here with i have attached the line chart genrated with actuall data. not cumulative.

 

thanks

teamireport

 

 

 

Post Edited by teamireport at 10/26/2009 15:19

[mdahlman]

You should be able to create a variable that sums these values. That ought to give you what you want. Have you tried that already?

Regards,
Matt

[teamireport]

HI matt ,

Thanks for your response.

Actcullay i want to sum consectives values (ie Cumulative formula) like this ( 0+71 , 0+71+5271, 0+71+5271+394... ) based on these values i want genrate a line chart .

Can you please guide me how to achive this ?

thanks
-teamireport

Post Edited by teamireport at 10/29/2009 13:41

[mdahlman]

Yes, that's the situation I had in mind. Variables are good for cumulative totals. You should be able to create a variable that sums these values. Have you tried that already?

Regards,
Matt