I have the scenario of rolling months. Please see the attached file and the expected results.
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 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 ?