![]() |
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 |
All times are GMT +1. The time now is 03:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com