Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas and Pivot tables
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
pivot tables custom formulas | Excel Discussion (Misc queries) | |||
Formulas and Pivot Tables | Excel Discussion (Misc queries) | |||
can conditional formulas be used in or with pivot tables | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |