Please find my approach:
1. Change Data source and add Union with same Sheet (this is to calculate balance row), i am not using Total options of tableau because we need to use running total later only for "Balance" but not for Remarks.
2. Create a calculated column for table rows measure (using first part of Union):
3. Create calculated column for "Balance", using second part of Union:
4. Drag both to marks shelf and use running total for "Balance":
5. Results would look like:
Please find attached sample workbook, hope that helps.
Running Calculation.twbx 28.4 KB