| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula in pivot excel 2007
It used to be possible to enter a formula within a pivot table so it would
update if the pivot table was changed. E.g. one column divided by another and the formula would be avaiable even for extra lines if another variable was used. Is this still avaiable in new excel, and if so, where? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula in pivot excel 2007
In EXCEL 2007 take the following action:-
PivotTable Tools Options Tools group Formulas Calculated Field The Insert Calculated Field pane should launch. In here you are able to set up to divide one column by another. If my comments have helped please hit Yes. Thanks. "Light" wrote: It used to be possible to enter a formula within a pivot table so it would update if the pivot table was changed. E.g. one column divided by another and the formula would be avaiable even for extra lines if another variable was used. Is this still avaiable in new excel, and if so, where? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Tables & Excel 2007 | Excel Discussion (Misc queries) | |||
| Edit Formula in Pivot Table for 2003 and 2007-how? | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot tables | Excel Worksheet Functions | |||
Linear Mode
