Create a Calculated Field in Your Pivot Table

When someone wants to see an additional field in your Pivot Table – e.g. to show the “Price per Units Sold,” you create a “Calculated Field.” This is a fairly simple process. In this video, Danny will show you how. This is yet another example of how you can use the power of a Pivot Table to present data the way that you – or your audience – want to see it.

Here are the steps to follow in this lesson:

1. On the Pivot Table drop-down menu select “Formulas, Calculated Field.”
2. In the dialog box, write in a Name for your new Calculated Field.
3. Enter the Formula. Use the Fields in your Pivot Table and any operators (+,-,*,/) Click OK.
4. Use the Field Settings to change any formatting, etc.

Find the Excel Training Video you want

• Index to all Excel Topics

My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.

Get a Free 28 Minute Excel Video Tutorial

Follow this link for information to download – “Introduction to Pivot Tables in Excel 2003”