View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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