In the Name box, type a name for the calculated item.ĥ. On the Options tab, in the Tools group, click Formulas, and then click Calculated Item.Ĥ. Click the field where you want to add the calculated item.ģ. If items in the field are grouped, on the Options tab, in the Group group, click Ungroup.Ģ. For example, to calculate a 15% commission on each value in the Sales field, you could enter = Sales * 15%.ġ. To use the data from another field in the formula, click the field in the Fields box, and then click Insert Field. In the Formula box, enter the formula for the field.

In the Name box, type a name for the field.Ĥ. On the Options tab, in the Tools group, click Formulas, and then click Calculated Field.ģ. For instance, the field 'Month' could have items such as 'January,' 'February,' and so on.) within a field.Ģ. * Use a calculated item when you want your formula to use data from one or more specific items (item: A subcategory of a field in PivotTable and PivotChart reports. * Use a calculated field when you want to use the data from another field in your formula. Decide whether you want a calculated field or a calculated item within a field. OLAP data is organized hierarchically and stored in cubes instead of tables.) data source.ġ. NOTE: You cannot create formulas in a PivotTable report that is connected to an OLAP (OLAP: A database technology that has been optimized for querying and reporting, instead of processing transactions.

How to use pivot charts in excel 2007