Okay - so I’m almost there - CORECTION - it worked!
Requirements:
- you have your table sorted
- you’re adding new row at the top or in the middle of the table
- you need a running balance
- the running balance column needs to sum from bottom to top
Current Solution:
- using rank - create a Visual Position column (link to thread)
- Using filter - create your running balance column
- be sure the running balance column accounts for the first row with a zero & an if statement
- be sure you have a first row that has a zero dollar amount
Formulas in the screenshots
