we have inventory movement data table for various stock items with stock In and Out information. Data is extracted from SQL database, so data keeps updating with new information on every refresh function.
I am trying to create a pivot report, where we need new fields to table/report such as opening balance, running balance and closing balance for any item at any given point in a time.
can someone help, how to write a formula for opening balance, running balance and closing balance in table or pivot report..
see attached spreadsheet for example
