calculated field in pivot - how to edit

[Tracey]

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

 

[Herbert Seidenberg]

Need sample of source, pt and cf data.

 

[ryguy7272]

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.ht
http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/


HTH,
Ryan--

 

[Fred Smith]

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

Regards,
Fred