+ Reply to Thread
Results 1 to 2 of 2

Pivot Table on Status field

Hybrid View

Bluecrane Pivot Table on Status field 04-07-2009, 11:17 AM
DonkeyOte Re: Pivot Table on Status... 04-07-2009, 11:39 AM
  1. #1
    Registered User
    Join Date
    04-07-2009
    Location
    Austin
    MS-Off Ver
    Excel 2003
    Posts
    1

    Pivot Table on Status field

    Hello Everyone,
    I've searched long and hard for an answer to the following problem (no luck yet):
    I want to add two columns to a Pivot table that does some summarization to a status field.

    Below are two screen shots of both the Pivot Table and the data that is referenced.
    Data:
    Link to image of data

    Pivot:
    Link to image of Pivot Table

    What I really need is to add to the pivot table two percentages:
    1) Percentage of Approved (Approved / Grand Total for manager) Example: for Ann that would be 2 divided by 3 for a Percentage Approved of 67%.

    2) Percentage of Assessed (Assessed / Grand Total for manager) Example:
    for Ann, Assessed is 0 so Percentage Assessed is 0%

    Attached is a spreadsheet with the above pivot table and data.

    Any help would be greatly appreciated!
    Attached Files Attached Files
    Last edited by Bluecrane; 04-07-2009 at 11:49 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Pivot Table on Status field

    You could perhaps make use of Calculated Item feature... see attached

    Notes:

    a) I created in 2007 but in Compatibility Mode so hopefully it will work for you in earlier version...
    b) The number format is applied to all results so I set to General and then manually formatted columns E:F to %

    Hopefully a PT whizz can improve on this...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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