View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Formulas and Pivot tables

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

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


Jaytee wrote:
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?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html