Pivot Table Question
 

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
--
Though daily learning, I LOVE EXCEL!
Jennifer

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