calculated field in pivot - how to edit
 

Hello,

I have a pivot with calculated fields in, however they seem to be bringing
back incorrect data eg.

Total Number of points: 23
Number of correct points: 16
Percent correct: 61.1% where it should read 69.5%

now I need to know how I can view what formula has been used so that I can
correct it.

Thank you
Tracey

calculated field in pivot - how to edit
 

Need sample of source, pt and cf data.

calculated field in pivot - how to edit
 

You are doing something wrong. Check the references very carefully. I've
been using pivot tables since, well, for a very long time and I've never once
experienced the kind of results you are describing.

http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.babeled.com/2008/07/18/ex...-manipulation/


HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Herbert Seidenberg" wrote:

Need sample of source, pt and cf data.
.

calculated field in pivot - how to edit
 

Is the problem as simple as you need to refresh the Pivot Table?

Regards,
Fred

"Tracey" wrote in message
...
Hello,

I have a pivot with calculated fields in, however they seem to be bringing
back incorrect data eg.

Total Number of points: 23
Number of correct points: 16
Percent correct: 61.1% where it should read 69.5%

now I need to know how I can view what formula has been used so that I can
correct it.

Thank you
Tracey