Pivot Table Calculated Field Problem

H

headly

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

Consolidation Table from Different Excel Tabs with Different Format 1
Insert Calculated Field (wrong Qty*Price = wrong Amount) 8
Pivot Table Formula not multiplying correctly 2
Slicers and Calculated Items in Pivot Table 2
Additional columns for Pivot table 0
Pivot Table Counting Text Data 0
Pivot Table - 2
How do I perform extended calculations in a Pivot Table in Excel 2 4

Top