Profit Margin % in Pivot Table

[Ed_Global]

I have gross sales cost and margin in a pivot table and want to show the margin %. I do have the margin % at line level in my data set but bringing this in it adds up all my margin %'s so gives incorrect data.

I could create a calculated field in the pivot table I suppose but I thought I'd minimise field numbers and show the margin figure I have as a % of the sale value as thought this would work.

Any ideas or do I revert to plan A?

Ed