Adding Calculations to Pivot Tables help

[PierremontQuaker03]

Hi thanks for looking.
I am looking to add calculations (a percentage margin) to each of the two pivot tabs:
- Pivot
- Pivot by Resp Center

I can't seem to get it to work using the calculated field function - any ideas.

As an example in the Pivot tab I am wanting a formula for D5/D3.

Is there any way of doing it?

 

[Chihiro]

You can't using traditional Pivot Table.

You'll need Power Pivot and need to calculate using DAX measure.

 

[PierremontQuaker03]

You can't using traditional Pivot Table.

You'll need Power Pivot and need to calculate using DAX measure.

OK I have put it into a power pivot - how would I write the formula please? Thanks