Insert “Calculated Field”

We can add a “Calculated field” in our “PivotTable”.
A “Calculated field” is a new field made of other fields, based on a formula.
A Calculated field must be placed in the value area.
So first we select a cell in the value area.
We click the “Formulas” in the “Options” tab, and from the drop-down menu choose “Calculated Field”.
This opens the “Insert Calculated Field” dialog.
In the upper section we give an appropriate name. I give here Total, which stands for Total purchase.
In the “Formula box”, we give our formula.
We can type them or we can create them by double clicking on the fields.
For Example, I double click the AK price field, type the multiplication sign and double click the number field.

This would give me the total purchase value of my goods.
I click the “Add” button, and click OK.
The calculated field is added to the “PivotTable”.
You will now find it in the field under the “PivotTable Field List”.

Add Calculated item

In “Excel”, we also add a calculated item.

An item is calculated using the different data from a field.

For example, I’m in the month column where the different months of the year, January to December are displayed.
I wish to add a calculated item named Q1 which gives the total of the months January, February and March. That is the first quarter.
The first thing I do is, select a cell in the month column.
I choose “Formulas” in the Options tab.
And click “Calculated Item …”
This opens the “Insert Calculated Item” dialog.
In the upper section I give an appropriate name.
In the left part I choose the field in which the calculated item from the month column is to be created.
In the right part I double click the month of January, I type a plus sign, I double click February, I type a plus sign and double click March which are the months for the first quarter.
I click the “Add” button, and click OK.

I repeat this for Q2, Q3 and Q4
This is the result:

Keep in mind that for every quarter we need to add the appropriate months.
But I think you are smart enough to know that.

View Formulas

To view the formulas that were created by “Calculated fields” or “Calculated items,” you have to go to “Formulas” button in the “Options” tab from the “PivotTable Tools”.
And select “List Formulas” from the drop-down menu.
This will open a new worksheet in which our formulas that are used in our “PivotTable”are shown.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats