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