Values from another column / previous month

[prma7799]

Dear All,

I have one report in that i have 4 columns

[OPENING STK]  ,

[TOTAL RECEIPT]  ,

[TOTAL ISSUE] ,

[CL STK AFTER EXP ]

[CL STK AFTER EXP ] =  [OPENING STK] + [TOTAL RECEIPT] - [TOTAL ISSUE] 

In our Database the [OPENING STK] manually entered 0 for the period of [APR  2012-13].

APR....      

PRODUCT CD	OPENING STK	TOTAL RECEIPT	TOTAL ISSUE	CL STK AFTER EXP
TOTAL	0	4,715	1927	2788
1AS1	0	4,715	1927	2788

When I select May

PRODUCT CD	OPENING STK	TOTAL RECEIPT	TOTAL ISSUE	CL STK AFTER EXP
TOTAL	0	7,400	7650	-250
1AS1	0	7,400	7650	-250

Now my requirement is whenever user select May 2012-13 to till date [OPENING STK] will be the last month of

[CL STK AFTER EXP ]

Expected Output for May and so on month years

PRODUCT CD	OPENING STK	TOTAL RECEIPT	TOTAL ISSUE	CL STK AFTER EXP
TOTAL	2788	7,400	7650	2,538
1AS1	2788	7,400	7650	2,538

I really appreciate your help.

Please find the sample attachment for Apr data and expected out put for May

Thanks..

[tresB]

QVW not opening. If section access is there in the app, remove it and then share once again.

[nagarjuna_kotha]

PFA....

[prma7799]

Hi tresesco‌

Please find the updated file.

Thanks

[nagarjuna_kotha]

As per your logiv chck this