Set Analysis with Addmonths

[#1]

Hi All,

I want below expression in set analysis

=Sum(if(YearMonth>=Addmonths(CommonMonth,-2) and YearMonth<=Addmonths(CommonMonth,0),Sales))

Pls find the Sample app attached for reference.

Thanks in advance,

Regards,

Bhaskar

[martin59]

Sorry I didn't see you document.

Look at the attachment, you can use the cumulative option.

Hope that helps you

Martin

[rmuhammad]

please mark the correct answer so it helps others.