Use Calculated Columns In Excel Table. To insert a Calculated Field execute the following steps. If you dont have your table yet please see How to insert an Excel table for more details.
Calculated columns By entering a formula in one cell in a table column you can create a calculated column in which that formula is instantly applied to all other cells in that table column. A Calculated Field is a custom column or field created by using existing columns of pivot table by applying formulas so this calculated field is a virtual column for pivot table which does not exist in the actual data table. There are a lot of benefits of using a Pivot Table Calculated Field as we will see in a minute.
Consider Calculated Field as a virtual column that you have added using the existing columns from the Pivot Table.
Every Excel user knows what absoluterelative references are and what the dollar sign does. A calculated field uses the values from another field. Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. A Calculated Field is a custom column or field created by using existing columns of pivot table by applying formulas so this calculated field is a virtual column for pivot table which does not exist in the actual data table.