» Adding a Data Field That Calculates Percentages from One Item of the Row Field
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To add a data field that calculates % from one item of the row field:1. From the PivotTable Field List, drag a field to the Data area. In the example below, the field is December 2003.
In Excel 97 and Excel 2000, use the Layout dialog box (Step 3 of the PivotTable Wizard in Excel 97, and Step 4 in Excel 2000) to drag the extra field to the Data area.
2. Select a cell in the new field and click the Field Setting icon.
3. Change the title of the field in the Name box.
4. Click Options, and from the Show data as dropdown list, select % of.
5. In Base field, select the detailed Row field.
6. In Base item, select first item of the Base field, and then click OK.
Book Store:
Recommended Books:
- Microsoft Windows XP Step by Step (With CD-ROM)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Financial Peace: Revisited
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The Basics of Finance: Financial Tools for Non Financial Managers
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
No comments have been submitted.
