• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

Pivot, Calculation on Column field

Take a look at the image below. Is it possible to make the difference calculation I have done in column F as a calculated field inside the Pivot? So that the difference field workes like a part of the Pivot. Appreciate any replys.

Example pivot to illustrate my problem
1 Solution

Yo could add an item SelectColumn Labels

then Click Calculations / Fields, Items & Sets Choose  Calculated Item

Change The name to Diference and Formula ( like in example)

helpfinderIT ConsultantCommented:
yes, it is possible. You will create pivot table and then add a Calculated Item.
Make pivot table in regular way. then click on the Pivot table and in Ribbon choose Analyze from Pivot Tools. Then Fields, Items, Sets and Calculated Item:

Name your field and make a calculation you need to do:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now