Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - calculations based on different sets of data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - calculations based on different sets of data
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Anéll" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - calculations based on different sets of data
Excel 2007
Easily done inside the PivotTable, with extended source data. http://www.mediafire.com/file/ydzayy...07_08_09a.xlsx Not so easy with Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |