How do i bring forward a previous month status to currently selected month.

[#1]

Hi

I have a case whereby I need to bring forward the status (release or withhold) from previous month into the current month as a starting point.

I managed to do this with numeric values but how to i go about doing this with a text (release or withhold).

Thanks Guys