Need Help on Calculated Field for Opening Balance

[snkrsthr]

I Have Sheet With Headers (Date, Transaction Type, Cat1, Cat2, Amount)

Transaction Type having Fields of Collection, Expenses

so I need to Create a Report in Looker Studio for Opening Balance and Closing Balance for Selected Date Range

Please Help in applying formula in Calulated Field in Opening Balance and Closing Balance.