Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Tables Based on Filtered Data | Excel Worksheet Functions | |||
Pivot Tables with different groupings based on same data table | New Users to Excel | |||
2 data sets in pivot tables | Excel Worksheet Functions | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions |