[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

difference between columns in pivot table excel 2007

The attached sample data currently shows a total for TOA and Critical.  Need to show the difference.  I thought I could field settings option and select "difference from" under the show values as droplist, yet for some reason this isn't working.  Also tried a calculated field, but was unsuccessful here too.

The pivot table needs to show the difference between the TOA and Critical for each FY (not the total as currently shown)
columnDifferenceSample.xlsx
0
jvantassel1
Asked:
jvantassel1
  • 2
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

Is that what you are looking for?

You have to create a calculated Item not an element.

Regards
columnDifferenceSamplev1.xlsx
0
 
jvantassel1Author Commented:
sorry for the delay, I was away for the holidays.  What are the steps to add the calculated item?
0
 
Rgonzo1971Commented:
HI,

click one of the "BO Description" (eg cell J5) in the PivotTable report. This gives Excel the context of what you are going to add a calculated item to. Next, on the PivotTable "Options" contextual ribbon, select the "Formulas" drop-down and then select "Calculated Item …".

Change the Name of the Formula as you want

Click on BO Description and then Dbl-Click on TOA, Insert "-" and Dbl-Click Critical to Create the Formula

then Click Ok,

You can then hide the years without data

Regards
0
 
jvantassel1Author Commented:
Thanks for the help.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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