+ Reply to Thread
Results 1 to 2 of 2

Pivot showing percentage in Grand total grouped by first column

  1. #1
    Forum Contributor
    Join Date
    03-14-2005
    Posts
    164

    Pivot showing percentage in Grand total grouped by first column

    Hi all,

    i'm trying to crack what should surely be a simple problem.
    Attached is my spreadsheet.

    As you can see I have 3 columns of detail, with totals spread over a number of months.

    I want to be able to display the percentage of the Resource total for each other grouping.

    For example, in my spreadsheet you can see resource Mick Arber at the top.
    I want to be able to see each of his rows as a percentage of HIS total.

    Please help!

    I appreciate it


    thanks in advance,
    Matt
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Pivot showing percentage in Grand total grouped by first column

    Hi,

    I have added % column into your Pivot Table. Please check if this is what you are looking for.


    Regards,
    Chandra

    Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.
    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] Pivot Table Grand Total Percentage Error
    By rosehill in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2013, 10:01 AM
  2. Replies: 0
    Last Post: 10-15-2012, 06:09 PM
  3. Pivot table - calculating percentage on grand total
    By sri023 in forum Excel General
    Replies: 3
    Last Post: 07-13-2012, 02:42 PM
  4. Pivot Table Percentage of Grand Total Column
    By Jacob in forum Excel General
    Replies: 6
    Last Post: 03-08-2006, 01:10 AM
  5. Grand Total on Pivot Table turned on but no totals showing
    By GaryRitchie in forum Excel General
    Replies: 0
    Last Post: 06-15-2005, 09:13 AM

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