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
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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>