• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Pivot Table calculations add to your Excel toolbox

Get PDF file

by on
in Excel Training,Office Technology

The ability to extend the capability of your Pivot Tables with calculations can take your data crunching to another level. Here are three techniques to add to your Pivot Table toolbox.

Calculated fields

You’ll find both calculated fields and calculated items on the Pivot Table Tools Options contextual tab (Analyze in 2013). Creating a calculated field actually adds a field to your field list that you can select or unselect. If you have several Pivot Tables built from this data, the new calculated field will be added to all of your Pivot Table field lists.

Example: Say you have 12 columns of quarterly data and want to show quarterly totals. In the Calculations group, click the Fields, Items, & Sets button. Choose Calculated Field. Name this new field First Quarter. The formula is built similarly to any other formula in Excel, except that you use the Insert Field button to build the expression. It is similar to the way express...(register to read more)

To read the rest of this article you must first register with your email address.

Email Address:

{ 2 comments… read them below or add one }

RSO Oil May 2, 2017 at 8:45 am

Thanks for publishing this awesome article.

I’m a long time reader but I’ve never been compelled to leave a comment.

I subscribed to your blog and shared this on my Twitter. Thanks again for
a great article!


BMD Editors May 16, 2017 at 5:13 pm

You’re welcome! We’re glad you found the article helpful. Thank you for the positive feedback!


Leave a Comment