Thursday, August 4, 2011

Create your own formula in a PivotTable

1. Select a cell in the Pivot Table report.

2. Press Alt+jt+j+f or you select option than Formulas and then Calculated Field.

3. In the Insert Calculated Field dialog box, type the formula name in the Name box.

4. In the Fields list box, select the first field name to insert and click Insert Field. The field name is copied into the Formula box.

5. Type / (in this example), repeat step 4 to insert the second field into the formula, and then click OK.

6. To format the new field, select a cell in the field and click the Field Settings icon on the Pivot Table toolbar.

see this......

No comments:

Subscribe Now: From your browser

Search:

Learn Office Excel