Using previous group sum in current group calculation
SQL Server and CR 8.0 and ODBC
I'm creating a summary executive report for accounts receivable trends. The report is grouped by month (using a date/time field) with the sums based on formulas that are in the detail section (which is hidden).
Report currently looks like this:
Month Sales Cash Balance
Jan XXX XXX XXX
I would like to add a column for Sales Two Months Prior and then be able to perform a calculation on that field. So the March line would include the January sales sum. Is there any hope?