Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have got a scenario where in when I select yearmonth range for example 201301 to 201306
then I need to sum(key) where in
resultant should be like for
201301 -> postyearmonth should consider from 201301 to next 5months i.e 201305
I have written like sum({<postyearmnt={">=$(=yearmonth) <=$(=addmonths(yearmonth,5))"}>}Key)
like this for 201302 also and go on
values are correct when I selected only single yearmonth then I am getting correct values
but when I select multiple yearmonths then postig yearmnt starting from repective yearmonth only but postingyearmnt end is not changing for 201302 ,201203 ,201304 ,201305 ,201306 .
it is fixed to 201305 .
please suggest me solution for this. ASAP
Thanks in advance.
post sample please
Sample Data posted to Original post