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?

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?