If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|