COGNOiSe.com - The IBM Cognos Community

Hello Guru's, I have an issue where i'm trying to retrieve the Date(Char) from a prior row.

For example, my data looks as follows:

PeriodControlDate     MaxDate (for Report)     MaxDate-1
05/29/2014              05/29/2014                         ?
05/16/2014              05/29/2014                         ?
05/01/2014              05/29/2014                         ?

I'd like to get MaxDate-1 to show the PeriodControlDate that is 1 prior to the MaxDate, per row 2.
In acheiving this, i'd like to filter my report to only show transactions for the previous period.

Thanks in Advance!