+ Reply to Thread
Results 1 to 2 of 2

Pivot Table needs % of grand total column

  1. #1
    Registered User
    Join Date
    03-06-2019
    Location
    Australia
    MS-Off Ver
    macosx
    Posts
    8

    Pivot Table needs % of grand total column

    Hello I have a table, as attached, that has been analysed with a pivot table that breaks down the number of PC vs PN for each ST in the table, and provides the sum of PC + PN for each ST. But I also need the % of each sum of PC + PN of the grand total. For example, from line 1, for ST 5, there are 3 PC and 0 PN that sum 3 PC + PN, and calculate to 4.68% of the total of 64 samples. I don't want 'sub-percentages' for PC and PN, just one more column in J that gives me the % of grand total for each total ST count.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Pivot Table needs % of grand total column

    you could add "ST" to Data Field a 2nd time, set to Count and show as % of Grand Total

    the above will generate your required Grand Total % - e.g. 4.69%, 17.19% etc but also generate 2 other columns you likely don't want -- (% of PC, % of PN) -- there's no elegant way of handling these aside hiding / grouping (and collapsing) the columns.

+ 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. Specifying one column in the grand total row in a pivot table
    By Phixer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2014, 12:35 PM
  2. Pivot Table (Need :- % of Grand Total Column)
    By sam99 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-20-2013, 03:56 AM
  3. Pivot Table - Grand Total not the sum of the column
    By Harrold in forum Excel General
    Replies: 2
    Last Post: 10-25-2011, 11:23 AM
  4. pivot table and % on grand total column only
    By Mm73 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-02-2007, 09:41 AM
  5. [SOLVED] Pivot Table -- Add column to average Grand Total
    By Lynn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 05:05 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