+ Reply to Thread
Results 1 to 6 of 6

Calculating difference in values when figures are in the same field

  1. #1
    Registered User
    Join Date
    09-12-2014
    Location
    UK
    MS-Off Ver
    2003
    Posts
    7

    Calculating difference in values when figures are in the same field

    I'm sure this is really simple but I can't figure it out. I want to display a quarterly revenue variance in a pivot table, but the quarters I want to compare are in the same column in the source data (labelled 'Qtr').

    I can add a second Revenue field under values and use 'Show Values As..', but then I end up with superfluous empty column which I don't want. Think I'm approaching this in totally the wrong way. Any help is greatly appreciated.

    Capture.PNG
    Attached Files Attached Files
    Last edited by Blinky99; 05-11-2019 at 07:35 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculating difference in values when figures are in the same field

    Hi,

    You probably just need to add a calculated field to your PT definition and set it to be Q4-Q3
    However upload the workbook so that we may see the request in context.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-12-2014
    Location
    UK
    MS-Off Ver
    2003
    Posts
    7

    Re: Calculating difference in values when figures are in the same field

    Hi Richard. Thanks for your response, I've added the attachment, which is a quick example I've put together.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculating difference in values when figures are in the same field

    See attached.

    You just need to add a the 'Rev' field a second time in the Values area of the PT and change the settings to 'Show Values as differece from'...and pick 'Qtr' and 'previous'
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-12-2014
    Location
    UK
    MS-Off Ver
    2003
    Posts
    7

    Re: Calculating difference in values when figures are in the same field

    Excellent, thanks.

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculating difference in values when figures are in the same field

    My pleasure. Glad it helped

+ 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: 2
    Last Post: 04-16-2015, 12:12 AM
  2. [SOLVED] Calculating the difference between 2 values
    By tapsmiled in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2014, 08:51 PM
  3. Calculating difference based on specific cell values
    By thelegazy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2013, 05:36 PM
  4. Calculating % difference between two % values?
    By zudecke in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-01-2013, 06:33 AM
  5. Calculating the difference between monthly figures
    By cazz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2013, 01:59 PM
  6. How to set significant figures when calculating values in code?
    By gonger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2009, 05:01 PM
  7. [SOLVED] Calculating Absolute Difference Between Two Time Values
    By markxus in forum Tips and Tutorials
    Replies: 3
    Last Post: 08-10-2005, 01:43 AM

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