Hi,
Here is the scenario,
I want to calculate the balance of the year using reporting capability of SAC. For example, If I'm in month of Jan 23, I should get the values from Feb23 till Dec23. Now if I'm in month of Feb23, I should get the values from Mar23 till Dec23. I'm defining the dynamic date filter but there is constant for look ahead. Please refer below screenshot.

As Look Ahead is constant, so if I'm in Mar23 it will go beyond Dec23 which should not happen.
Anyone who has faced similar kind of issue or knows the workaround here. Their comments would be deeply appreciated.
Thanks.