Use this controls on the Calculated Columns tab to define calculated columns that you may select from the Available Columns list on the Data Layout tab in Options.
Highlight a column in Selectable Columns list.
Use the Operators and Numbers or another column to add calculations to the formula.
You may also select one of the available Functions to add calculations to the formula.
Use the Format drop down to define the decimals to be used.
The Filters function allows you to create a filtered calculated column. From the Filters drop-down list, select the applicable filter. The list of filters are based on saved advanced filters on the filters tab. The calculation will only be applied to rows that pass the filter.
Click in the Global Value checkbox to create a calculation that can be used as a global total. The value is summed up for the entire report and can be used in other calculations.
From the For Group drop-down list, select the group for which you want to perform calculations for each member of the group separately.
Click the Clear button.
Type a name for your Calculated Columns configuration in the text box in the Formats section.
If you have applied filters on the Filters tab and want to save them along with your Calculated Columns configuration, select the Persist Filters check box.
Click the Save button.
Select the Calculated Columns configuration name from the drop down in the Formats section.
Click the Reload button.
Return to the View tab to see the results.
Select the Calculated Columns configuration name from the drop down in the Formats section.
Click the Delete button.