I have data which I pivot as
Row Labels and
Column Labels which gives me something like this:
And what I would like to do is add columns like
Grand Total (i.e. which applies to all columns as a whole, and not each column individually) to calculate things such as
I have found a way to change the
Grand Total column (more options gives you more calculations like standard dev):
However I can't find a way to add more columns (i.e. I would like to keep
Grand Total, and add more columns for
How can I add a calculated column to my pivot table in a similar way to Grand Total?
UPDATE: Adding a calculated field to my pivot table
However whatever I do, my calculated field shows the same as the
Am I doing something wrong with the calculated field?
What you need is not a calculated field, but a calculate item.
Your column field has 12 items, namely the 12 months of a year. What you want is an additional column called
Avg. So we need to add
Avgbesides the 12 items:
Activate (click on) any cell with a label of the column field, say the cell with
Jan, then PivotTable tools -> Options -> Fields, Items & Sets -> Calculated Item (it is dimmed if you do not activate a cell for field labels.) Then, name a new item
Avgand set the formula
Add other calculated items similarly.