I have to calculate total in line chart corresponding to total no. of "request_id" coming in for the access of different applications in our company.
Please see the sample data.
Date Request_id Application_id
01-01-2000 1 2
03-04-2001 2 3
08-09-2006 3 4
and so on........
We have data like this starting from 01-01-2000 till date. We have many applications, and users have to sent send request_id to us to access those applications.
We want to show the cumulative value of no. of requests received so far month wise i.e. Jan 2011 should have the closing balance of no. of requests received till end of 2010(the period starts from 01-01-2000). Feb 2011 should have the closing balance of Jan 2011, and Mar 2011 should have the closing balance of Feb 2011, and so on...