Pivot table sum columns

[Jennifer]

I have worked with pivot table for a long time now and i admit i can never
figure out how to get this part to work right. This is what my pivot table
looks like

Example
Produce Date Index Boxes Wt. of Box Price/LB Total $$
C 5/13/2008 6 20 35 $6 $4,200
5/14/2008 7 30 35 $6 $6,300
C Total 50 70 $12 $42,000

The c total for the Total $$ should really be the 4200+6300 and i can't
figure out how to get the total $$ and price/lb to work right. Any ideas?

 

[Roger Govier]

Hi Jennifer

Instead of using a calculated filed within the PT to get your Total$$, add
an extra column to your source data, called Total$$
with the formula to multiply boxes*boxweight*price

Extend your PT source to include this new column, and remove your calculated
field

The problem is that for calculated fields, they follow the formula that has
been set, as opposed to totaling the amounts, hence you are getting 50*70*12
to give $42,000