View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Calculated Field Total in Pivot Table

Paste the contents of the cell here for inspection

Arleen wrote:

I have a calculated field that contains the (*) multiplier in the formula.
The data populates properly, however the "Grand Total" which I have set up as
a "sum" does not sum up properly.

Total works fine if I don't have the (*) in the calculated field formula.
Any ideas how I can fix?