+ Reply to Thread
Results 1 to 3 of 3

Pivot Table - Display 2nd value as a percentage of 1st value

  1. 06-09-2014, 01:41 PM #1
    Kehjz
    Kehjz is offline
    Registered User
    Join Date
    08-18-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    41

    Pivot Table - Display 2nd value as a percentage of 1st value

    Hi,

    I would like to display the 2nd value in a pivot table to be a percentage of the 1st value.

    Attached is the image. Highlighted is what I want to be displayed in Column C.

    2014-06-10 01_38_34-HAHA - Excel.jpg

    2014-06-10 01_38_41-HAHA - Excel.jpg

    Any help is appreciated.

    Thanks a lot.
    Reply With QuoteRegister To Reply
  2. 06-09-2014, 01:59 PM #2
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Pivot Table - Display 2nd value as a percentage of 1st value

    Can you upload a workbook containing realistic data with what you expect as a result? We can't realistically work with pictures.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  3. 06-09-2014, 02:03 PM #3
    Kehjz
    Kehjz is offline
    Registered User
    Join Date
    08-18-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Pivot Table - Display 2nd value as a percentage of 1st value

    Quote Originally Posted by newdoverman View Post
    Can you upload a workbook containing realistic data with what you expect as a result? We can't realistically work with pictures.

    Hi,

    Sorry, here's the file with the desired outcome in Column I.

    Thanks a lot!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 - count values greater than some number, and display percentage of total
    By mastabog in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-12-2013, 10:53 PM
  2. Excel 2007 : pivot table percentage
    By mubeenff in forum Excel General
    Replies: 0
    Last Post: 03-28-2012, 03:00 AM
  3. Calculate/Display Percentage in a Pivot Table based on an alternate Total
    By bajdr47 in forum Excel General
    Replies: 1
    Last Post: 01-22-2012, 01:06 AM
  4. Percentage in a Pivot table
    By jomili in forum Excel General
    Replies: 3
    Last Post: 06-21-2010, 03:31 PM
  5. display data as a percentage of a subtotal in excel pivot table
    By Fl pivot user in forum Excel General
    Replies: 2
    Last Post: 03-26-2005, 09:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1