+ Reply to Thread
Results 1 to 8 of 8

Calculating percentage in Pivot Table

  1. #1
    Registered User
    Join Date
    05-21-2018
    Location
    Dubai
    MS-Off Ver
    Office 360
    Posts
    5

    Unhappy Calculating percentage in Pivot Table

    Hi,
    I have a problem with my pivot table. I need a new column next to 2018 column that calculates the percentage growth of 2018 over 2017.
    I'm new to the pivot tables please help me with this as it's driving me crazy.

    I have attached the excel sheet.

    Update : I have asked the same question on mrexcel forum with the same subject and I've alerted them.

    Untitled.jpg
    Attached Files Attached Files
    Last edited by AhmedAbdelhai; 06-06-2018 at 09:18 AM. Reason: complying with rule 8

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

    Re: Calculating percentage in Pivot Table

    Hello,
    There are many ways. I showed you one using auxiliary columns. This trend is a computational field in the pivot table (2018 / 2017-1).
    Attached Files Attached Files

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Calculating percentage in Pivot Table

    Rule 08: Cross-posting Without Telling Us

    Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    No further help to be offered, please, until the OP has complied with this request.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    05-21-2018
    Location
    Dubai
    MS-Off Ver
    Office 360
    Posts
    5

    Re: Calculating percentage in Pivot Table

    I'm Sorry, I didn't know about that. Will be careful next time.
    I've asked the same question on mrExcel.
    I can't post the link because I'm below 10 posts. But I've alerted the other forum.
    Thank you.

  5. #5
    Registered User
    Join Date
    05-21-2018
    Location
    Dubai
    MS-Off Ver
    Office 360
    Posts
    5

    Re: Calculating percentage in Pivot Table

    Quote Originally Posted by stasinek View Post
    Hello,
    There are many ways. I showed you one using auxiliary columns. This trend is a computational field in the pivot table (2018 / 2017-1).
    Thank You Very Much! It worked!!
    Last edited by AhmedAbdelhai; 06-06-2018 at 09:24 AM. Reason: Quoting

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Calculating percentage in Pivot Table

    I've asked the same question on mrExcel.
    I can't post the link because I'm below 10 posts
    type out the other URL. Do not try to copy and paste.

  7. #7
    Registered User
    Join Date
    05-08-2012
    Location
    england
    MS-Off Ver
    Microsoft 365 enterprise
    Posts
    26

    Re: Calculating percentage in Pivot Table

    Quote Originally Posted by stasinek View Post
    Hello,
    There are many ways. I showed you one using auxiliary columns. This trend is a computational field in the pivot table (2018 / 2017-1).
    Hi I am sorry to jump on this thread but keen to learn how this was done I have downloaded the file but cant work out how you added the computational field

  8. #8
    Registered User
    Join Date
    05-21-2018
    Location
    Dubai
    MS-Off Ver
    Office 360
    Posts
    5

    Re: Calculating percentage in Pivot Table

    Quote Originally Posted by magpie2000k View Post
    Hi I am sorry to jump on this thread but keen to learn how this was done I have downloaded the file but cant work out how you added the computational field
    The source data table was altered in a way that sales of 2018 and 2017 were separated in 2 columns rather than having them in one. That way they appeared in the pivot table and could get the percentage by entering the formula as =SalesQty2018/SalesQty2017-1 in the "fileds,items and sets" under the Analyze tab under the pivot table options.

    Untitled2.jpg

+ 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. Replies: 4
    Last Post: 02-02-2016, 12:36 PM
  2. [Urgent]Calculating percentage in pivot table
    By marco1wong in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-11-2015, 06:05 AM
  3. [Urgent]Calculating percentage in pivot table
    By marco1wong in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-09-2015, 05:51 AM
  4. [SOLVED] Pivot table Help with calculating a pass fail percentage
    By NoobSupreme in forum Excel General
    Replies: 2
    Last Post: 08-04-2014, 05:04 AM
  5. Pivot table - calculating percentage on grand total
    By sri023 in forum Excel General
    Replies: 3
    Last Post: 07-13-2012, 02:42 PM
  6. Replies: 5
    Last Post: 06-08-2012, 03:24 PM
  7. Calculating a percentage from a table that will grow
    By Mawhood in forum Excel General
    Replies: 1
    Last Post: 01-28-2010, 02:23 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