Pivot Table calculations add to your Excel toolbox — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Pivot Table calculations add to your Excel toolbox

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:

Leave a Comment