Pivot balance rolling basis calculated using rtf template in BI report

Hi,

I hope this email finds you well.

I facing some issue from balance logics in rtf layout, Also, balance is equal to (On-hand + current commit – demand qty) on a rolling basis, I have attached the file, please check the balance logics in Report Layout Requirement.xlsx file. it's very high prority from user. So kinldy help me.

Note: I have attached RTF and XML file also, Kinldy check and update if any rtf tag or Sql logics.

Best Regards,

Karthik