Sum Calculated Field in Pivot Table

[usingexcel]

Hello,

I have a Calculated Field in Pivot Table. The formula is as under -

Gross Sales * Margin % = Margin Dollars

Now, on the subtotal line, it takes the Total of Gross Sales * Total of Margin % and gives me the Margin Dollars. However, I want want just the total of Margin Dollars. Is it possible? If so, how?

Thanks.