Results 1 to 3 of 3

Thread: How to add a % column to pivot table????

  1. #1

    How to add a % column to pivot table????



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello - See attached. I am trying to add a column to both the pivot tables on the far left and right side of this sheet.

    Now I am hearing that if this is a shared spreadsheet.. that it is not possible to do this.. ( which it is, and i'm not 100% sure if that is accurate)

    I am trying to show the % of appts sold vs. appts set.

    If you notice on the far right I did this but this shows the total not broken down by Rep name like the pivot table on the right.

    Can someone please help?! Book3.xlsx

  2. #2
    See if this works for u..pls go thru the attachment
    Attached Files Attached Files

  3. #3
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Hi

    No, you cannot create or modify Pivot Tables in a shared workbook, as well as other restrictions.
    Features that are unavailable in shared workbooks
    http://office.microsoft.com/en-ca/as...010801033.aspx

    You could create Pivot Tables in another workbook (no shared) based upon the data from your shred workbook.

    The reason you cannot see the same breakdown in your third Pivot Table, is that you have not allocated Regional Manager as a Row item below IS Manager.
    Once you do this then you will see all of the data.
    Personally, I would change the formula in the last column, as I have shown in the attached upload
    =IF(K4="","",K4/J4)
    Attached Files Attached Files
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •