I am creating rolling forecast for 12 months. In Sys Period i have created line item with Boolean. If Boolean checked then in main module it will sum for 12 months /12 and gives forecast for next month. How can I create time filter for this. For the first month i am getting correct value for next month it is giving same value. But it should not. Need to create time filter for this. Can anyone help me with this.
For March i got correct value. For April, May etc. it is taking same 12 months calculation. It has to change dynamically.