Perhaps you could add a column to the source data, and do the
calculation there. Then, add that field to the pivot table.

Or, try changing the pivot table formula so it adds the two items,
instead of using an IF formula.

John P wrote:
I used a Formula in a Pivot Table and the the total for the formula Column
is INCORRECT as it reflects only one portion of the formula. My formula is
an "if statement" that if one field is "0" use the other preexisting field.
Is there a way to have the total reflelct all amounts and not just the total
of certain amounts??




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html