Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |