Beginning Pivot Tables in Excel 2007

 

Your worksheet formulas can create traffic-light charts, highlight chart elements, assign number formats, and more.

 

Categories

 

Learn how to create Excel dashboards.

Pivot Table Calculated Field: Tasks Per Hour

Instead of creating formulas in the source data for your pivot tables, you can create formulas in the pivot table, by using calculated fields and calculated items. In this example, we’ll create a calculated field, to show the number of tasks per hour that are completed by each worker. In the source data, each record [...]

Pivot Table Calculated Field Removed with Excel VBA

If you’re working with pivot table calculated fields in Excel VBA programming, or trying to use the Orientation property for data fields, you might encounter some problems. Here’s how I managed to work around an error that occurs when you try to remove a calculated field from the pivot table layout with Excel VBA. Strange [...]

Problem With Pivot Table Calculated Field Totals

You can create a calculated field in a pivot table, to perform calculations based on the Sum of a pivot table field. For example, this formula would calculate a bonus based on the total number of units sold for each product. If 60 or more were sold, then the salesperson would receive a 3% bonus [...]

Remove Calculated Field From Excel Pivot Table

After you create a calculated field in an Excel pivot table, you might want to remove it from the pivot table layout. You can temporarily remove a calculated field, or you can permanently remove it. In this example, the pivot table has a calculated field named Bonus. It appears in the Values area as Sum [...]

Create a List of Pivot Table Formulas

If you’ve used calculated items and calculated fields in your pivot table, you can automatically create a list of all the formulas. List the Formulas in Excel 2007 Select any cell in the pivot table. On the Ribbon, under the PivotTable Tools tab, click the Options tab. In the Tools group, click Formulas Click  List [...]

Related Posts Plugin for WordPress, Blogger...