Pivot table is giving me wrong answer

[INN]

Hi
In pivot table, I created a new field called Total which is the Price*Unit. I moved the new field, Total, to Values box in Pivot table and I got total = 60 which I think is wrong because the Total should be 30. Then I want to Slice by Item, so I moved Item as my Rows and I still got the wrong answer. So which answer is correct? 30 or 60 and what do you call the 30 and what do you call the 60? How to correct that. Thank you very much. The link to excel file is below.

Total.xlsx
	A	B	C	D
1	Data Table
2	Item	Unit	Price
3	A	1	10
4	B	2	10
5
6
7	First Pivot Table - Creating new Field callled Total
8	Row Labels	Sum of Unit	Sum of Price	Sum of Total(Unit*Price)
9	A	1	10	10
10	B	2	10	20
11	Grand Total	3	20	60
12
13
14	Second Pivot table - Moved Total to Values
15	Sum of Total(Unit*Price)
16	60
17
18
19	3rd Pivot table - Moved Total to Values and Item to Rows box
20	Row Labels	Sum of Total(Unit*Price)
21	A	10
22	B	20
23	Grand Total	60
Sheet4

Link to the Excel File

Loading Google Sheets

 

[gelu]

Hello Inn,

The Grand Total in a calculated field is still doing what it was told to do instead of being a proper Grand Total as one would expect.:

Here it multiplies 3x20 = 60, it does not add the column, and it won't, that's how it works.

Solutions:
- do the calculation in the source table
- do the total of the calculated field column in a cell outside the pivot

G