Hi i am again with same,
I have opning balance for every month, it will carry forwarded to next month,
Suppose in the month Apr i have my opning as 5000(i.e March closing in previous year)
every month we have value,
Apr = 300, May=-100, June=200, July= 300, Aug=-100, Sep=100
My result should be like this, if i selected Apr .... Closing of previous month+ value of present mnth....
i.e 5000+300= 5300 i am getting this value
now for May 5300-100= 5200, like this June= 5200+200= 5400, July 5400+300= 5700, Aug=5700-100= 5600, Sep 5600+100= 5700 this also i am getting correct.
But my issue is , If i selected Apr, May , June ... I need Apr(opening)+June(Closing)= 5000+5400, it should change dynamically as per selections. I need it in expression.
Please help on this.