» Inserting a Running Balance Column in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft 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.
Book Store:
Recommended Books:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Special Edition Using Microsoft Access 2002
- Microsoft Word Version 2002 Inside Out
- Advanced modelling in finance using Excel and VBA
- Financial Statement Analysis with S&P insert card
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
