The following are the steps to add a calculated field inside a pivot table in Excel
- Click on a cell inside a pivot table.
- Go the PivotTable Tools -- Options -- Click on Formula --Calculated Field
- Add the formula for the calculated field
- Click ok. This will add the calculated field to the Pivot table as well.
No comments:
Post a Comment