formula in pivot excel 2007

L

Light

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?
 
T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New To Pivot Tables 4
Possible to create formula columns within Pivot Tables? 1
Select a cell in a Pivot table 2
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Access #Error & Excel Pivot 0
pivot table 1
conditional formula 1
Pivot Table Comparisons in Excel 2007 2

Top