Pivot Tip 6 - Use Formulas to create calculated fields. By David Carter
David Carter's series of Five Minute Tips aims to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database.
Using formulas in a pivot table
One of the greatest benefits of Excel is the power to take two numbers and create a third by using a formula. Formulas are also available in pivot tables. However, you have to be extremely careful when using them, as I found out when preparing this tip!