Calculated Fields and Calculated Items

significant benefits to integrating your custom calculations into your pivot table, which include the following:

 

􀀃 The elimination of potential formula and cell reference errors

􀀃 The capability to add and remove data from your pivot table without affecting your calculations

􀁑 The capability to auto-recalculate when your pivot table is changed or refreshed

􀁑 The flexibility to change calculations easily when your metric definitions change

􀁑 The capability to manage and maintain your calculations effectively

 

Does this mean you have just added a column to your data source? The answer is no.

Calculated fields are similar to the pivot table's default subtotal and grand total calculations

in that they are all mathematical functions that recalculate when the pivot table changes or

is refreshed. Calculated fields merely mimic the hard fields in your data source, enabling

you to drag them, change field settings, and use them with other calculated fields.