Skip to Content
0
Former Member
Nov 04, 2016 at 06:04 AM

how to get previous month's data when 0calmonth interval is the selection field?

72 Views

My requirement is when user gives 0i_calmo as selection field variable,report output should show closing stock for the same month and opening stock is the previous month's data fro the current month.

ex: selection field is- 04.2015 to 06.2015

04.2015 05.2015 06.2015

Result should come opening stock - 100 200 300

closing stock - 200 300 400

and for both opening stock and closing stock i am taking 0totalstock as keyfigure.

Thanks,

Sukanya.