ExcelZone's Five Minute Tips aim to develop your skill at using Excel pivot tables. To test these tips for yourself, try them out on your copy of the pivot_practice.xls database.
In Excel 2003 Microsoft removed the Formulas option from the main pivot table menu and hid it away in the Pivot Table toolbar. Im sure many people don't realise that the Formulas option exists, yet it is an extremely useful feature.
FormulaCalculate Fields allows you to calculate a new field by adding several fields together. (We looked at this option in Pivot Tip #6 - How to use formulas in a pivot table.)
Use its companion FormulasCalculated Item to calculate a new field by adding together several values within a single field.
A worked example will make the difference clear.