Sum Calculated Field in Pivot Table

usingexcel

New Member
Joined
Mar 1, 2006
Messages
13
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.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,108,999
Messages
5,526,167
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top