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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Question 1
Countifs or a pivot 1
Pivot Table Variance 2
Headings for Sum in Pivot Table. 5
Multiple Headings in Pivot Table 1
Pivot Table Data Column Sort Excel 2007 1
Pivot Table Set Up 2
Pivot table data layout - columns to rows 1

Back
Top