You should calculate the Gross for each item in the source table, and
add that field to the pivot table. Then, it will calculate and sum
correctly.

Jennifer wrote:
Hey all,
Love pivot tables but i have a question, the table is set up as so
Month Pallet# BoxesPur BoxesSold Price Frt Gross
Net
Jan 1 5 1.0
.3 Formula Formula
2 5 2.0
.5
3 10 3
.15
Jan Total 10 10 6.0
.95

So, the problem is in the Jan Total row, is there a way to get the gross
column to sum the column instead of multipling the boxes purchased by the
price. Because the 6*10 if no the correct gross amount.
Anyone have any ideas. Thank you, Jennifer


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html