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

B

Belinda_Tim

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.
 
D

Debra Dalgleish

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
 
B

Belinda_Tim

Thanks!

Debra Dalgleish said:
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
Click to expand...
 
Top