Thursday, January 26, 2012

Create Calculated Field At PivotTable

Question:

How can I create a calculation from the total of a count of a field on a pivot table? Example: I need to calculate the number of employees for each process level times a specified amount - 89 x $4.59, 3 x $4.59.

Answer:
Select the table and click Insert, PivotTable. Drag the required field to relevant label (Refer the details of creating pivotTable at post Show Variance Between Year PivotTable). Create the pivotTable as Picture 1. To create a calculated field, click at the pivotTable and click Option, Formulas, Calculated Field.

Picture 1

A Insert calculated Field will show, type the name for the calculated field and type the formula, then click Add, click OK.
Picture 2


The calculated field will then created as following:



No comments:

Post a Comment

Note: Only a member of this blog may post a comment.