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.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.