Pivot Table Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top