ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Question (https://www.excelbanter.com/excel-discussion-misc-queries/35040-pivot-table-question.html)

Jennifer

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

Debra Dalgleish

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