Pivot tables - calculations based on different sets of data

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a number of people included in a pivot table.

Per person I have a number of cases quality checked. For this I use "Count"
to get a total.

Then I have a number of errors per person. I need the function to display
it as a % of the column or the total, but this doesn't work since it
displays the % as a percentage of the gross total at the end of the pivot.

Question: How can I accurately provide the error % per person, expressed as
a percentage of the person's production figure that I counted in the first
instance?

I really need a subtotal underneath every person's name that indicates the
number of cases QA'd for that person as well as the error % for that person.

Thanks!
--
Anéll
.

Relevant Pages

  • Re: Displaying Text, not numbers, in Pivot Table
    ... Pivot tables are numeric. ... MS Excel MVP ... I am wondering if there is anyway to display ... interactive so it does not become overwhelming with all the summaries on ...
    (microsoft.public.excel.newusers)
  • RE: Pivot Table (same level hierarchy fields)
    ... just play with the auto formats off the format menu.. ... > I understand that Pivot Tables aggregate data based on hierarchy's--however, ... I would love to be able to display item ... I'm new to vba, but I ...
    (microsoft.public.excel.programming)
  • Access 2003 pivot table subform
    ... reason, it started failing to display the data when the pivot table on open, ... I get a message where the pivot table data ... “The query could not be processed: ... form itself, uses a query to get its data, and the query filters are driven ...
    (microsoft.public.access.forms)
  • Pivot table permissions issue
    ... I have a pivot table form based on a query on several tables. ... display is now of the weeks last chosen. ... non Admins user receives no warning they are restricted from changing the ...
    (microsoft.public.access.security)
  • Re: commands dialog hidden in Portfolio Analyser view
    ... this setting only controls the initial display of the Portfolio ... Same goes with the display of the toolbars for them as well. ... > both for the pivot table and the chart. ...
    (microsoft.public.project.pro_and_server)