+ Reply to Thread
Results 1 to 1 of 1

Help adding Row % in Pivot table

  1. 04-16-2014, 06:09 AM #1
    JEB
    JEB is offline
    Registered User
    Join Date
    07-16-2007
    Posts
    30

    Help adding Row % in Pivot table

    Have been head scratching with this all morning and can't figure it out, wonder if someone could help please.

    In the attached pivot table example I want a column added to the right of the "Grand Total" which shows the % of the "Yes" row\column compared to the row "Grand Total". I have added a manual column with the % calculation in column E, but I want this to be calculated within the area of the pivot table instead. Could anyone help provide me the steps to achieve that please?
    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. [SOLVED] Adding columns to pivot table
    By sur4j in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-11-2014, 07:42 PM
  2. Adding more than 255 columns to Pivot table
    By ReplicaR in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-30-2012, 03:00 PM
  3. Adding formula to active table and for pivot table in macro
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2012, 08:12 AM
  4. Adding a column to a pivot table
    By ezzy85 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2008, 03:01 AM
  5. [SOLVED] Pivot Table - adding a new field
    By Pivot Table in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 03: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1