Opening Balance Calculation

[sumeet-vaidya]

Hi Guys,

Greetings...!!!

I have below data for which I want to calculate my Closing & Opening balance.

Vertical	Year_Month	Amount Paid
RBG	201603	100.5
	201604	120.3
	201605	135.5
	201606	145.8
	201607	168.4
	201608	180.5
CBG	201603	45.2
	201604	58.6
	201605	65.9
	201606	75.2
	201607	88.8
	201608	98.1
RABG	201603	24.5
	201604	30.5
	201605	42.6
	201606	48.8
	201607	54.7
	201608	60.8

Below output is expected. Also Vertical & Year_Month are my dimension.

Vertical	RBG					CBG					RABG
Year_Month	201604	201605	201606	201607	201608	201604	201605	201606	201607	201608	201604	201605	201606	201607	201608
Closing Balance	120.3	135.5	145.8	168.4	180.5	58.6	65.9	75.2	88.8	98.1	30.5	42.6	48.8	54.7	60.8
Opening Balance	100.5	120.3	135.5	145.8	168.4	45.2	58.6	65.9	75.2	88.8	24.5	30.5	42.6	48.8	54.7

hic‌ jaganmohanrao‌

[sunny_talwar]

Check this out