software

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 gt; Formulas gt; Calculated Field
Type a name for the formula, and enter your formula, e.g.:
= TotalSales / Units

Click OK

Belinda_Tim wrote:
gt; I am trying to divide one field with another inside the pivot table.
gt; There are formula options (% of base field and base item) within the field
gt; settings but these are not what I am looking for.
gt; Is there another way to create calculations inside the pivot table.
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks!

quot;Debra Dalgleishquot; wrote:

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