This is a discussion on Adding a calculated field as a row to a pivot table within the Excel Questions forums, part of the Question Forums category; Hello, is it possible to add a calculated field to a pivot table . At the moment I have a ...
is it possible to add a calculated field to a pivot table .
At the moment I have a calculated field below the pivot table - but when I refresh it sometimes overwrites the formula. So I was trying to incorporate the calculation into the pivot table somehow.
As an easy example. The below is a pivot table.
Date as column
colour as row
amount of the [Values]
then I am just trying to add a formula called "Amount/8" - which takes the total of the 'colour' column and divides by 8.
Sum of amount Column Labels Jan Feb Grand Total Row Labels brown 2 2 green 2 29 31 red 2 12 14 Grand Total 6 41 47 Total Amount/8 0.75 5.125 5.875