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.

[sam8]

I think the best you can do is to aggregate the amount with a SUM metric and then group by date. 

If you're filtering by a date range, Looker Studio won't be able to see any data before that date range. So there's no way to compute an Opening Balance. 

Closing Balance would just be the sum of all of the amounts in that timeframe, I'm assuming.

[snkrsthr]

it is surprising this small and Common required thing is no way possible.