Pivot Table Subtotals - Calculated field subtotal incorrect

R

reddy

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.
 
R

reddy

The formula for Calc%toStd refers to Std/Hr and CalcProd/Hr. I am guessing
this is not possible huh?
 

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

Similar Threads

% of subtotal in pivot table 1
Pivot Table Subtotals 1
Pivot Table - Calculated Field - Percentage - Rept 2
Pivot Table Calculated field error 1
pivot table - hide details but show subtotal for calculated field 1
Subtotal based on a range of data in Pivot Table 5
pivot table - subtotal below detail 6
calculated field - Pivot Table 1

Top