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.

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

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

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

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