| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Subtotals - Calculated field subtotal incorrect
I have a pivot that has the following:
I have 2 calculated fields for the last 2 columns The subtotal for the last column is calculating incorrectly: Activity Agent Std/Hr Vol Time CalcProd/Hr Calc%toStd Presort John 12 25 2 Hrs (25/2)=12.5 (12.5/12)=104% Presort Jane 12 55 3 Hrs (55/3)=18.3 (18.3/12)=152% Subtotal 12 80 5 (80/5)=16 XXX Please advise as to how to make the subtotal for the "Calc%toStd" calculate correctly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Blank SubTotal in Calculated Field | Excel Worksheet Functions | |||
| Incorrect total of calculated field in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table formula (calculated field) result is incorrect | Excel Worksheet Functions | |||
| Pivot table calculated field and subtotal | Excel Worksheet Functions | |||
| Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
Threaded Mode
