Excel Pivot Table 

Excel Pivot Table Additional Resources 
Inserting A Calculated Field Into A Pivot TableExcel lets you create new calculated fields for an Excel pivot table.This is a field in a PivotTable report or PivotChart report that uses a formula you create. Calculated fields can perform calculations by using the contents of other fields in the PivotTable report or PivotChart report. For example, if you have a field named TotalSales, you may want to create a calculated field to project sales for another period. The calculation would use the value of TotalSales. Calculated fields must reside in the DATA area of the Excel pivot table (you cannot use them in the PAGE, ROW, or COLUMN areas).
To create a calculated field in an Excel pivot table, follow these steps:
After you have created the new calculated field, it appears in the pivot table.
Inserting A Calculated Item To A FieldExcel enables you to create new calculated items for an Excel pivot table.This is an item within a PivotTable field or PivotChart field that uses a formula you create. Calculated items can perform calculations by using the contents of other items within the same field of the PivotTable report or PivotChart report. For example, if you have a field named Months, you can create a calculated item (called Q1, for example) that displays the sum of January, February, and March. Calculated items must reside in the PAGE, ROW, or COLUMN area of a pivot table (you cannot use them in the DATA area). To create a calculated item, follow these steps:
After you have created the calculated item, it appears in the Excel pivot table.
Display CalculationsIf you can't remember what the formula looked like or if you want to check your formulas that you've used, Excel can always display a list of the formulas you've used in your Excel Pivot Table.To display a list of formulas, follow these steps:
Refresh A Pivot TableIf you change the source data that is used by a pivot table, the pivot table doesn't get updated automatically. Rather, you must refresh it manually.To refresh a pivot table, use any of the following steps:
If the source database is large, there may be some delay while this recalculation takes place, but for small databases the update is virtually instantaneous.

Excel XP Topics Tips Excel Screen Layout  Navigational Techniques  Working with Workbooks  Templates  Working with Worksheets  Moving Around  Move Worksheets  Copy Worksheets  Insert & Delete Cells  Insert & Delete Rows  Insert & Delete Columns  Resize Row  Resize Column  Editing Data  Content Color  Cell Color  Number Formats  Fonts  Alignment  Text Direction  Indent Contents  Merge Cells  Copy  Move  Undo & Redo  Using Zoom  Freeze & Unfreeze Titles  Split Worksheet  Spreadsheet Data  AutoFill  AutoComplete  Comment  Find  Replace  Spellcheck  Formulas  Functions  Password  Sorting  AutoFilter  Advanced Filter  Macros  Charts  Charting  Charting Elements  Gantt Chart  PivotTable  PivotTable Calculations  PivotTable Layout  PivotTable Format  PDF to Excel  PDFtoExcel Converter  Excel to PDF Converter 