+ Reply to Thread
Results 1 to 2 of 2

Sum & Percentage in Pivot Table

  1. #1
    Registered User
    Join Date
    03-14-2017
    Location
    France
    MS-Off Ver
    2010
    Posts
    18

    Sum & Percentage in Pivot Table

    Hi,

    I am trying to build a budget pivot table but there is a functionality which I don't know how to do

    Here is the pivot table

    Total Planned Q1 spent Q2 spent Q3 spent Q4spent
    Project A
    Project B
    Project C
    Project D
    Total Total total planned Total Q1 Total Q2 Total Q3 Total Q4


    That pivot table works but on the top of the total which is automatically calculated, below that line, I'd like to have the percentage spent vs Total planned. Ideally I'd like to have

    e.g. 100% 25% 30% 75% 101%
    Total Q1 + Q2 Total Q1+Q2+Q3 Total Q1+Q2+Q3+Q4

    Is there a way I can do this?

    Thanks in advance

  2. #2
    Registered User
    Join Date
    03-14-2017
    Location
    France
    MS-Off Ver
    2010
    Posts
    18

    Re: Sum & Percentage in Pivot Table

    Here is the table as we cannot read above:

    Untitled.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. Pivot table and percentage of row
    By qaiztan in forum Excel General
    Replies: 3
    Last Post: 05-05-2017, 09:53 AM
  2. Calculation within Pivot Table - Need Percentage
    By jmb68259 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 08:57 AM
  3. pivot table - sum as percentage of count
    By forkedtoro in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-11-2013, 01:14 PM
  4. Percentage in pivot table
    By Merijn in forum Excel General
    Replies: 4
    Last Post: 05-10-2012, 08:37 AM
  5. Excel 2007 : pivot table percentage
    By mubeenff in forum Excel General
    Replies: 0
    Last Post: 03-28-2012, 03:00 AM
  6. Percentage in a Pivot Table
    By rmikulas in forum Excel General
    Replies: 3
    Last Post: 10-13-2010, 03:59 PM
  7. Percentage in a Pivot table
    By jomili in forum Excel General
    Replies: 3
    Last Post: 06-21-2010, 03:31 PM

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