Pivot Table; how do I calculate margin percentage?

In the data field of a pivot table I have the sum of the the turnover and the sum of the margin, what I want to show is the margin as a %, how can I do this?
David Jarvis

Comments
There are 7 comments. Login or register to view them.

Pivot table

djarvis123 |

I think

neileg |

Use a calculated field

tom123 |

Pivot Tip #6

David Carter |

Ah yes

neileg |

Format cells - Percentage

David Carter |

Pivot Table

djarvis123 |