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.
The calculated field will then created as following:
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.