Formulas Referencing Pivot Table results

  • Thread starter Thread starter Jkiser
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2003 formula for Pivot 1
Pivot Table 2
Pivot table question 3
Referencing a pivot tables Grand Totals Column 1
grouping multiple tables Excel 2007 3
Formulas in Pivot Table 4
Formula fields in Pivot Tables? 1
Easy way to change Pivot table source files? 5

Back
Top