+ Reply to Thread
Results 1 to 2 of 2

Calculated Field in Pivot Table

  1. #1
    Registered User
    Join Date
    12-08-2005
    Posts
    7

    Calculated Field in Pivot Table

    My pivot table is setup like this:

    Name.........Pass..........Fail.........Total
    Joe.............3...............1.............4
    Nancy.........4...............1.............5

    Where the Pass and Fail numbers are actually one field (QC Result) broken out by the two values that populate that field, Pass or Fail. The pivot table then added the Total column at right as a simple sum.

    In trying to add a calculated field, Excel is only letting me divide one existing field in the list by another existing field in the list. But the data on which I want to calculate is actually from one field, QC Result. I would like to do the following formula: (Count=Pass / Total Count).

    And ideally would like it to show as a single column to the right of the "Total" column.

    Am I missing something here, or do I need to setup my pivot table another way?
    Last edited by JPritch; 07-08-2009 at 03:04 PM.

  2. #2
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Calculated Field in Pivot Table

    Check below link to know about calculated field ...

    http://www.excelforum.com/excel-gene...pie-chart.html
    If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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