I am using Crystal reports 2008. I would like to create a chart that groups the months together and then gives me a running total of whatever statistic I am trying to find. Here the details:

 

My report is reading from an Excel spreadsheet where each record is dated. The report grows each week. It's a spreadsheet of survey responses. I want each chart to display the results by month, and then provide a count of each response (or a percent of responses) for each month. I want each chart to just display the last 12 months of records.

 

Is this possible?