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

Share this content
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

Replies

Please login or register to join the discussion.

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