+ Reply to Thread
Results 1 to 5 of 5

Pivot Table adding % increase column

  1. #1
    Registered User
    Join Date
    01-16-2012
    Location
    Canada
    MS-Off Ver
    Excel 2016/19
    Posts
    6

    Pivot Table adding % increase column

    I would like to add a % increase column in my current pivot table
    I will keep it simple.
    Column A - Period 1-12 down the left side
    Column B - Year 2011
    Column C - Year 2012
    In column D on the pivot table I would like to have a percentage increase/decrease for amounts for the years 2011(B) to 2012(C) for each period.
    I am not sure if I create something before hand or after the table is set up

    I am using excel 2010

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Pivot Table adding % increase column

    Hi Molson,

    On Pivot table field list, click on Column D data field -> Value Field Settings -> Show values As and you'll find many options in the drop down where you can easily play around. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Pivot Table adding % increase column

    Hi There,

    You can upload your example file and outline your desired output with some comments and I can try to get it for you




    Thanks,

    Bonny Tycoon


    **If I was able to help please click the small star icon at the bottom left of my post **

  4. #4
    Registered User
    Join Date
    01-16-2012
    Location
    Canada
    MS-Off Ver
    Excel 2016/19
    Posts
    6

    Re: Pivot Table adding % increase column

    It worked

    Thank you

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Pivot Table adding % increase column

    You are welcome Molson..

    cheers

    Request you to mark this thread as [SOLVED].. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ 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