Adding a calculated field as a row to a pivot table

[Hambreak]

Hello,

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.

Thanks

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

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>