+ Reply to Thread
Results 1 to 2 of 2

Trying to Calculate Difference from two columns

  1. #1
    Registered User
    Join Date
    01-17-2020
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    8

    Trying to Calculate Difference from two columns

    Hi, this should be simple but I am trying to have the final column calculate a NET # instead of a SUM in this pivot table. The sample I attached is not a pivot, but is what the pivot looks like. How do I make it so that column D shows the difference between column B and C within a pivot table.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,705

    Re: Trying to Calculate Difference from two columns

    Show us what the source data looks like. Once we have that this can be achieved using Power Pivot and creating a new measure to show the difference. For your version of Excel, you will need to download Power Pivot from Microsoft. It is native in later versions starting with 2016 and does not need to be added in.

+ 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. Replies: 12
    Last Post: 12-02-2015, 12:30 PM
  2. Replies: 1
    Last Post: 08-14-2014, 10:37 AM
  3. Calculate average difference between two columns of data [if criteria is met]
    By samcdavies in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2013, 04:56 AM
  4. [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
  5. [SOLVED] Formula Query: How to calculate the difference between two columns of data?
    By The_Snook in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2012, 08:14 AM
  6. [SOLVED] how to calculate difference in two columns either positive or negative ?
    By spandan21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2012, 10:40 AM
  7. Replies: 1
    Last Post: 02-09-2006, 08:45 PM

Tags for this Thread

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