Pivot Tip 23 – Create group totals via Formulas–Calculated Item. By David Carter
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. I’m sure many people don't realise that the Formulas option exists, yet it is an extremely useful feature.