+ Reply to Thread
Results 1 to 2 of 2

Compare Pivot Table Columns to show Percentage Change

  1. #1
    Registered User
    Join Date
    01-29-2016
    Location
    FL
    MS-Off Ver
    2016
    Posts
    1

    Compare Pivot Table Columns to show Percentage Change

    Hello All,
    I've been attempting to make some comparison's in a Pivot Table but have run into some struggles. I have a PT setup in Excel 2016 with 2 columns "Month" and "Year", and they columns represent sales data for their respective months and states in a corresponding row. As such I would like to demonstrate in my PT the Percentage Change of that month between the years. I have attempted to add an additional "sales" line to the values section.Here is have selected "Summarize values by>Sum" and "Show Values As" >"% Difference From". I have selected the Base field as "Year" and the Base Item as "Previous" I also attempted to try the latter with Base Field "Month" and Base Item "previous" neither of which are functioning. Any help or guidance is always appreciated.

    I have linked two images. First what I have and second what I would like to accomplish. I basically need to remove the extra columns denoted by the arrows in the screenshot.

    1. https://www.evernote.com/shard/s101/...465753da57e213
    2. https://www.evernote.com/shard/s101/...75eae9ee27cadb



    Thanks in advance for your help!

    Best :: CD

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Compare Pivot Table Columns to show Percentage Change

    See my proposal with the field computing
    Attached Files Attached Files

+ 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] Show percentage of results in a Pivot table
    By rogelinepaula in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-24-2015, 09:44 PM
  2. Pivot table - how to show percentage of total?
    By GoldbergJesse in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2015, 03:31 PM
  3. [SOLVED] Running percentage change in a pivot table?
    By Jay T in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-12-2013, 12:01 AM
  4. How to calculate percentage change between values in a pivot table
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-03-2013, 01:48 PM
  5. How do I show percentage in a Pivot table?
    By Motox in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-21-2013, 02:22 AM
  6. Replies: 8
    Last Post: 03-16-2011, 02:16 PM
  7. Replies: 2
    Last Post: 04-14-2010, 05:26 PM

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