+ Reply to Thread
Results 1 to 8 of 8

Pivot Table Grand Total Percentage Error

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    7

    Pivot Table Grand Total Percentage Error

    Please help with fixing the error in grand total percentage. The percentage should be 50% ($300-$200)/$200 instead of the generated 225%. Many thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,910

    Re: Pivot Table Grand Total Percentage Error

    The sum of % is correct, but not what you need

    Add a calculated field with formula =(Income-Expense)/Expense

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

    Re: Pivot Table Grand Total Percentage Error

    Hi rosehill,

    welcome to the forum.

    See the attached file where I used a calculated filed in pivot table to achieve your desired %.

    Grand Total %.xls


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  4. #4
    Registered User
    Join Date
    03-12-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Pivot Table Grand Total Percentage Error

    Quote Originally Posted by Pepe Le Mokko View Post
    The sum of % is correct, but not what you need

    Add a calculated field with formula =(Income-Expense)/Expense
    Thanks and I've now realised how to add this calculated field.
    Last edited by rosehill; 03-12-2013 at 07:22 PM.

  5. #5
    Registered User
    Join Date
    03-12-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Pivot Table Grand Total Percentage Error

    Quote Originally Posted by dilipandey View Post
    Hi rosehill,

    welcome to the forum.

    See the attached file where I used a calculated filed in pivot table to achieve your desired %.

    Attachment 220189


    Regards,
    DILIPandey
    <click on below * if this helps>
    Thanks so much for this. Please advise how to add this Calc %.

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

    Re: Pivot Table Grand Total Percentage Error

    Its already added...

    To add this, click on pivot -> go to top ribbon option "ANALYZE"-> "Fields, Items & Sets"->Calculated field.
    click on the drop down on the field "Name"and there you'll see the calculated field and the formula in the next field

    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Registered User
    Join Date
    03-12-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    7

    Thumbs up Re: Pivot Table Grand Total Percentage Error

    Quote Originally Posted by dilipandey View Post
    Its already added...

    To add this, click on pivot -> go to top ribbon option "ANALYZE"-> "Fields, Items & Sets"->Calculated field.
    click on the drop down on the field "Name"and there you'll see the calculated field and the formula in the next field

    Regards,
    DILIPandey
    <click on below * if this helps>
    Thanks heaps. You're really a big help!

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

    Re: Pivot Table Grand Total Percentage Error

    you are welcome rose....

    please mark this thread as [SOLVED].. thx


    Regards,
    DILIPandey
    <click on below * 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