+ Reply to Thread
Results 1 to 2 of 2

Trying to Calculate the difference between 2 columns in pivot table

  1. #1
    Forum Contributor
    Join Date
    05-13-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    378

    Question Trying to Calculate the difference between 2 columns in pivot table

    Hello everyone!!

    So I am running in to a large brick wall! I have a single pivot tablet with a column for items received and then a column for items shipped. I would like to create a calculated field in the pivot table that will subtract the items received from the items shipped columns. I have attempted to add the calculated field using the tool bar but it keeps giving me "0" for every item on the pivot table when there are obvious differences.

    Does anyone have any ideas or a solution for this????

  2. #2
    Forum Contributor
    Join Date
    05-13-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    378

    Re: Trying to Calculate the difference between 2 columns in pivot table

    I have added a sample workbook with the data I am using to do this.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pivot table with years on columns. I cant calculate a difference in values
    By Daniel_da6 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-17-2013, 12:13 PM
  2. Replies: 7
    Last Post: 08-04-2011, 09:32 AM
  3. Calculate Date difference in pivot table
    By shinymcshires in forum Excel General
    Replies: 0
    Last Post: 12-16-2008, 02:46 PM
  4. Replies: 1
    Last Post: 02-09-2006, 08:45 PM
  5. Replies: 7
    Last Post: 01-30-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1