+ Reply to Thread
Results 1 to 4 of 4

Using Calculated Field to Express % Change in Pivot Table Columns

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2013
    Posts
    10

    Using Calculated Field to Express % Change in Pivot Table Columns

    Hey Y'all,

    I think this is relatively straight forward but I can't get my head around. I have a pivot table expressing values for three different months. What I'd like to have is a calculated column in the pivot table that compares one month to another and provides me a % difference.

    I realize I could do this by hand, but I'd rather have the Pivot table formula work to make this happen quickly.

    I've attached an example workbook for reference.

    example-1.xlsx

    Thanks for your help.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Using Calculated Field to Express % Change in Pivot Table Columns

    So for example, for CPC you would like to compare, April over March, May over April and so on?

    Is that right?

    If it is > Right Click On the Pivot > Show Values As > % Difference From > Base Field Month (Previous)

    Hope this helps..
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Using Calculated Field to Express % Change in Pivot Table Columns

    Thank you. This solved my question.

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Using Calculated Field to Express % Change in Pivot Table Columns

    If you have your answer, please mark the thread as solved..
    Last edited by NeedForExcel; 06-18-2015 at 12:01 AM.

+ 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. Pivot Table Calculated Field based on 2 columns
    By OldMan62 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-09-2014, 07:59 AM
  2. Calculated Field to get Percentage of Two Columns in a Pivot Table
    By mbhc77 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2013, 06:32 AM
  3. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  4. Replies: 0
    Last Post: 07-10-2010, 03:02 PM
  5. [SOLVED] pivot table formulas for calculated field or calculated item
    By Vicky in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 12:10 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