How do you create formulas in pivot table eg simple division?

I am trying to divide one field with another inside the pivot table.
There are formula options (% of base field and base item) within the field
settings but these are not what I am looking for.
Is there another way to create calculations inside the pivot table.

You can create a calculated field --

Select a cell in the pivot table
On the pivot table toolbar, choose PivotTable > Formulas > Calculated Field
Type a name for the formula, and enter your formula, e.g.:
= TotalSales / Units

Click OK

Belinda_Tim wrote:
> I am trying to divide one field with another inside the pivot table.
> There are formula options (% of base field and base item) within the field
> settings but these are not what I am looking for.
> Is there another way to create calculations inside the pivot table.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks!

"Debra Dalgleish" wrote:

> You can create a calculated field --
>
> Select a cell in the pivot table
> On the pivot table toolbar, choose PivotTable > Formulas > Calculated Field
> Type a name for the formula, and enter your formula, e.g.:
> = TotalSales / Units
>
> Click OK
>
> Belinda_Tim wrote:
> > I am trying to divide one field with another inside the pivot table.
> > There are formula options (% of base field and base item) within the field
> > settings but these are not what I am looking for.
> > Is there another way to create calculations inside the pivot table.
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>