Pivot Table - Adding new calculation field within

[share_knowledge]

I have an exist pivot table which breaks revenue and cost down by project. Now, i'd like to add another FIELD within that pivot table where that field will calculate the % of cost/revenue. Here is an example:

Pivot Table

A1 B1 C1 D1 <---looking for this field in %
Project Revenue Cost Cost_%
ABC $100 $10 10% (cost / rev)

I tried so many method but cannot make this happen. I originally set up the cells to link on the side but every time i add new project and refresh the pivot table, the numbers don't seem to match at all. Please advice.

Thanks,

 

[Stormseed]

I did not understand your question completely for you did not provide an example...I am providing you with a link though for your reference:

http://www.exceltip.com/st/PivotTab...ge_Difference_from_the_Previous_Item/752.html