previous year values using set analysis

[ssriramin19]

Hello

My requirement is that I have a  month field called plan month . I need to find one month previous and two month previous values using set analysis.

I tried with addmonths but it is not proper for my requirement.

Can anyone tell me how to resolve with set analysis

Thanks

[fdelacal]

SEE QVW I ATACH

HOPE IT HELP

[ssriramin19]

Can you please tell me why the below code is not proper

date(num(only(Plan_For_Month-2))) .The month must be two months before from the current month .But it is not calculating proper.

Can anyone tell me how to resolve the above error

[sivarajs]

try this addmonths(max(date),-2)