Formulas and Pivot tables

G

Guest

I compare call volume to reservations made with a pivot table that reduces
daily numbers by reservationist to weekly or monthly averages. I want to
divide the reservations by the call volume to arrive at a percentage for each
reservationist. I can create formulas outide the pivot table, but when I
adjust the table, the formulas no longer work. Any ideas?
 
D

Debra Dalgleish

You could create a calculated field in the pivot table --

Select a cell in the pivot table
On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Field
Type a name for the field, and in the Formula box, enter a formula to
divide reservations by call volume.
 

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

Pivot Tables - Count Numbers vs. Count 1
Formulas in Pivot Tables 2
Limitations for Calculated Field formulas in Pivot Tables 1
Pivot Table - Calculated Field - Percentage - Rept 2
Pivot tables calculated fields 2
Duplicating Pivot Tables 2
Pivot Table - Count If 2
Pivot table, IF function, calculated item versus calculated field 1

Top