Formulas Referencing Pivot Table results

J

Jkiser

I'm using a pivot table to sum batting statistics. I
calculate the batting average by referencing cells in the
table.

However, when I add a new batter or remove a batter, and
refresh the table, the formula references are incorrect.

Why is that and is there a way to maintain formula
references as new batters are added/removed?

Thanks

John
 
D

Dave Peterson

It sounds like you could use a calculated field in your pivottable.

show the pivottable toolbar if it's not already shown.
click on PivotTable dropdown
click on formulas
click on calculated field

Give it a nice name (Batting Average?).
and make the formula
=hits/atbats
 
Top