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.
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)