+ Reply to Thread
Results 1 to 2 of 2

Calculate difference between two columns from same field in pivot table

  1. #1
    Registered User
    Join Date
    09-21-2023
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    1

    Calculate difference between two columns from same field in pivot table

    I am trying to set up a headcount change report. I've listed the employee and then the different quarters and the report shows a 1 when the empoyee was there, blank if not. I would like to calculate the change between the quarters (columns) within the pivot but can't figure out how, casue the quarters are from the same field.

    see example attached

    thanks for any ideas.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,918

    Re: Calculate difference between two columns from same field in pivot table

    Would have been nice if there were actually a pivot table in your workbook, or an indication of where you want the results...

    You can simply add the value field again and choose to show it as a difference from previous item.
    Rory

+ 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] Show difference between two columns of the same field in a pivot table
    By Mingeita in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-13-2022, 06:52 AM
  2. Calculated field in a pivot table to show % difference between 2 columns
    By sa1ntj0hn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-09-2022, 08:14 PM
  3. Calculate difference between two times using Pivot Table Calculated Field
    By mouzzampk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-12-2019, 10:12 AM
  4. Replies: 1
    Last Post: 08-14-2014, 10:37 AM
  5. [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
  6. Replies: 3
    Last Post: 03-17-2010, 07:28 AM
  7. [SOLVED] Calculate Difference between 2 columns in Pivot table
    By Karen in forum Excel General
    Replies: 1
    Last Post: 02-09-2006, 08:45 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