+ Reply to Thread
Results 1 to 9 of 9

% difference of two columns

  1. 03-23-2016, 12:30 PM #1
    bjbboats
    bjbboats is offline
    Registered User
    Join Date
    02-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    98

    % difference of two columns

    hi

    is it possible in a pivot to to calculate the % change of columns 2 and 3 of data versus column 1?

    Hopefully makes sense¬!

    Thanks
    Reply With QuoteRegister To Reply
  2. 03-23-2016, 12:51 PM #2
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: % difference of two columns

    attach a file with sample data, please
    Reply With QuoteRegister To Reply
  3. 03-23-2016, 12:54 PM #3
    bjbboats
    bjbboats is offline
    Registered User
    Join Date
    02-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    98

    Re: % difference of two columns

    Example attached. I want to show first and last as % diff of linear
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-23-2016, 01:43 PM #4
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: % difference of two columns

    See if it's the right solution
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-24-2016, 05:07 AM #5
    bjbboats
    bjbboats is offline
    Registered User
    Join Date
    02-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    98

    Re: % difference of two columns

    Sorry i mean % difference:
    linear 2016 vs first 2016
    linear 2016 vs last 2016
    linear 2015 vs first 2015
    linear 2015 vs last 2015
    Reply With QuoteRegister To Reply
  6. 03-24-2016, 05:49 AM #6
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: % difference of two columns

    Here you are
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 03-24-2016, 05:52 AM #7
    bjbboats
    bjbboats is offline
    Registered User
    Join Date
    02-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    98

    Re: % difference of two columns

    perfect!

    Any chance of an explanation so I can replicate?
    Reply With QuoteRegister To Reply
  8. 03-24-2016, 05:55 AM #8
    bjbboats
    bjbboats is offline
    Registered User
    Join Date
    02-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    98

    Re: % difference of two columns

    Just noticed the % values look like they are 100% more than they should be? Does that make sense?
    Reply With QuoteRegister To Reply
  9. 03-24-2016, 06:39 AM #9
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: % difference of two columns

    Percentage differences can be shown in different ways.
    When it comes to such a solution ratings for Field obliczeniomych PT.
    A list of formulas used in the table have the sheet "Formula".
    Attached Files Attached Files
    Last edited by stasinek; 03-24-2016 at 06:49 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Difference between row columns
    By bsmer27 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-08-2015, 12:23 AM
  2. Difference between two columns!
    By sukichweet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2012, 02:29 AM
  3. Difference between columns
    By MattG in forum Excel General
    Replies: 5
    Last Post: 01-29-2010, 12:49 PM
  4. Difference between two columns
    By PSmithson in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-22-2009, 12:28 PM
  5. difference between two columns
    By joukar in forum Excel General
    Replies: 6
    Last Post: 12-29-2008, 08:49 AM
  6. Difference between 2 columns
    By CP in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-25-2006, 01:15 PM
  7. charting a difference of 2 columns' w/o adding a difference column
    By Wab in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-26-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1