+ Reply to Thread
Results 1 to 4 of 4

Pivot table - show as a percentage of subtotal

  1. 04-01-2018, 07:44 AM #1
    Hdarweesh
    Hdarweesh is offline
    Registered User
    Join Date
    08-06-2017
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    2

    Pivot table - show as a percentage of subtotal

    Hello

    I want to show the values as a percentage of subtotal

    pp.png
    Reply With QuoteRegister To Reply
  2. 04-01-2018, 09:18 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Pivot table - show as a percentage of subtotal

    Hi Hdarweesh and welcome to the forum,

    Do you know about:
    https://support.office.com/en-us/art...6-0959B0B13A72
    or
    https://www.pryor.com/blog/how-to-sh...el-pivottable/

    Does the attached do what you want?

    PT Percent Of.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 04-01-2018, 09:35 AM #3
    Hdarweesh
    Hdarweesh is offline
    Registered User
    Join Date
    08-06-2017
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    2

    Re: Pivot table - show as a percentage of subtotal

    thank for your kind reply,
    but I need to show the percentage of total, like this

    pp.png
    Reply With QuoteRegister To Reply
  4. 04-07-2018, 09:25 AM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,556

    Re: Pivot table - show as a percentage of subtotal

    Perhaps this will be helpful.
    The two columns adjacent to the pivot table are populated using:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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. [SOLVED] Subtotal Percentage Calculation on a Row in a Pivot Table
    By AustinLe in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-23-2015, 02:03 PM
  2. How do I show percentage in a Pivot table?
    By Motox in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-21-2013, 02:22 AM
  3. Pivot Table - Show value as % of subtotal
    By rmisra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2012, 12:47 PM
  4. Continue to Pivot Table: adding a percentage field as '% of Subtotal'
    By petrpan in forum Excel General
    Replies: 1
    Last Post: 12-23-2010, 08:44 AM
  5. Pivot Table: adding a percentage field as '% of Subtotal'
    By Sauvenix in forum Excel General
    Replies: 12
    Last Post: 05-15-2010, 03:02 AM
  6. Show data as % of subtotal in pivot table
    By oliverosph in forum Excel General
    Replies: 0
    Last Post: 03-28-2005, 12:54 PM
  7. 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