Pivot Tip 23 – Create group totals via Formulas–Calculated Item. By David Carter

Kashflow logo
0

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.

Practice Se...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk 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.

Share this content

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.