Pivot Table Calculated Field Problem

G

Guest

I am having the following problem: Take 10 rows of data, which includes
columns for price, quantity and total (price*qty); When I look at the data
with subtotals I get one set of Grand Totals, but when I use a calculated
field to generate 'total' using price * qty, the pivot table answer is 3x
larger than it should be. Ideas? TY
 
D

Debra Dalgleish

If you use a calculated field, it will multiply the sum of price by the
sum of quantity, giving you an incorrect answer. It's better to use the
total field that's calculated in your source data.
 

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

Insert Calculated Field (wrong Qty*Price = wrong Amount) 8
Pivot Table Formula not multiplying correctly 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table - 3
Pivot Table - Calculated Field 2
Pivot Table Calculated Field - Sum/count 1
can i add subtotals to subtotals in a pivot table? 1
Pivot Table Calculated field error 1

Top