Pivot tables - calculations based on different sets of data

A

Anéll

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!
 
S

Shane Devenshire

Hi,

We don't have access to the detail within the pivot table that is probably
necessary for you to do this. You can make the calculation outside the pivot
table using the GETPIVOTDATA function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top