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?




--
Thank you,

Jennifer