+ Reply to Thread
Results 1 to 4 of 4

How to calculate percentage change between values in a pivot table

  1. #1
    Forum Contributor
    Join Date
    06-19-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    180

    How to calculate percentage change between values in a pivot table

    Hi

    I'm trying to calculate the percentage change between values on a pivot table.

    I have attached a sample. What I want is for each column to know the %change for each day ie by how much was the new value up/down based on the previous day. I can do this the normal way by calculating %change and get the results but when I come to copy the formula (by dragging it down the rest of the columns) it just repeats the same number as in say E5 for when trying to find the % change of 1129 over 1107.

    I can do this manually for every line but that will take a lot of time. Is there any way in a pivot table to still calculate the differences and have this done automatically for all rows (by dragging it down)?

    In my real table I have hundreds of rows which will take a long time to find the % change for each one.

    Is this possible? If so please tell me how.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How to calculate percentage change between values in a pivot table

    you can add the data fields to the pivot again and choose 'Show values as', '% of...' and set the base item to 'Previous' if that is suitable

    you can also use '% difference from...' if you prefer
    Last edited by JosephP; 07-03-2013 at 07:19 AM.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: How to calculate percentage change between values in a pivot table

    do you want the % difference from previous day for each of those number values
    if so
    then add the number again into the data - sum of 1145 for example
    now click on field value settings and choose -
    >show value as
    >% of
    and select the day and previous
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to calculate percentage change between values in a pivot table

    @no.18tshirt

    if you show the desired (expected) result in your sheet, you will get better help.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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