Adding a Running Balance Calculation Column

by  About
       

To add a Running Balance Calculation Column:

Step 1: Add a New Calculated Field

1. Select a cell in the PivotTable Report, press Alt+P and from the PivotTable icon on the PivotTable toolbar, select Formula, and then Calculated Field.
2. In the Name box, type Running Balance Field as the name of the calculated field.
3. From Fields select the Credit field, and then click Insert Field.
4. In Formula, type the minus (-) sign.
5. In Fields, select the Debit field, and then click Insert Field.
6. Click OK.

Step 2: Calculate the Running Balance

1. Select a cell in the new calculated field and click the Field Settings icon on the PivotTable toolbar.
2. In the PivotTable Field dialog box, change the field name in the Name box.
3. Click Options.
4. From the Show Data as dropdown list, select Running Total in.
5. In Base field, select Details, and then click OK.
Screenshot // Adding a Running Balance Calculation Column
Adding a Running Balance Calculation ColumnAdding a Running Balance Calculation ColumnAdding a Running Balance Calculation Column



Leave a Reply

Your email address will not be published. Required fields are marked *


× 9 = sixty three

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>