Inserting a Running Balance Column in Excel 2007

To insert a Running Balance Calculation Column:

1. In PivotTable Field List drag a data field into Values area, in the example presented drag the Quantity Field.
2. Select a cell in the second Quantity Field, right click and select Value Field Settings.

3. Select Show Values as tab, select from Show Values as dropdown list Running Total in,
from Base field select the Row label field, in the example presented select Years field,
click Number Format button and select the desired formatting and click OK twice.

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.