Create a List of Pivot Table Formulas

If you’ve used calculated items and calculated fields in your pivot table, you can automatically create a list of all the formulas.

List the Formulas in Excel 2007

  1. Select any cell in the pivot table.
  2. On the Ribbon, under the PivotTable Tools tab, click the Options tab.
  3. In the Tools group, click Formulas
  4. Click  List Formulas.

PivotFormList01

A new sheet is inserted in the workbook, with a list of the calculated fields and a list of the calculated items.

PivotFormList02

List the Formulas in Excel 2003

  1. Select any cell in the pivot table.
  2. On the Pivot toolbar, click PivotTable.
  3. Click Formulas, then click  List Formulas.

PivotFormList03

A new sheet is inserted in the workbook, with a list of the calculated fields and calculated items (see the Excel 2007 example above).

    ___________________________

    For more information on pivot tables, see the Pivot Tables on my Contextures web site.

    ___________________________

Share and Enjoy

  • Facebook
  • Twitter
  • Google Plus
  • LinkedIn
This entry was posted in Calculated Field, Calculated Item, Pivot Table, PivotTable. Bookmark the permalink.

4 Responses to Create a List of Pivot Table Formulas

  1. Dirk says:

    Your post Create a List of Pivot Table Formulas | Excel Pivot Tables was very interesting when I found it over google on Friday by my search for excel 2003. I have your blog now in my bookmarks and I visit your blog again, soon. Take care.

  2. Debra Dalgleish says:

    Thanks Dirk, glad you liked the post on pivot table formulas.

  3. jhansi says:

    Hi,

    It’s Very use ful to Employees & Students Bez It’s very nice method & easy to larn.

    Thank you so much for providing this …
    Regards Jhansi….

  4. Jega says:

    Hi,

    Do you have any idea on how to add grand total in available field list in pivot.

    Grand total value should be dynamic again based on the pivot table page be selection.

    Regards
    Jega

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>