Calculate Cumulative Sum

[#1]

I have some data like

Month	Revenue
Jan	100
Feb	200
Mar	150

Now i want to create a bar graph, i use month in dimension and against each month i need cumulative sum of revenues like against jan the value should be 100 , Feb 300 ,Mar 450 and apart from this when i clik on any month then against that month the value of revenue again should be cumulative. Like if a clik on Feb data should be filtered and now i have only one bar against feb and the value of revenue should be 300 not 200.

Can anyone help me on this like what changes needed to be done either at the UI level or at the script level. Please let me know in case you want any more clarity on the same.

Thanks in advance

Regards,

Rahul

[#2]

Hi John, I also have the same requirement in my assignment, can you please have at above link and suggest. http://community.qlik.com/thread/95623

[Saran]

Hi John,

          Can you please explain how to use this in the front end? As you didn't recommend accumulating in the script.

Thank you,