Skip to Content
Former Member
Jun 06, 2014 at 02:12 PM

How to calculate last 12 months, 6 months, 3 months data in report


Hi All Crystal Experts,

In my report, I have monthly view of data, where I am giving three prompts- Year, Startdate and Enddate. If I give 2013 as year, 1/1/2013 as start date and 05/01/2013 as end date then report shows monthly view of data for Jan-13, feb-13, Mar13, Apr-13 and May-13. Now for each month, I want to show last 12month, 6 month and 3 months view. Like for Jan-13 month, column 6 months view, I want to show data for last 5 months including current month i.e. Jan-13+Dec-12+Nov-12+Oct-12+Sep-12+Aug-12 and in Column 12months view, I want to show accumulated data of last 11 months(including current month) and in 3 months view, data for last 2 months(including current month).

How to calculate these fields?