Rolling months on 2 month fields in straight table

[#1]

Hello Community,

I have the scenario of rolling months. Please see the attached file and the expected results.

Example:

For cal_month =  Mar, I need sum of value against processed_month = Mar, from each cal_month rolling up i.e Jan, Feb and Mar

Thanks,

Singh

[Gysbert_Wassenaar]

See attached qvw

[#3]

Gysbert,

Thanks man, that works as expected. Is it possible to have same in set analysis. Since i pulled out this logic out of my whole setup.
Since I believe, we cannot compare fields in set analysis. Is there any work around ?

Thanks,

Angad

[Gysbert_Wassenaar · Accepted solution]

This document may help to understand the issue with using set analysis: set_analysis_intra-record.qvw

[#5]

Thanks Gysbert! You are life saver.

[Gysbert_Wassenaar]

If these kind of problems can cost you your life, then perhaps you should find another employer

[#7]

It was not said in a literal way. Though I am looking for a change.