Calc Field not showing on New Sum Row in Pivot table
 

I have a pivot table that has several column fields and 2 data columns with a
calculated data field variance (data col1 - data col 2). There are also
several page fields that remain untouched.

When I take out a sum subtotal for a column field and add it back, I
recreate the same calculated field (delete the current one and create new
calc field) it works for every row but not for any sum subtotal that was
removed and then put back.

Any ideas?
--
MacGuy