Pivot tabel Calculated field

[bt123123]

Hi All

I have a question about pivot table calculated field

In pivot table, i want to add 'calculated field' (Average of C.price in sheet stock) - (P.Price in sheet stock)

cal field 1.JPG


Many thanks

[Ochimus]

Click any cell inside the pivot table.
On Options or Analyze tab in the Calculations group, click Fields, Items & Sets and click Calculated Field.
'Insert Calculated Field' dialog box appears.
Enter whatever name you want to give the Calculated Field
Type in your formula
Click Add button
Click OK button
Excel creates the 'Calculated Field', and posts it as a Value in the Fields List. As it will contain numbers, it sets to "Sum" as default, which you can change to whatever you want.

Hope this helps

Ochimus

[bt123123]

Hi

In 'calculated field' , I want to add this calculation (Average of C.price in sheet stock) - (P.Price in sheet stock)

Thx
Steven

[Ochimus]

bt123123,

Yes, as I explained above, you put whatever formula you want in the 'Insert Calculated Field' dialog box.

Ochimus