LOD and Running Sum Scenario

Hi Community,

Please refer the screenshot for your reference.

As per the screenshot , Monthly Original data shows the original data monthlywise.

But as per the business,

1)BOP Total value should have BOP TOTAL value of July 2018 which is minimum month of the year for all the corresponding months as per the excel image by using LOD .

2)Running SUM should be applied for COI Charge amount and Investment Performance only.

3) Running Sum should not be applied for BOP Total Account Value ,  EOP Total Account Value and BOP Total account value should have July month value for all the months.

Referring to Monthly Running Total, you can observe running total have been applied to BOP and EOP Total account value when I use table calculations: running total which is wrong as per business. Business wants running total for COI Charge amount and Investment performance only which is the main challenge.

Could you please help me to implement the logic as per the business requirements.

null  null Could you please go through the scenario as you helped me previously to solve such scenarios

I have attached my workbook for reference and currently using 10.2 version.

Regards,

Dhritiman

Note: Logic tried by me for reference but it is wrong

1)beg end dates : Logic which I want to find July month      BOP Total Account value and implement july month value for all the other months related to BOP Total account value

{ FIXED DATEPART('month', [Vltn Date]),[Pivot Field Names]:

if min([Pivot Field Names])="BOP Total Account Value" then Min(DATETRUNC('month', [Vltn Date]))

end   }

2)beg end values

if DATETRUNC('month', [Vltn Date])=datetrunc('month',[beg end dates]) then [Pivot Field Values]

elseif [Pivot Field Names]="COI Charge Amount" then  [Pivot Field Values]

elseif [Pivot Field Names]="Investment Performance" then  [Pivot Field Values]

elseif [Pivot Field Names]="EOP Total Account Value" then  [Pivot Field Values]end