+ Reply to Thread
Results 1 to 4 of 4

Pivot table to show difference between column instead of sum (Urgent)

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Pivot table to show difference between column instead of sum (Urgent)

    Hi, i am doing a report to show variance between 2 years. HOwever, my pivot table keep on summing the year 2 instead of minus. I tried to do it in value setting, but in vain. Anyone can help?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot table to show difference between column instead of sum (Urgent)

    For example, using auxiliary columns and the YoY calculation field.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Re: Pivot table to show difference between column instead of sum (Urgent)

    Can you teach me how u get the YoY column?

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot table to show difference between column instead of sum (Urgent)

    I'll try,
    1. You must place the mouse cursor within the pivot table.
    2. Then click the "Analysis" tab from the main menu,
    3. Select the "Calculation field" from the drop-down menu.
    4. Enter the title and continue the formula for this field, e.g. "2017-2016" and add.

+ 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: 1
    Last Post: 04-30-2018, 08:09 AM
  2. One Pivot table to show different column results with slicer
    By milo1984 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-30-2018, 06:26 AM
  3. Calculating ppts difference from % of column total data in a pivot table
    By TJGriffiths in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-10-2017, 09:49 PM
  4. Pivot Table to Show difference between Min and Max Value
    By bigroo1958 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2013, 09:06 PM
  5. Pivot table to show certain column in descending order
    By rushdenx1 in forum Excel General
    Replies: 1
    Last Post: 01-04-2012, 05:32 AM
  6. Replies: 7
    Last Post: 08-04-2011, 09:32 AM
  7. 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