+ Reply to Thread
Results 1 to 1 of 1

Calculating percent change in Excel Pivot Table

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    1

    Calculating percent change in Excel Pivot Table

    Using standard Excel 2010 I am trying to calculate percent change from the years 2013 to 2014 and put that in a column after grand total.

    The formula I am trying to use is (2013 - 2014) / 2013

    I have tried Calculated Field but that hasn't worked, and I can't do Calculated Item since I grouped my dates to show in years instead of days. Does anyone know how I can go about calculating the percent change?

    p-table.png

    Any and all help is appreciated!
    Last edited by JBeaucaire; 10-16-2014 at 10:32 PM.

+ 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] Calculating percent change when the base is a negative number
    By yamalady in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-24-2016, 10:20 AM
  2. Percent Change in Pivot Tables!
    By keekdapolak in forum Excel General
    Replies: 2
    Last Post: 06-21-2012, 04:06 PM
  3. Pivot Table Percent Of
    By yawnzzzz in forum Excel General
    Replies: 3
    Last Post: 02-17-2011, 11:07 AM
  4. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  5. Replies: 1
    Last Post: 06-20-2010, 04:00 AM

Tags for this Thread

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